Enabling Remote SQL-Server 2008 Express Network Connections

How do i enable Remote Access to SQL Server 2008 Express?

Here are the steps that you can fallow to get it working:

  1. Open the SQL Server Configuration Manager (Programs -> Microsoft SQL Server 2008 -> Configuration Tools -> SQL Server Configuration Manager )
  2. Expand the SQL protocol node and select SQLEXPRESS
  3. Enable TCP/IP protocol by right-click -> Enable
  4. Right-click TCP/IP and click on IP-Address tab and scroll down to “IPAll”. Ensure that the Dynamic Ports contans a BLANK an add a port like 1433 (default) to IP-Port as the screens below.
  5. Click to the SQL Server Service node and restart your SQL Server (EXPRESS)

SQl Server Protocols: Protocol settings: SQl Server restart
By | 2016-10-22T11:39:42+00:00 February 9th, 2009|SQL Server, VS2008|8 Comments

8 Comments

  1. Skywalker 20/12/2010 at 20:19

    After reading about 5 articles about enabling Remote connections, I’m very happy that I finally found this post! None of the other posts talk about this IPAll configuration, which finally solved my problem.

    Thanks!!!

  2. hospedagem 31/05/2010 at 20:38

    Hello there. This really is kind of an “unconventional” question , but have some other visitors asked you how have the menu bar to appear like you’ve gotten it? I also have a weblog and am really trying to adjust around the theme, on the other hand I’m scared to death to mess with it for fear of the search engines punishing me. I am really a new comer to doing this …so i am just not positive precisely how to try to to it all yet. I’ll just keep working on it one day at a time Thanks for any help you can offer here

    • Daniel 03/06/2010 at 12:36

      Hi,
      the menu bar is the default from wordpress, can you explain your issue with a little bit more details may i can help you with this.

  3. blogs 03/05/2010 at 12:33

    Hehe that’s one way to observe that ūüėČ

  4. internet 03/05/2010 at 09:21

    Typically I actually do not post on blogs, however I would like to state that this post really compelled me to do so! really nice post.

  5. hospedagem de sites 08/04/2010 at 09:44

    Thanks

  6. Kelly Brown 13/06/2009 at 00:48

    I really like your post. Does it copyright protected?

    • admin 17/06/2009 at 14:34

      Do you want to copy it?

Comments are closed.