By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,361 Members | 1,700 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,361 IT Pros & Developers. It's quick & easy.

Cannot open database requested

P: n/a
Hi

Simple for you.

Cannot open database requested in login 'TestDB'. Login fails. Login failed for user 'Computername\ASPNET'

The user is given permission for accessing this DB

the connection string is:

"Server=computername/sqlInstanceName;Trusted_Connection=Yes;Database=DB Name"
What should I do to rectify this error?

Is this striing is case sensitive?

Thanks

GB
Nov 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Now that you were given a clear message that login failed, how could you be
so sure that the user is given permission to access DB? You need create a
login in the SQL Server that maps to the user account "ComputerName\ASPNET".
If you has Enterprise Manager, you can easily tell whether a login maps to
that user account. Once logged in, a proper permission to access a database
in the QL Server is also required (Being logged in does not necessarily mean
the user can access a database in the SQL Server).

"Gopalan" <go***************@btinternet.com> wrote in message
news:ud**************@TK2MSFTNGP15.phx.gbl...
Hi

Simple for you.

Cannot open database requested in login 'TestDB'. Login fails. Login failed
for user 'Computername\ASPNET'

The user is given permission for accessing this DB

the connection string is:

"Server=computername/sqlInstanceName;Trusted_Connection=Yes;Database=DB Name"
What should I do to rectify this error?

Is this striing is case sensitive?

Thanks

GB
Nov 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.