I've been asked to look into the new Web Site Administration tool for a project and have been really struggling to understand how this thing works.

My most recent problem is that when I go to the security tab, I am getting the following error:
-------------------------------------------------------------------------------------------------------------------
There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.

The following message may help in diagnosing the problem: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
-------------------------------------------------------------------------------------------------------------------

Like i said, I'm new to this, so I'm not really sure what this Application is doing "under the hood", IE: what config files it is updating, et cetera.

What (I think) I do know is that it is using a SQL Server Express Database called ASPNETDB.MDF and here is this mornings log file entry if that is of any help
-------------------------------------------------------------------------------------------------------------------
2005-10-05 01:00:56.05 spid51      Starting up database 'C:\WINDOWS\MICROSOFT.NET\FRAMEWORK\V2.0.50727\ASP.NETWEBADMINFILES\APP_DATA\ASPNETDB.MDF'.
2005-10-05 01:20:42.92 spid1s      Server resumed execution after being idle 267 seconds. Reason: timer event.
2005-10-05 08:50:00.53 Server      Server resumed execution after being idle 26045 seconds: user activity awakened the server. This is an informational message only. No user action is required.
2005-10-05 08:50:00.60 Logon       Error: 15350, Severity: 16, State: 1.
2005-10-05 08:50:00.60 Logon       An attempt to attach an auto-named database for file C:\MyData\Development\UPMC.2.0.net\EMG\Queues\QueuesWS\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
-------------------------------------------------------------------------------------------------------------------
It looks like there is a duplicate database or the db cannot be opened, because It's not on a share.


thanks in advance for any help.

doug

well I've been round and round with this problem.

Turns out since we're using impersonation in our application, I needed to set the Log On properties in SQL SERVER EXPRESS
to the account being impersonated in the web.config file.

Start->Programs->Microsoft SQL Server 2005 CTP->SQL Server Configuration Manager->Right Click on SQL Server (SQLEXPRESS)->Properties->Log On Tab.

Sure Hope this helps someone out there....

Cause I was goin' nuts

Doug

Hi,
Which account did you use? I am having the same problem, but use windows authentication for SQLserver 2005.
I don't see any impersonation account in the web.config file.
Please help.
Sophia

Sophia.

You may need to check the directory where the ASPNETDB.MDF file.

If you are not using impersonation, does the ASPNET account have privleges to the directory that contains ASPNETDB.MDF?

If not, add the ASPNET account like this:
------------------------------------------
1. Right click the directory
2. Go to properties
3. Click the security tab.
4. Click add.
5. Click locations.
6. Make sure your computer is selected in the Locations window.
7. Click Ok
8. Type ASPNET in the Enter the object names to select.
9. Click check names.
10. Click ok.

Make sure that the new priveleges propogated to the child elements ASPNETDB.MDF and aspnetdb_log.LDF.

See if that works for you.

God Bless.

Doug

Doug,
thank you so much for answering!
I tried your suggestion...unfortunately it didn't change anything. Any other ideas? I am getting crazy :)
Sophia.

Doug, I found the solution! Standard, security is configured to use SQLExpress. You have to edit the machine.config file, and add a special login to SQLServer. Here is a page where everything is explained, in case there are more clueless newbies like me ;)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/paght000013.asp

Try this:

1). Start->Programs->Configuration Tools->SQL Server Configuration Manager
2). Click SQL Server 2005 Services
3). Are the SQL Server(SQLEXPRESS) and SQL Server Browser running?
4). If not, start them both.
5). If they are restart them by clicking the blue restart button in the toolbar.

See if that works.

Doug

Cool!

 

This thing has been driving me crazy too from time to time...

 

And since it's so new...there's not much on it out there

Good luck!

 

Doug

I have tried this and it works,

1> Right clik on My Computer then Select manage

2>From Services and Application select Services

3>then make sure that sqlexpress is running

4>if it is not then start it.

All the bests

Ahmad Khalid Asghari