October 31, 2006 at 7:34 am
Hey all,
I've a web application running on WinXp SP2 on a database server Win2K3 SP1 with SQL Server 2000 SE RTM in mixed mode. Both the machines are having correct versions of MDAC installed i.e 2.8 which the application uses.
I get the following error when loading any of the pages...
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'myuser'. Reason: Not associated with a trusted SQL server connection.
I use the following connection strings ( both are not working )...
Driver={SQL Server};Server=9.10.11.70;Database=C090506;Uid=myuser;Pwd=password
dsn=paysmart;uid=myuser;pwd=password;database=C090506
But one of our desktop application that uses DSN works perfectly on the same machine.
--Ramesh
November 1, 2006 at 6:39 am
Based on the error message it looks like the DB is expecting a trusted connection (Windows Authentication), but you are trying to feed it SQL authentication information. Look into you application code on specifing that you will be making an un-trusted connection so the DB will not expect a trusted connection.
Hope this helps.
Tokyoturnip
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply