fatmidget:

I had the same use and tried a whole bunch of things, but this is what solved it for me:

- it seems I had the DB still opened inside my IDE (Visual Web Developer Express), in the database explorer. Right-clicking the database and selecting "close connection" fixed it.

Hope this helps.

Thanks a Million Monish.. you made my day.. indeed the week today being monday .. a very simple solution for an irritating issue, i was breaking my head for 1 full day !

Well , but I cannot open "Member of" section of the properties. When I try this , it gives me the following error message box ;

 The Following error occured while attempting to read the properties of user ASPNET
The Server Serivice is not started

What might be the problem ?

Thanks in advance

fatmidget:

...
- it seems I had the DB still opened inside my IDE (Visual Web Developer Express), in the database explorer. Right-clicking the database and selecting "close connection" fixed it.

Hope this helps.

Hi, 

               I run into the same problem.

               Because the close connection is disabled at Database Explorer, I delete the database then add a new connection by choosing the same database deleted. I can now disable the enabled close connection by right clicking the database.

By adding a new connection, the connectionString attribute in connectionStrings at web.config replaces the default connection to

connectionString="Data Source=[SERVERNAME]\SQLEXPRESS;AttachDbFilename=|DataDirectory|\smsdata.mdf;Integrated Security=True" providerName="System.Data.SqlClient"/>

just replace the [SERVERNAME] to period(.) like so Data Source=.\SQLEXPRESS    

               Thanks Fatmidget!

cheers,
imperialx 

I tried this way, but still has

"Cannot open user default database. Login failed.
Login failed for user 'DEV\ASPNET'. "

my database is not at local machine, it is remote machine. I can't use this way. what can I do????

 Hey...It worked for me...This was nicely done....Thank u...

Hi All,

after trying something like 10 random workarounds for this issue I finally had it working by just deleting the MACHINENAME/ASPNET user from SQL Server 2005 Express.

Best regards,
Dario Rossa

monishjain, very clever, you found it

thanks a lot 

u need to give right to servernmae\aspnet account in sql server.

it is local account created at the time of iis installtion . iis only request through this account . so this account  should access to sql server.