SQL Server 2005 problem - simple :)

Hi guys,

I just installed SQL server 2005, but I can't connect to it from my ASP pages; I think it's got to do with the username I enter in the connection string.

When I set up the server, I had to use Windows Authentication - but I need to make it work with username and password from the connection string. Any ideas as to how to do this? I looked through millions of posts, but none of them had any relevant info

Btw: I created a "sa" user, that lets me log in from a query analyzer of some sort; but I can't use that username and password from my asp pages, apparently.

Thanks for any help!

If I'm following you correctly, use your sa account to add an existing domain user and assign them rights to the database. Then use the domain user to connect instead of sa. If you have to use Windows authentication, remember sa is not a Domain user. Personally, I would have your Network Administrator create a user account specifically for your SQL databases, then simply use that one.

Follow the instructions here and it will probably solve your problem:
http://www.devx.com/tips/Tip/13156 (older article - but might still work)

or this
http://support.microsoft.com/kb/247931

Thanks a lot ATNO, I'll try this today and post the outcome