help with connecting to a database -

[Sanjes]

Hi

I have an asp page on which I need to connect to database. I have some code that says how I should do this, however when I use it, it fails - it keeps telling me that the login has failed for the username and password (both of which are correct). I don't have the code to hand, but if anyone wants to tell me how I can do this, it would be much appreciated.

BTW its an SQL server 2000 database.

Thanks in advance

ps - I'm learning from scratch from a book

 

[jemminger]

Sanjes,

make sure that user exists both in the "Security > Logins" section in SQL Server Console, and in the "Users" section of the particular database itself.
=========================================================
if (!succeed) try();
-jeff