Avatar of ets_dci
ets_dciFlag for France asked on

Connection to SQL Server 2005

Hello,

I Installed SQL Server 2005 standard edition on my server named : SRV-DPS. The instance name was let as default. Then  created a database named : LocToyota. On the server no problem. I can connect to the server in both mode : Windows Authentification and Sql authentification.

The problem is I can't connect to the server from another computer.

I can ping the server. It answers fine.

I join some screenshots.

Thanks for your help.
Img1.JPG
Img2.JPG
Microsoft SQL Server 2005

Avatar of undefined
Last Comment
ets_dci

8/22/2022 - Mon
ASKER
ets_dci

I forgot to precise that the server is running under Win Server 2008 R2 French.

SQL server 2005 with sp 4
ASKER CERTIFIED SOLUTION
sjurus

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
cubaman_24

Hello:
Remote connection are disabled by default on Sql Server. Use SQL Server Surface Area Configuration as suggested by jacko72 and enable remote connections to the server.
Best regards.
sjurus

If there is only one instance, SQL Server Browser does not have to be switched
After installing Win Server 2008 R2 firewall is on and there is no open port 1433
I agree to the TCP / IP is disabled by default
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
ASKER
ets_dci

I had to create an exception for SQLServer in the firewall.


Thanks for all