SQL Server 2008 Opens the extranet access feature

• Before setting up an extranet to access the SQL2008 database , you must first ensure that there is no problem with access SQL2008 within the LAN . Then, we first look at the local area network access to the SQL2008 database what steps and settings to be able to enter the SQL2008 database IP address and port number on any machine on the LAN can be accessed.

  1.sql2008 database-side settings

  Usually a machine installed SQL2008, to achieve LAN access SQL2008 only a few steps.

  1) Open the SQL2008 Configuration tool, steps: Start, All Programs, Microsoft SQL Server 2008, configuration tools, SQL Server Configuration Manager ";

  2) in the Open Configuration interface, double-click on the left "SQL Server network Configuration", you can see the protocol of the native installed DB instance, generally have "SQL Express protocol" and "MSSQLSERVER" protocol, if you do not use the default instance name when installing, So here you should find yourself a database instance name that you need to set up an extranet to access, double-click it;

  3) At this point, you can see four protocols, generally enable the first three, disable the last one, that is, enable "Shared memory", "Named Pipes" and "TCP/IP", disable "VIA";

  4) after enabling "TCP/IP", by the way the right mouse button the protocol properties, set the open port, in IP1-IP9 can be set to 1433, "active" and "Enabled" are selected "Yes", the last Ipall can also be set to 1433;ok, the configuration page must be in the SQL Restart the server under the Server service entry for the settings to take effect, and if that doesn't work, it is recommended that you restart your computer.

  5) You can turn off the configuration tool, then open "SQL Server Manager Studio", log in to your database, open after the "Object Explorer" to find your database server root node, right mouse button, select "Aspect", in the context drop-down menu, select "Peripheral Application Configuration", Find romotedacenabled below, set to True, and then restart the database, (this option does not seem to play a role in the course of my setup, not set to true as if the remote can also access);

  6) Set up here can basically achieve access to the SQL2008 database within the LAN. If not, please X:\Program Files\Microsoft SQL Server\mssql10. Mssqlserver\mssql\binn\sqlservr.exe sets the process exception in Windows Firewall and X:\Program Files\Microsoft SQL Server\90\shared\ Sqlbrowser.exe is set to an exception, the 1433 port is also set as an exception.

SQL Server 2008 Opens the extranet access feature