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

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

SQL Server 2005 and later versions do not allow remote connections, and if you want to connect to SQL Server 2008 on a remote server 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)

Configure remote Connection steps

1. Open sql2008, login with Windows identity

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

3. Select "Connect", tick "Allow remote connection to this server", then click "OK"

4. Expand "Security", "Login name"; " SA ", right-select" Properties "

5. Select "General" on the left, select "SQL Server Authentication" on the right and set the password

6, right click on the database selection "aspect"

7. Select "Server Configuration" in the right side drop-down box, set the "Remoteaccessenabled" property to "True", and click "OK"

8, so that SSMs has been set up, first quit, and then use SA login, success means that the SA account has been enabled

9. Open SQL Server Configuration Manager

10. Start configuring SSCM below, select "SQL Server service" on the left, and make sure "SQL Server" and "SQL Server Browser" are running on the right.

11, in the left select the SQL Server Network Configuration node under the SQLExpress protocol, on the right side of the TCP/IP default is "No", right-enable or double-click Open the Settings panel to modify it to "yes"

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

13, the "client protocol" of "TCP/IP" 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.

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

  Http://jingyan.baidu.com/article/6c67b1d6ca06f02787bb1ed1.html

  http://blog.csdn.net/loadrunn/article/details/6852358

  Http://bbs.51cto.com/thread-875892-1.html

  Http://www.cnblogs.com/geiliCode/archive/2011/09/24/2189766.html

  Http://baike.baidu.com/view/602831.htm?fr=aladdin

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