connection to db help

[Mike]

I need some help here, I have an asp.net page that connects to a DB. I can
connect to every DB that came installed in SQL 2000, but when I try to
connect to a DB that I create I get a login failed error message.

Cannot open database requested in login "dbname", Login failed for user
"servername/aspnet"

I get this with any db i create but i can use the same code and the db's are
configured the same with the aspnet ID and can connect to pubs, northwind
db's fine.

what i'm i missing or doing wrong?

 

[Ashish M Bhonkiya]

Hi Mike,

try to add the "servername/aspnet" user to the database which you are not
able to access. you can do this by opening SQL Enterprise Manager ->Select
the Database which you are not able to connect->in the right pane you will
see users click on users -> new DatabaseUser-> and select aspnet user from
there.

HTH
Regards
Ashish M Bhonkiya