odbc connection will not authenticate

[mopacfan]

I'm trying to migrate an ASP app from a w2k server to windows 2003 and from sql2000 to SQL 2005. This is my connection string:

"Provider=SQLNCLI;Server=servername;Database=dbname;UID=username;PWD=P@ssw0rd;"

The problem is that SQL will not authenticate even though the username is set up in Active Directory and SQL is set up for SQL and Windows authentication.

I've been going crazy trying to figure out why this is not working. There are so many new variables in the mix that I don't know if it's the new W2003 server or SQL 05 or a combination of both.

Any help will be greatly appreciated.

 

[Chopstik]

I've had similar issues and usually been able to fix them by reviewing ConnectionStrings.com

------------------------------------------------------------------------------------------------------------------------
"Men occasionally stumble over the truth, but most of them pick themselves up and hurry off as if nothing ever happened."
- Winston Churchill

 

[mopacfan]

I've tried that. I have the correct string. I think I found the answer. I've been trying to authenticate against a domain account instead of a sql account. I'm going to create a sql account with the same name and see if that works.