none
Connect to remote SQL Database from LAN

    Question

  • Hi

     

    I am trying to conect to a remote database using SQL Management Studio Express from inside a LAN but get an error message indicating that the server does not accept remote connections. However, I can connect with no problems from outside our LAN.  I am looking for suggestions on how to resolve this issue

     

    Bob

    Wednesday, October 10, 2007 7:34 AM

All replies

  • By default in SQL Server Express Edition and Developer Edition, remote connections is not allowed. Did you check your settings from SQL Server Surface Area Configuration utility which can be found in Start\Programs\Microsoft SQL Server 2005\Configuration Tools?

     

    If not yet, fire it up and then click on Surface Area Configuration for Services And Connections and find your instance name. Expand Database Engine and click on Remote Connections. Enable Local and Remote Connections. Choose a checkbox which fits into your needs. You will need to restart your SQL Server service after setting this up.

     

    Now, let's check the SQL Server Configuration Manager for TCP\IP settings. You can find this tool from the same location that I explained above. Open it and go to SQL Server 2005 Network Configuration, find your instanes under that node and set your TCP\IP settings up. Enable TCP\IP or what protocol you need and then set up your IP and port settings from TCP\IP protocol. Restart your SQL Server service again.

     

    P.S.

    Be sure your firewall settings let these ports work.

    Wednesday, October 10, 2007 8:19 AM
  •  

    (a) Configure the Server (where the services installed ) for remote access.

    (b) You may need to excempt Ports from Firewall if you have firewall installed on server box

    (c) Makesure that SQL Server Browser Service is running

     

    Refer these kb...

     

    http://support.microsoft.com/kb/914277

    http://blogs.msdn.com/sql_protocols/archive/2005/12/22/506607.aspx

    http://blogs.msdn.com/sql_protocols/archive/2006/09/30/SQL-Server-2005-Remote-Connectivity-Issue-TroubleShooting.aspx

     

     

    Madhu

    Wednesday, October 10, 2007 3:51 PM
    Moderator
  • Odd that you can connect from outside the LAN but not from within.  (How are you connecting from outside?) 

    I believe that the above links describe how you need to setup user accounts---in Windows and then in SQL----for either Windows or SQL Authentication.  Then you need to grant those users Permissions to actually connect and to actually do stuff.

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2164297&SiteID=1

    That post describes both methods.
    I believe it contains the same links as above and a couple more you should find useful.

    Rudedog
    Wednesday, October 10, 2007 6:18 PM