Unanswered: ASP Apps cannot connect consistently to MS SQL 2000 on win 2003
Here's some background info:
We installed MS SQL Server 2000 on Windows 2003 Server and SP3a. During installation, we chose Windows Authentication. We tried to use OLEDB connection to connect to MS SQL 2000 but failed.
We re-installed MS SQL Server 2000 plus we installed SP3a. During installation, we chose Mixed Authentication. Then we used ODBC connection to connect to MS SQL 2000. It worked for a week then ODBC cannot connect to SQL Server again, message was failed logon. but we always used the same uid and password.
Anyone please help to solve this....ur help will b most apreciated!