Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Dec 17, 2012 01:01 PM by rickyaliasgar
Oct 24, 2008 05:48 PM|LINK
I’ve just installed sql server 2008 on a vista server, unfortunately I forgot to enable remote connection when I was installing it. As I need this feature really I tried to enable
I but “Surface Area Configuration” of sql 2005 seems to be vanished in this new version. Despite
I searched like 2 hours, I couldn’t find any useful solution,
interestingly all the results are either nonsense or related to 2005 version.
Please me what the hell should I do and I believe many people will use your answer!
Thank you in advance
Oct 24, 2008 06:18 PM|LINK
Do you have Sql Server Management Studio. If yes, then you can open it and right click the instance in question, go to Properties -> Connections -> Check "Allow remote connections to this server".
You might also have to enable TCP/IP Protocol to be enabled thru Configuration Manager.
Oct 24, 2008 06:40 PM|LINK
Thank you bullpit,
"Allow remote connections to this server" was already checked and TCP/IP was enabled [:'(]
Oct 24, 2008 06:53 PM|LINK
What is the problem now?
Oct 24, 2008 07:04 PM|LINK
I can not connect it with my vs.net 2008 server Explorer on my laptop
Oct 24, 2008 07:33 PM|LINK
Ridicules , it was vista firewall, once agane firewall teased someone ! thankfuly I learned how to enable reamote connection on 2008 at least !
Feb 03, 2009 03:54 PM|LINK
Hi, could tell me what was the problem with the firewall i am having some trouble with the same!
Hope you can. Thanks in advance
Remote Connection Enabled Sql 2005
Feb 05, 2009 10:34 AM|LINK
you have to open port 1433 for TCP , beware that you also need to use VS.net 2008
SP1 inorder to work with SQL 2008 without any problem !
Sep 11, 2009 07:18 AM|LINK
Verify that your sql browser service is running
Apr 01, 2010 03:17 PM|LINK
I am running SQL 2008 on Windows Server 2003, not Vista, and connecting to it using Windows 7. Is there a firewall setting somewhere, stopping me from connecting to ? If so, I cannot find it. Or is it a different issue? I have checked on the things in
this post. Thanks.