How to configure SQL Server 2005 to allow remote connections on Windows Server 2008 (Longhorn) / Windows Vista

re: How to configure SQL Server 2005 to allow remote connections on Windows Server 2008 (Longhorn) / Windows Vista

shibin — Sun, 04 Sep 2011 18:35:18 GMT

how can i configure server connection using c# code?

re: How to configure SQL Server 2005 to allow remote connections on Windows Server 2008 (Longhorn) / Windows Vista

David Overton — Wed, 02 Sep 2009 22:30:55 GMT

@GR,

try clicking the link in the blog post for the answer.

thanks

David

re: How to configure SQL Server 2005 to allow remote connections on Windows Server 2008 (Longhorn) / Windows Vista

GR — Wed, 12 Aug 2009 14:57:08 GMT

Could you explain step by step how to accomplish the following:

# Enable remote connections on the instance of SQL Server that you want to connect to from a remote computer.

# Turn on the SQL Server Browser service.

Thanks

re: How to configure SQL Server 2005 to allow remote connections on Windows Server 2008 (Longhorn) / Windows Vista

kk — Fri, 17 Apr 2009 09:00:41 GMT

How do I do this for sql server 2008 ? Express Advanced Edition

re: How to configure SQL Server 2005 to allow remote connections on Windows Server 2008 (Longhorn) / Windows Vista

Joe — Thu, 05 Mar 2009 16:19:34 GMT

Dude, you rock!!! That bit about enabling TCP connections was kind of obvious, but of course I overlooked it. Would have spent all day trying to figure it out.

re: How to configure SQL Server 2005 to allow remote connections on Windows Server 2008 (Longhorn) / Windows Vista

Torben Rohde — Thu, 11 Dec 2008 12:42:12 GMT

Thanks for posting.

I was going crazy trying to get remote access to our newly installed SQL Server 2008 - but that last bit about enabling TCP/IP was just what I needed :-)

Torben Rohde, Denmark

re: How to configure SQL Server 2005 to allow remote connections on Windows Server 2008 (Longhorn) / Windows Vista

steve — Tue, 01 Apr 2008 21:14:09 GMT

nice beach scene. Is it hawaii.

Anyway, your idea of a tutorial is like, minimal.

Kind of like, to enable sql server remote access you have to allow remote access. I don't see how to do anything in here. Good luck with future tutorials. Don't waste to much effort in them.

re: How to configure SQL Server 2005 to allow remote connections on Windows Server 2008 (Longhorn) / Windows Vista

Jonas Lewin — Thu, 02 Aug 2007 16:52:25 GMT

I had the exact same problem on my longhorn (Windows 2008 Beta 3) server. The only step I could skip was the last of your steps. Probably because my client was Vista and running IPv6.

Thanks for posting the info! and I like your design on this page.