SQL Server R2 How to open a remote connection to a database

SQL Server 2008 does not allow remote connections by default, and if you want to connect to SQL Server 2008 on a remote server by using SSMs locally, connect to the database remotely. You need to do two-part configuration:

1,sql Server Management Studio Express (SSMS)

2,sql Server Config Manager/sql Server Configuration Manager (abbreviated SSCM)

Tools/Materials

• SQLServer2008

Steps/Methods

2. 1

   Open sql2008, log on with Windows identity

4. 2

   After logging in, right-click on "Properties". On the left, select "Security" and select "SQL Server and Windows authentication mode" on the right to enable hybrid login mode

6. 3

   Select "Connect", check "Allow remote connection to this server", then click "OK"

8. 4

   Expand Security, login name; SA ", right-select" Properties "

10. 5

    On the left, select General, select SQL Server authentication on the right, and set the password

12. 6

    Right-click on the database Select "Facet"

14. 7

    Select Server configuration in the Aspect drop-down box on the right, set the Remoteaccessenabled property to True, and click OK

16. 8

    Now that SSMs is set up, exit and log in with SA, success means that the SA account is enabled

18. 9

    Open SQL Server Configuration Manager

20. 10

    Start by configuring SSCM, check the SQL Server service on the left, and make sure that SQL Server on the right and SQL Server Browser are running

22. 11

    On the left, select the SQLExpress protocol under the SQL Server Network Configuration node, the TCP/IP default on the right is "no", right-enable or double-click to open the Settings panel to modify it to "yes"

24. 12

    Select the IP Address tab and set the TCP port to "1433"

26. 13

    "TCP/IP" of the client protocol is also modified to "Enabled"

    When the configuration is complete, restart SQL Server 2008. You should be able to use it at this time, but still have to confirm the firewall. Open the firewall settings. The SQLServr.exe (C:\Program Files\Microsoft SQL Server\mssql10. Sqlexpress\mssql\binn\sqlservr.exe) is added to the Allowed list.

    END

Precautions

• Remote connection string: "Server=ip address; Initial catalog= database name; User Id=sa; password= Password "

• 1,2005 's surface area Configurator was changed in 2008.

  2, some settings take effect need to restart SQL Server

SQL Server R2 How to open a remote connection to a database