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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy