cannot connect to sql server remotely.

Last Post 03 Aug 2009 12:24 AM by hussam1977. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
xcao
New Member
New Member

--
07 Apr 2009 10: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

--
03 Aug 2009 12:24 AM
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.
You are not authorized to post a reply.

Acceptable Use Policy