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=DBName"


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).

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=DBName"


What should I do to rectify this error?

Is this striing is case sensitive?

Thanks

GB