Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
alanmac
Starting Member
26 Posts |
 Posted - 2010-11-02 : 04:35:01
|
| Hi,I have a SQL server (2008 R2) on a cloud server and can access it from SSMS on an internal server which has SQL 2005. I connect using a username and password.When I try to connect from another internal server using SSMS 2008, I can't get a connection. This other server is a virtual server.Is there a setting in SQL on the virtual server that is preventing the connection? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
alanmac
Starting Member
26 Posts |
Posted - 2010-11-03 : 03:22:38
|
| The error is:A network-related or instance-specific error occurred while establishing a connection to SQL Server. 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 Server) |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
alanmac
Starting Member
26 Posts |
Posted - 2010-11-03 : 09:09:15
|
| It turned out to be a firewall issue after all. The infrastructue team that checked it out were looking for port 443 (SSL) when they should have been looking for 1433.Thanks for your replies. |
|
|
|
|
|
|
Connecting to remote server