I have a classic ASP website. When I run the site locally on a Windows 2008 R2 server, it works perfectly. When I connect to the site from another machine and try to serve the page through iis 7.5, it fails with this error:
Microsoft OLE DB Provider for SQL Server error '80004005'
The line in the asp that it is failing on is:
Set conSQL6 = Server.CreateObject("ADODB.Connection")
conSQL6.Open strConSQL6
When I run this same application on a Win 2003 server there are no problems, both locally on the server and remotely.
Any ideas on how to make this work, a full re-write is not an option :)
From PRB: Troubleshooting Error 80004005 "Login Failed" in ASP
Cause
There are two reasons why this error may occur:
- Integrated security is turned on in the SQL Enterprise Manager, and the Microsoft Windows NT account that is being used has not been mapped to a SQL account.
- The User ID in the connection string is invalid or blank.
RESOLUTION
To resolve this problem, ensure that the following conditions are met:
- The Windows NT account is mapped to a SQL account.
- The User ID in the connection string is valid and is not blank.
Set standard security in SQL Server Enterprise Manager. To implement SQL Server standard security, follow these steps:
- From SQL Enterprise Manager, right-click the SQL Server name that appears in the Server Manager window, and then click Properties. (For SQL Server version 6.5 click Configure).
- Click Security Options, and then click Standard and Windows. (For SQL Server version 6.5 click Standard).
- The Password Synchronization option is turned off for that project if you are running under Microsoft Internet Information Server (IIS) 4.0.