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 |
|
mreynol5
Starting Member
4 Posts |
 Posted - 2010-12-07 : 17:32:51
|
| CONFIGURATION: Server 2008 Express on 192.168.2.82Named Pipes & TCP/IP are enabledServer 2008 Express is installed on my development server which is tunneled via VPN to the remote server. I can aces the remote server via RDC and from that desktop I can access the database and its tables.When I try to access the main server from my remote server (Management Studio) I receive the following error message "A network related 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 the SQL Server is configured to allow remote connections. (provider, error: 40- Cound not open a connection to SQL Server)(MicrosoftSAL Server error:53")Michael Reynolds |
|
|
mreynol5
Starting Member
4 Posts |
Posted - 2010-12-13 : 11:17:55
|
| I managed to resolve the issue by adding an "alias" to the SQL server. I am not sure why this seems to work but it does.Michael Reynolds |
 |
|
|
|
|
|
Cannot connect to remote SQL