Unanswered: xx.ASP failed login, Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
I wrote ASP routines to function on an IIS4 installed on a WIN2000 machine. These ASP routines worked perfectly well when connecting to an SQL7 db running on an NT4 server SP6.
When i changed the connection string in the ASPs to refer to an SQL7 db running on an WIN2000 server
(NEITHER SQL7 servr is physically running on the IIS4 servr, BOTH servrs are INSIDE the firewall protected area and on the SAME DOMAIN)
I got the following error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
The original SQL7 srvr and the new sql7 srvr are configured in the same way using the same naming conventions etc.
Can anyone give me a practical solution to this problem? THANKS!
I'm using a connect object in my ASP which in turn uses a "standard" connection string as shown below. I cannot tell for sure at this moment but i think the IIS service runs as a system acount. I use the default SQL security mode which is UID + password (in the example the password is empty).
This connectionstring worked perfectly when the ASP "runned between" the IIS4/WIN2000 and SQL7/NT4 servers. The DSN i typed later in the connectionstring however is an SQL7/WIN2000 server and from then on i got the error message i mentionned in my first post.
Well i checked with isql and it seems to function normally (isql -SSQLINTRANET -UProject -P -q"SELECT * FROM tblxxxxx"). isql returned the SELECT results in a normal fashion the output revealing the data i would expect.
I checked how SQLINTRANET is declared in the Network Client utility and it seems to be ok.
(Alias SQLINTRANET, Name SQLINTRA, Protocol TCP/IP, Port 1433, rpc out, rpc in)
i checked the ASP routines by using the old DSN in my connection object and they work ok.
I still cant tell whether IIS4 is running as system account under WIN2000. What i can tell is that i checked directory security of the ASP test directory in IIS manager. Anonymous login is set to true allowing IIS to check the password, as well as normal password/login check and Windows integrated security. Execute rights are given within the test directory by IIS.
SQL User "Project" has Public/Data reader-writer/Projectsgroup rights within SQL on the table tblxxxxx.
I haven't checked communications to and from the SQL server with SQL trace (profiler) yet (on my NT4/SQL7, profiler gave an error 1114 ! unable to load sqltrace.dll) - SQL Servicepack 4 installed.
One last remark, the SQL Servicepack on the SQLINTRA is SP3.
The situation remains the same. When i specify DSN SQLINTRANET in the connection string the error stays the same as in the first post.
I have a little confusion here, I always believed that DSN was used with ODBC. To create a DSN you used the ODBC Administrator to setup your connection and then from ASP you specify the DSN name. The Client Utility is used by SQL Server programs, isql, Query Analyzer, Enterprize Manager, etc.
Try removing the DSN and replacing it with the server name. Here is an example of what we use: