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 |
|
bh0526
Yak Posting Veteran
71 Posts |
 Posted - 2015-03-27 : 09:59:59
|
| I have a SQL Server 2012 Express database on a network server. If I remote desktop to the server, then I can use SSMS on the server to connect. But I can not connect from my SSMS client on my PC. I can connect to a db on my PC and I can also connect to a db at our hosting company for our web site. But I can't connect to the db on our local server. Here is the error I get:TITLE: Connect to Server------------------------------Cannot connect to mriXXX\sqlXXX.------------------------------ADDITIONAL INFORMATION: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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)I enabled tcp and I also allow remote connections. The SQLBrowser was disabled and stopped but I enabled it and it's now running. So what am I doing wrong? |
|
|
bh0526
Yak Posting Veteran
71 Posts |
Posted - 2015-03-27 : 12:14:46
|
| I got it working. Using SQL Configuration manager, I did this:1. Right-click on TCP/IP and select Properties.2. Verify that, under IP2, the IP Address is set to the computer's IP address on the local subnet.3. Scroll down to IPAll.4. Make sure that TCP Dynamic Ports is blank. (Mine was set to some 5-digit port number.)5. Make sure that TCP Port is set to 1433. (Mine was blank.)#4 and #5 was the problem I had. I fixed this and restarted SQL and it now works fine. |
 |
|
|
|
|
|
Connection problem