web Site environment:
Windows 2003 + SqlServer2000
has the problem of being unable to connect to the database when using a SQL account to connect to the database on the asp.net site. At this time, you can use both Enterprise Manager and Query Analyzer to connect to the data.
Solution: This problem can be solved after installing SQLserver2000 Sp3
Another time, the company's network administrator installed a 2003 system and SQL server 2000, and applied all the patches. However, when testing the site, a yellow page appeared, indicating that a certain field in a certain table during a certain query did not exist.
Finally, it was discovered that SQLserver was not in mixed mode and could not be connected using a SQL account (set to a Windows account). The fault was resolved after changing to mixed mode.