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]

Re: connection to db help

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



"Mike" <bagged123@sbcg lobal.net> wrote in message
news:%23jUeM2XL EHA.2736@TK2MSF TNGP11.phx.gbl. ..[color=blue]
> 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[/color]
are[color=blue]
> configured the same with the aspnet ID and can connect to pubs, northwind
> db's fine.
>
> what i'm i missing or doing wrong?
>
>[/color]