ASP pages were properly connecting to SQL DB until I restored from a backup DB. As soon as I finished restoring from the backup DB, I am getting the following error message. I did not make any changes on ASP side. IIS Server and SQL 2K Server is running on a WIN2K Server Box.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
Technical Information (for support personnel)
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login 'DB name'. Login fails.
/FMPFS/FMWebFinCo.asp, line 58
Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648; InfoPath.2)
POST 60 bytes to /FMPFS/FMWebFinCo.asp
Thursday, October 02, 2008, 5:58:26 PM
This error is most likely caused by a password mismatch. Have you try login w/ the same username / password with a SQL client?
DiscountASP.NET: Developer Ready ASP.NET Web Hosting
- Microsoft Gold Certified Partner
- Voted 2008, 2007, 2006 & 2005 Best ASP.NET Web Hosting by asp.netPRO Magazine