Cannot open database requested

[Gopalan]

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

[Norman Yuan]

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