asp.net 2.0 connection Sql2000 times "provider:named pipes provider,error:40"

If the network, the database is not a problem, with WinForm can also be connected, then there is a possible reason is that Sqlserver2000 did not play SP4 patch. You can use the following SQL command to view:

Select SERVERPROPERTY (' ProductLevel ')

Installing SP4 patches is easy. The next step, but here's a little problem. Sometimes you cannot use a SQL account when installing SP4 and you use a Windows local account. So the database cannot be entered after the SP4 is installed. Let's talk about the solution.

1. If you cannot open the database because of an account problem in Enterprise Manager, delete it. Re-register one with Windows local account.

2. Select the database Instance-> property-> Security tab-> Check SQL Server and Windows

3. Select database instance-> edit SQL Server Registration properties-> Choose to use SQL Server Authentication to enter a login name and password.

By completing the steps above, you can log on to the SQL Server account