July 8, 2009 at 5:03 pm
Hi,
I cannot get SQL Server 2005 Management Studio to conenct to one server. I can connect to other servers and I can connect to the desired server using ODBC.
Any ideas would be greatly appreciated.
July 8, 2009 at 6:22 pm
I have found that Windows Firewall can cause this issue. Check to see if that server has the firewall configured correctly.
July 8, 2009 at 9:51 pm
Hello,
Can you post the Error that you get? In particular the Error Number, Level and State.
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
July 8, 2009 at 11:30 pm
Check you do have sufficient privilages to connect to the said server.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 9, 2009 at 5:52 am
Have you tried from a different machine? It could be something on your machine. Since you tried ODBC and it worked I don't believe it would be a DNS issue, however try and ping the machine with the name and see if it resolves.
July 9, 2009 at 10:20 am
Hi
Agreed with LeeM, most of times it is Firewall which is hindering the connection to SQL Server.:-)
July 9, 2009 at 12:48 pm
What port is the server running on?
You can test the port via telnet
cmd:
telnet ip address port
eg telnet 192.168.1.123 1433
If you can make the connection, not a firewall issue.
Any error message would help.
-tjm
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply