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

[quoted text, click to view]
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

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=3Dcomputername/sqlInstanceName;Trusted_Connection=3DYes;Database=3D=
DBName"


What should I do to rectify this error?

Is this striing is case sensitive?

Thanks