By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,683 Members | 1,597 Online
Bytes IT Community
Submit an Article
Got Smarts?
Share your bits of IT knowledge by writing an article on Bytes.

Connect Remote SQL instance from Vista Client

Shashi Sadasivan
Expert 100+
P: 1,435
Hi,
After some search around, trying to get my SQL Management studio (running on Vista) to connect to a remote SQL server instance, i finally nailed it.

Your management studio will refuse to connect onto the remote instances of SQL sever... One of the easiest way around this is to disable your firewall and then connect usually.

Well...this isint really a very good idea, and will drive you nuts atleast 2-5 times a day.
To overcome this one, Go to windows firewall -> change settings -> Exceptions Tab
Click on "Add Port" and add any name (I put in SQLPort) and keep the port number as 1433 (if you have not changed the port number) - > and hit ok

Now click "Add Program" and add sql management studio to the list.


Once thats done you should have absolutely no problems connecting in and out without having to toggle the firewall.
Oct 17 '07 #1
Share this Article
Share on Google+
1 Comment


Frinavale
Expert Mod 5K+
P: 9,731
Thanks Shashi Sadasivan!

I've seen someone else with this problem recently!

-Frinny
Oct 17 '07 #2