Problems connecting to server

• Ramesh Saive

  SSC-Insane

  Points: 24275

  More actions

  October 31, 2006 at 7:34 am

  #67802

  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
  

  ---

• Ron Aughenbaugh

  SSC Eights!

  Points: 975

  More actions

  November 1, 2006 at 6:39 am

  #669190

  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