how to enable remote Connection sql server 2008

Ive 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 couldnt 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

Re: how to enable remote Connection sql server 2008

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.

Re: how to enable remote Connection sql server 2008

Thank you bullpit,

"Allow remote connections to this server" was already checked and TCP/IP was enabled [:'(]

Re: how to enable remote Connection sql server 2008

What is the problem now?

Re: how to enable remote Connection sql server 2008

I can not connect it with my vs.net 2008 server Explorer on my laptop

Re: how to enable remote Connection sql server 2008

Ridicules , it was vista firewall, once agane firewall teased someone ! thankfuly I learned how to enable reamote connection on 2008 at least !

Re: how to enable remote Connection sql server 2008

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

Re: how to enable remote Connection sql server 2008

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 !

Re: how to enable remote Connection sql server 2008

Verify that your sql browser service is running

Re: how to enable remote Connection sql server 2008

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.

Re: how to enable remote Connection sql server 2008

Try adding the "sql browser" and the "sql server database engine" to the allow programs on windows firewall. This may help you: http://msdn.microsoft.com/en-us/library/cc646023.aspx specialy the Dynamic Ports part...

Let me know anything.

Re: how to enable remote Connection sql server 2008

Did you figure this out Jess5K? I have the exact same setup and have no problem remotley connecting to my application database. But the connection won't work to the membership aspnetdb database. How did you fix this?

Re: how to enable remote Connection sql server 2008

What it comes down to is that you must go under the SQL Server 2008 Management tools in the Start Menu. Go under the Protocols for the instance you are trying to reach. Make sure that you have all protocols enabled for connection the database. Thanks.

Re: how to enable remote Connection sql server 2008

hi,

I am installing SQL Server 2008 in Windows XP with SP3.

I have enabled TCP/IP enabled, Named Pipe. Server Property -> Property -> Connection -> Allow remote connections to this server (Checked).

Open TCP/Port of 1433 in Firewall.

Now i amtrying to access this database from ASP.Net page. It will given an error 26.

Please help me.

Thanks in Advance.

Chandan

Re: how to enable remote Connection sql server 2008

HI,

I solved the problem.

Go to All Programs -> Microsoft SQL Server 2008 -> Configuration Tools -> SQL Server Configuration Manager.

Now Sql Server Configuration manager window will appear. Expand SQL Server Netwoek Configuration, select Protocol for MSSQLSERVER & right click on TCP/IP in detail pane go to property and Select IP Address tab. Select in

IP1=> Active=Yes, Enabled=Yes,IP Address =<machine ip address>, TCP Dynamic Port=Empty, TCP Port=1433

IP2=> Active=Yes, Enabled=Yes,IP Address =127.0.0.1, TCP Dynamic Port=Empty, TCP Port=1433

IP3=> TCP Dynamic Port=Empty, TCP Port=1433

And click ok & Restart your SQL Server Service. Run your ASP.Net application its working.

Thanks

Chandan

Re: how to enable remote Connection sql server 2008

Hi,

what instruction written above by chandan is right, this should solve the problem, but i have one good fine visual article which has screen shots too, which will help to configure. please find the link below so others can use it.

http://dotnetpedia.net/site/index.php?q=node/20

Re: how to enable remote Connection sql server 2008

Enable SQL browser service allow you to Remote Desktop connection

Re: how to enable remote Connection sql server 2008

Do you have an up to date or additional link to the one you provided above? I am having issues with my firewall and protocols and was hoping to use it as reference.

Thanks,

Re: how to enable remote Connection sql server 2008

deychandan

I realize this post is getting to be almost a year old, but your fix saved me as the server IP address had changed and updating the settings you indicated fixed the problem.

thank you,

Re: how to enable remote Connection sql server 2008

Hi chandan ,

i tryed your steps. but i get folloeing error

The request failed or the service did not respond in a timely fashion. consult the event log or other application error logs for details.