Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
janetb
Yak Posting Veteran
71 Posts |
 Posted - 2005-08-15 : 10:52:59
|
| Have tables in sql2000, but using an AccessXP front-end. Mixed Novell/Microsoft environment. Users do NOT log into the SQL2003 domain. AccessXP has file dsn with user equated to dbo.When user starts up database, they get:Connection failed:SQLState: '28000'SQL Server Error: 18452microsoft,odbc sql server driver, sql server, login failed for user '(null)'Reason: not associated with a trusted SQL server connection.When I looked this up, MS says it's because mixed authentication mode is not selected on server. I have sql and windows selected on server. If I enter the same userid/password that is in the file dsn, everything works fine.I tried installed the sql client connectivity tools. Didn't help - same prompt.dsn:[ODBC]DRIVER=SQL ServerSERVER=WAHOODATABASE=telehealthUserID=DBUpdaterPwd=passwordTrusted_Connection=Yes Ideas? |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-08-16 : 12:07:24
|
| Remove the part that says "Trusted_Connection=Yes". A Trusted Connection is one that uses Windows Authentication. You are providing a UserID and Password, so it is SQL Authentication.---------------------------EmeraldCityDomains.com |
 |
|
|
janetb
Yak Posting Veteran
71 Posts |
Posted - 2005-08-16 : 12:15:12
|
| Thanks, EmeraldCity - I had started with that and received the same error. It's the error that's described exactly by the last item in KB279526 - except I'm not using Project. And, my file versions are 2000.85..... which makes them later that the files that are supposed to be okay.I even tried using a local machine dsn instead of a file dsn. No change.Anything else you can think of? |
|
|
|
|
|
|
AccessXP FE/ SQL2000 FE