Trusted connections

[PaulPaulPaul]

Hello,

I have migrated a database form an onld server to sql 2000. THis dataabse is connected to a website using asp.

I am now getting this problem when I try and run the website.

Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.


Does anyone know how I set this user up for a trusted connection or what I have to do to get this working.

TIA

 

[tlbroadbent]

SA is a SQL Login not an NT login. It should not be connecting as a trusted connection. Make sure the connection string indicates Trusted Connection = NO. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[tlbroadbent]

By the way, using sa to connect from a web page is bad practice. You may opening your server to attack by hackers. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.