The brothers developed by VS2005 know that when new website projects, ask for a website location, or use IIS to develop web servers, and use the file system, which is a web server running from VS2005. .
I have a project, which is developed in the "file system" mode. The database system is SQL Server2000. When development, everything is normal. But when I posted, we want to use IIS, when the project is deployed to IIS, visit SQLServer2000 The code cannot be executed. When connecting the database, it is enforced to access SQLServer 2005 and prompts
Solution:
1. Open IIS Properties - "Virtual Directory Properties -" Net 2.0- "Point 'Edit Configuration' -" Deletes all the items connected to SQLEXPRESS, it is best to delete the global configuration, open IIS properties - "Site Properties -" Select NET 2.0- "Point 'Editing Global Configuration' -" Deletes All Connection SQLEXPRESS Item 2. In the application server log: Exception type: SQLException exception message: An error occurred while establishing the connection with the server. When connecting to SQL Server 2005, SQL Server does not allow remote connections in the default settings that may fail. (Provider: Named Pipe Provider, Error: 40 - Unable to open to SQL Server connection) Request information: request URL: http://localhost/test/default.aspx request path: /test/default.aspx User Host Address: 127.0.0.1 Users: Whether I have passed the authentication: False Authentication Type: Thread Account Name: NT Authority / Network Service I judge is a problem with the SQL Server server. 3. Discover the Microsoft SQL Server 2000 version you run in the database log Or Microsoft SQL Server 2000 Desktop Engine has known security weaknesses when using the Microsoft Windows Server 2003 family. In order to reduce the computer being attacked by certain viruses, Microsoft SQL Server 2000, MSDE or both TCP / IP and UDP network ports are disabled. To enable these ports, you must install a patch from http://www.microsoft.com/sql/downloads/default.asp or http://www.microsoft.com/china/sql/downloads/default.asp, Or the latest service pack for Microsoft SQL Server 2000 or MSDE. So I changed a server that had just installed the system and downloaded the SP4 patch. Sure enough, even try again, success .... It seems to play more patch ....
