Shulou(Shulou.com)06/01 Report--

This article mainly introduces the Visual Studio 2005 SQL Server 2000 connection method related knowledge, the content is detailed and easy to understand, simple and fast operation, has a certain reference value, I believe that everyone after reading this Visual Studio 2005 SQL Server 2000 connection method article will have a harvest, let's take a look at it.

Now let's connect to the test data of Visual Studio 2005 SQL Server 2000. We open Visual Studio 2005 SQL Server 2000 and add a connection to SQL Server 2005 in the Server Explorer of the view. After entering the server name and the corresponding sa username and password for SQL Server authentication, select the corresponding database, and then click "Test connection", you will successfully connect to the database.

On this premise, you only need to set the authentication to SQL Server and Windows authentication. In SQL Server 2005, if you do this directly, you will report the following error: error establishing a connection to the server. When connecting to SQL Server 2005, SQL Server does not allow remote connections by default, which may cause this failure. (provider: named pipe provider, error: 40-connection to SQL Server cannot be opened).

We need to configure Visual Studio 2005 SQL Server 2000 separately, as follows:

1. Configure the SQL Server peripheral application server and enable the SQL2005 remote connection feature:

The mode of operation is as follows, click "configuration tool"-> "SQL Server Peripheral Application Configurator", and then select "Service and connection Peripheral Application Configurator" in the open window-> then select "remote connection" under the Database Engine node, select "Local connection and remote connection", and select "use TCP/IP and named pipes at the same time". After determination, you need to restart the database service.

two。 Change the login settings to Visual Studio 2005 SQL Server 2000 and Windows authentication mode, as follows:

Open the SQL Server Management Studio manager, right-click on the server and view the properties, and select "SQL Server and Windows Authentication modes" for service authentication in the security options.

3. Modify the password of Visual Studio 2005 SQL Server 2000 with the following body settings:

In SQL Server Management Studio Manager, expand Security on the server-> login name-> right-click the properties on the sa account to change the password for the sa login account in the General selection page. Note that in SQL Server2005, it is not allowed to set a simple password, otherwise it will fail. Then the login of the "status" on the selection page is changed to enabled.

This is the end of this article on "how to connect to Visual Studio 2005 SQL Server 2000". Thank you for reading! I believe you all have some knowledge of "Visual Studio 2005 SQL Server 2000 connection method". If you want to learn more, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.