I have a newly inherited SQL Server that was installed and setup by our Windows Administrators. I am able to remote into the box and run SSMS using my network credentials. However, I am not able to use SSMS on my local computer to connect to the SQL Server. Here is the message that I receive:
"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: TCP Provider, error: 0 - The wait operation timed out.) (Microsoft SQL Server, Error: 258)"
Running SSMS 2012 Windows 7 Remote SQL Server 2012 64-bit
Here is what I have tried and looked into:
- The SQL Server is running. All protocols are enabled and TCP/IP is listening on the default port.
- The SQL Server Browser is running.
- My network credentials have been added to the SQL Server with sysadmin permissions.
- SQL Server is set to allow remote connections to the server.
I have asked our Windows Admins to look into Firewall settings. Is there anything else that I can check?