connection to db help

M

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?
 
A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VWD - Error logiing in to db 2
error in datagridview 1
Cannot open user default database. Login failed. Login failed for user 'HEMPC\ASPNET' 3
Cannot open database requested 1
Newbie question on SQL connection 13
Error while trying to connect to SQL 2005 from ASP.Net 2
Connection string not working when moving from sqlexpress to sqlserver 2
"cannot write to db file" 1

Top