Hi Everyone,
I am running into a problem and have been browsing the web and reading nonstop for answers with no success. My company just installed SQL Server 2005 and I am trying to connect to it via SQL Server Management Studio from my network computer in the same office building.
When I browse for Local or Network Servers in the initial popup box at SQL Management Studio Startup, it doesn't show any servers at all. Is there something I need to enable on the Server using the Configuration Manager or one of the other tools to allow my network computer to "see" the SQL Server?
Any insight would be MUCH appreciated. Even a link to a how-to would suffice. Thank you.
Is your server and your computer on the same network? To enumerate SQL server on your network, you must turn on SQL Browser on your server machine. Make sure UDP port 1434 is not blocked by any firewall on your server. Keep in mind you are not guaranteed to see all network instance as the enumration is UDP based and is not realiable. So, in this case, you'd better type your server name into the box directly. such server1 or server1\inst1, etc.
|||
read these article
http://msdn2.microsoft.com/en-us/library/ms165724.aspx
http://support.microsoft.com/default.aspx/kb/914277
http://support.microsoft.com/kb/287932/en
Madhu
No comments:
Post a Comment