CODEWITHSUNDEEP
sql-server-2005
Alex
Alex

Reputation: 83

Can't connect to SQL Server 2005 unless using 127.0.0.1

I'm not able to connect to sql server with anything but 127.0.0.1 on the server machine. If I try to connect via actual IP on the network it does not work locally or remotely.

The environment is SQL Server 2005 on Windows Server 2000. My goal is to connect to this SQL Server instance from a remote machine.

I've tried telneting to port 1433 using the actual IP and that fails. I've tried turning off Windows Firewall completely

Any ideas or help is greatly appreciated! Thanks

Upvotes: 1

Views: 190

Answers (2)

kishore
kishore

Reputation: 727

Did you check the firewall settings. You need to create exceptions to allow remote connections in the firewall

Upvotes: 1

Arnon Rotem-Gal-Oz
Arnon Rotem-Gal-Oz

Reputation: 25919

You have to enable remote connections - check this KB article

Upvotes: 1

Related Questions