Get the App
SLTechnology News&Howtos  ›  Development  › 

SQL Server 2008 R2:error 26 how to open a remote connection

Shulou Source: shulou.com Published: 2022-06-03 05:43:19 11月17日 Update

Editor to share with you how to open a remote connection with SQL Server 2008 R2:error 26. I hope you will get something after reading this article. Let's discuss it together.

When you create a new dataset and connect to the sql server 2008 database remotely during the learning ASP.NET process, the following error occurs:

Because sql server 2008 does not allow remote connections by default, and sa accounts are disabled by default, if you want to use SSMS (SQL Server Management Studio Express) locally

To connect to SQL Server 2008 on a remote server, you need to configure two parts:

1Jing SQL Server Management Studio Express (SSMS for short)

2SQL Server configuration Manager / SQL Server Configuration Manager (SSCM for short)

Here are the specific steps:

(1: open SSMS and connect to the database with windows identity. After logging in, right-click "Properties".

Select Security on the left and select SQL Server and Windows Authentication Mode on the right to enable mixed login mode

(2: select "Connect", check "allow remote connection to this server", and then click "OK"

(3: expand "Security"-> "login name"-> "sa", right select "Properties", then select "General" on the left, select "SQL Server Authentication" on the right, and set the password; select "status", select "enable", and click "OK".

(4: right-click the database to select "aspect", set the "RemoteAccessEnabled" property to "True", and click "OK".

(5: SSMS has been set up. Exit first, and then log in with sa. Success means that the sa account has been enabled.

Let's start configuring SSCM and open SSCM:

(6: check "SQL Server Service" on the left and make sure that "SQL Server" and "SQL Server Browser" on the right are running

(7: TCP/IP on the right: double-click to open the settings panel and change it to "Enabled"

Select the "IP Addersses" tab and set the port "1433"

Change "TCP/IP" of "Client Protocols" to "Enabled" as well

(8: restart SQL Server 2008 when the configuration is complete, or visual studio 2010:

(9: it should be ready to use at this time, but check the firewall: turn on the firewall settings. Add SQLServr.exe (C:\ Program Files\ Microsoft SQL Server\ MSSQL10.SQLEXPRESS\ MSSQL\ Binn\ sqlservr.exe) to the allowed list.

After reading this article, I believe you have a certain understanding of "SQL Server 2008 R2:error 26 how to open a remote connection". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

Tags: Select service configuration right data server login instance properties database identity authentication security security account mode shorthand article error firewall Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno MariaDB Linux Apple Docker MySQL