SSMS connection Error
-
Hi all,
I'm having an issue connecting to a SQL2008 instance which is built on Windows 2008. The error that I am getting is "Timeout Expired". The timeout period elapsed prior to completion of the operation or the server is not responding.
I am able to connect via sql analyzer.
Any assistance would be much appreciated.
Thanks
-
Is this a named instance or a default instance? You mentioned you that were able to connect to the instance, was this local to the server or from a remote client? What TCP port is the instance listening on? Can you confirm that an inbound rule exists for this TCP port in Administrative Tools -> Windows Firewall with Advanced Security.
Tommy
Follow @sqlscribe -
Default instance. I was able to connect both locally and remotely.
I would assume perhaps firewall may be causing this issue
-
Check the service. does the instance use the default port? How do you connect using ip/hostname. Some times if you have issues with dns the hostname may not work. Ping the host.
-
Try to connect using the server Ip-address
-
Yep, already tried all of that.
-
tst tou said that you could connect using the SQL Analyzer, Do you mean SQL Server Query Analyzer? Can you connect using SQLCMD? Is you SQL Server Browser Running?
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply