Board index » delphi » SQL 2000 'Not associated with a trusted SQL Server Connection'

AndyMG

Delphi Developer
Wed, 19 Nov 2003 07:55:46 GMT

SQL 2000 'Not associated with a trusted SQL Server Connection'

Delphi5 Pro & ADOExpress //all current service packs applied.
Client using Windows2000 Pro SP2.

I'm converting a client app which was used to connect to SQL7
Server - we have now upgraded to SQL2000, but the app now
falls at the first hurdle. I've traced the problem down to
ADOConnection.open

I'm using a standard connectionstring:
ADOConnection1.ConnectionString := 'Provider=SQLOLEDB.1;'+
          'Password='+password+';'+
          'Persist Security Info=true;User ID='+user+';'+
          'Data Source='+ServerName;

- but it's producing the following error:

"Project X raised exception class EOleException with message
'Login failed for user 'username'. Reason : Not associated with
a trusted SQL Server connection'. Process stopped."

Has anyone any advice?

Regards,

AndyMG.

 
Oliver Townshen

Delphi Developer
Thu, 20 Nov 2003 14:07:00 GMT

Re:SQL 2000 'Not associated with a trusted SQL Server Connection'


Quote
> "Project X raised exception class EOleException with message
> 'Login failed for user 'username'. Reason : Not associated with
> a trusted SQL Server connection'. Process stopped."

You can normally configure the SQL Server client to either take passwords,
or to work with trusted logins.  Check your client setup and you will
probably find that it requires trusted logins.  Simply change it to take
passwords or trusted logins.

Oliver

Freddy Biet

Delphi Developer
Sat, 22 Nov 2003 21:38:28 GMT

Re:SQL 2000 'Not associated with a trusted SQL Server Connection'


Start the SQL Server Enterprise
Right-Click on the your listed Server
Choose properties
select tab 'security'
change the settings of 'authentication' from 'Windows Only' to 'SQL Server
and Windows'

Freddy Biets

Quote
"AndyMG" <a...@andymg.co.uk> wrote in message news:3b182b82$1_2@dnews...

> Delphi5 Pro & ADOExpress file://all current service packs applied.
> Client using Windows2000 Pro SP2.

> I'm converting a client app which was used to connect to SQL7
> Server - we have now upgraded to SQL2000, but the app now
> falls at the first hurdle. I've traced the problem down to
> ADOConnection.open

> I'm using a standard connectionstring:
> ADOConnection1.ConnectionString := 'Provider=SQLOLEDB.1;'+
>           'Password='+password+';'+
>           'Persist Security Info=true;User ID='+user+';'+
>           'Data Source='+ServerName;

> - but it's producing the following error:

> "Project X raised exception class EOleException with message
> 'Login failed for user 'username'. Reason : Not associated with
> a trusted SQL Server connection'. Process stopped."

> Has anyone any advice?

> Regards,

> AndyMG.

Other Threads

1. Not associated with a trusted SQL Server connection--BDE error

2. BDE and SQL Server 2000 Trusted Connection

3. Connecting to SQL Server 2000 via tcp/ip through bde using trusted connection

4. SQL2000 'Not associated with a trusted SQL Server connection'

5. SQL server 2000 SQL problem - TOP doesn't work

6. Login fails on trusted connection to ms-sql 2000

7. Delphi 5, Sql 2000, trusted connections

8. SQL 2000 trusted Connection

9. associate a sql 2000 server stored proc with a variable

10. SQL Server 2000 isn't returning text fields