[SQL Server R2] Open database remote connection

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. On the left, select "General", select "SQL Server Authentication" on the right and set the password

6. Right-click the database Select "Facet"

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

8. Now that SSMs is set up, exit first, and then log in with SA, success means that the SA account is 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. 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"

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

13. Change the "TCP/IP" of the client protocol to "Enabled" configuration to complete and 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.

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

1.2005 of the peripheral Application Configurator changed place in 2008

2. Some settings require a restart of SQL Server