SQL Server 2008 R2:error 26 Open Remote Connection Details _ practical Tips

The following error occurred during the learning ASP.net process using a new dataset and remotely connecting to the SQL Server 2008 database:

<--A network-related or instance-specific error occurred while establishing a connection with SQL Server.
The server was not found or could not be accessed. Please verify that the instance name is correct and that SQL Server is configured to allow remote connections.
(Provider:sql network interfaces, error:26 – Error locating the specified server/instance)-->

Because SQL Server 2008 does not allow remote connections by default, the SA account is also disabled by default if you want to use SSMS locally (SQL Server Management Studio Express)

To connect to SQL Server 2008 on a remote server, you need to do two parts of the configuration:

1,sql Server Management Studio Express (abbreviated SSMS)

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

The following steps are specific:

(1: open SSMs, connect the database with Windows identity, and then right click on "Properties"

Select Security on the left, and select SQL Server and Windows authentication mode on the right to enable mixed logon mode

(2: Select Connect, check "Allow remote connections to this server", and then click OK

(3: expand Security-> "login"-> "sa", right-click on "Properties", select " General" on the left, select "SQL Server Authentication" on the right, and set the password, select "Status", select "Enable", click " Determine the

(4: Right-click the database to select "aspect", set the "Remoteaccessenabled" property to "True", and click "OK"

(5: This ssms has been set up, quit, and then log on with SA, success means that the SA account has been enabled

The following starts with configuring SSCM to open SSCM:

(6: Select the SQL Server service on the left to ensure that SQL Server and SQL Server Browser on the right are running

(7: The right side of TCP/IP: Double-click to open the Settings panel to modify it to "Enabled",

Select the IP addersses tab, set the port "1433",

Change the "Client protocols" TCP/IP to "Enabled"

(8: configuration complete, restart SQL Server 2008, if Visual Studio 2010 is:

(9: You should be able to use it at this time, but still confirm the firewall: open the firewall settings.) Will SQLServr.exe (C:\Program Files\Microsoft SQL Server\mssql10. Sqlexpress\mssql\binn\sqlservr.exe) is added to the Allowed list.