cannot connect to sql server remotely.

Last Post 02 Aug 2009 11:24 PM by hussam1977. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
xcao
New Member
New Member

--
07 Apr 2009 09:02 AM
I just intalled sql server 2005 on a windows 2008 64 bit server.
everything looks OK. It's using windows authentication.

I can connect to the server from management studio locally. But I cannot connect to this sql server from other sql server remotely.
I got an error:
cannot connect to the sql server:
A network-related or instance-specific error occurred while establishing a ... The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL ...

I checked the sql server browser is running, remote connection is enabled. Tcp/IP protocal is enabled.

The service account has access to the sql server.

What could be wrong?

I have no problem to connect to other sql server on our network.

Thanks
hussam1977
New Member
New Member

--
02 Aug 2009 11:24 PM
be sure accessing the server on the same VLAN, and port 1433 it's open to verify try to telnet the connected server to the port 1433 and check.


Acceptable Use Policy
---