Cannot open database requested in login "DBName" Login failed for

M

Max

I am writing an intranet application where i would like to take advantage of
the built in windows authentication... Integrated Security...

In AssetTracker(my SqlDB) i have myself TMP\rrhinehart as dbo.

Then in IIS under websites i go to the AssetTracker application right
click-properties and go to the Directory Security
and currenty i have Anonymous Access Checked... With username set to
TMP\rrhinehart password: pwd, and unchecked Allow
IIS to control password. Integrated Windows Authentication is checked.
nothing else. ok ok..

Then inside my web.config i have the tag

<identity impersonate="true"> and <authentication mode="Windows">

here's my connection string....
<add key="AssetTrackingConnectionConfigKey" value="Data
Source=domina;Initial Catalog=AssetTracker;Integrated Security=SSPI;" />

I get the following error:

Things I've thought about... that i've read. My web-server and DB-server
seperate entities. The webserver and dbserver are also on different domains.
Maybe this has something to do with my problem. Any help would be greatly
appreciated...

Server Error in '/AssetTracker' Application.
--------------------------------------------------------------------------------

Cannot open database requested in login 'AssetTracker'. Login fails. Login
failed for user 'TMP\rrhinehart'.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot open database
requested in login 'AssetTracker'. Login fails. Login failed for user
'TMP\rrhinehart'.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,769
Messages
2,569,580
Members
45,055
Latest member
SlimSparkKetoACVReview

Latest Threads

Top