"SQL Server does not allow remote connections" error Solution

This error occurs when DNN 4.8 is installed.

Connection Error (s ):
Index #:0
Source:. Net SqlClient Data Provider
Class:20
Number:53
Message:
An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by
Fact that under the default settings SQL Server does not allow remote
Connections. (provider: Named Pipes Provider, error: 40-cocould not
Open a connection to SQL Server)

Because the default settings for SQL Server 2005 Express Edition and SQL Server 2005 Developer Edition do not allow remote connections, refer to the MSDN documentation to change the settings: http://support.microsoft.com/default.aspx? Scid = kb; EN-US; 914277

I installed the Personal version of SQL 2000 and SQL 2005 Express (automatically installed with VS) on my machine. I am using the Personal version of SQL 2000. This issue should not exist. After some research, I found the answer.

Before SQL 2005 Express is installed, there is only one SQL Server on my machine. I usually use local in the connection string to specify the local SQL 2000 Personal version. After the Express version is installed, there will be two SQL instances on the machine.

One is LAND001 (my computer name) and the other is LAND001 \ SQLEXPRESS. At this time, if you still use local to refer to the SQL Server Personal version, DNN installation will not look for the Personal version, but find the Express version.

Solution: Use the SQL Instance name in the connection string to accurately specify the SQL Server to be used, such as LAND001.