PC Review


Reply
Thread Tools Rate Thread

Cannot open database "aspnetdb" requested by the login.

 
 
Jess
Guest
Posts: n/a
 
      29th Feb 2008
When I go into VS2005 - website administration tool / Security I get the
error:
"Cannot open database "aspnetdb" requested by the login. The login failed
for user xxxx\ASPDATA"

SQL Express 2005 is installed - I generated the aspnet database from
aspnet_regsql.exe. The aspnet database didn't get uploaded to the App_data
folder yet. I'm using impersonation to access other tables so this is
picking up that line in my web.config file - which is ok. ASPData is the
dummy account set up on the system and is used in other .Net apps to update
tables with. (And it works)

Web.Config file has this line:
<clear />
<add name="LocalSQLServer"
connectionString="Server=.\SQLEXPRESS;Database=aspnetdb;Trusted_Connection=Yes;" />
<identity impersonate="true" userName="(E-Mail Removed)" password="xxx" />

In IIS Manager - under ASP.Net tab - Configuration Settings it has this string
data source=.\SQLEXPRESS;Integrated
Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true

ASPData has permissions to read/write/modify to the c:\Program
Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data

I opened SQL Express Mgr - and set up a login & permissions for aspData with
all the rights of "aspnet_?" plus dbReader & dbWriter in the role membership
for the aspnetdb. It's still not working.

Any ideas? I'm lost now.
Jess


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cannot open database requested in login 'HumanResources'. Login failed for user 'companyDomain\BOSIIS$'. Homer Microsoft ASP .NET 3 25th Sep 2007 08:45 PM
"Cannot open database request in login. Login fails." Error =?Utf-8?B?Tmlja1A=?= Microsoft Outlook BCM 1 30th Mar 2007 04:36 AM
Error : "Cannot open database XXX requested by login." Mr.KisS Microsoft ASP .NET 2 7th Jul 2004 12:14 PM
Error : "Cannot open database 'wizou.mdf' requested by login." Mr.KisS Microsoft ASP .NET 0 6th Jul 2004 09:06 PM
Cannot open database requested in login ''. Login fails. Login failed for user ''. Nevena Microsoft ADO .NET 1 16th Apr 2004 06:55 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:08 AM.