dsn on winxp 2

[engan]

Hi all,

I try to create a system dsn (odbc for sql2000) on my win xp but it failed. I got an error message like this :

connection failed
sql server error 18452
user not associated with a trusted sql connection

I already setup user account and login account on my win2000 server and sql 2000 server.

When I try it using my win98, it works fine and I can connect to my sql2000 successfully.

How do I create odbc the right way from my winxp ?

Brdgs

Eng An

 

[SonOfEmidec1100]

When you create a DSN you have have a choice of authentication options - WindowsNT and SQL server.

A common cause of this message is you select SQL Server Authentication for the DSN but SQL Server is only set to allow Windows Authentication. (Server properties/ security tab.

 

[engan]

SonOfEmidec1100, it seems that I my password is not set on myxp. When I create a new password I can connect successfully. Thanks for your info.

Brgds
Eng An

 

[josel]

SonOfEmidec1100,

You got my star ... This is exactly why forums like this are invaluable to our community.

Regards;


Jose Lerebours

KNOWLEDGE: Something you can give away endlessly and gain more of it in the process! - Jose Lerebours