An attempt to attach an auto-named database for file c:\inetpub\wwwr oot\WebSite\App _Data\aspnetdb. mdffailed

[Freddie]

hi,

i try to get the asp.net 2.0 security controls to work with SQL Server
2005 Dev RTM, this is my connetion string in mashine.config

<connectionStri ngs>
<add name="LocalSqlS erver" connectionStrin g="data
source=.;Integr ated
Security=SSPI;A ttachDBFilename =|DataDirectory |aspnetdb.mdf;U ser
Instance=false; " providerName="S ystem.Data.SqlC lient" />
</connectionStrin gs>

the aspnet account has sql login w/ administrative rights, this is the
error msg:
[SqlException (0x80131904): An attempt to attach an auto-named database
for file c:\inetpub\wwwr oot\WebSite\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.]

the c:\inetpub\wwwr oot\WebSite\App _Data\ folder is local, this is new
install of the sql server, there r no databases created after install,
App_Data folder exists and aspnet has full control over it

[clickon]

Why atatch the MDF file in the connection string. I would atatch the DB
using the SQL Server Management Studio and then just connect to it using the
connection string.

"Freddie" wrote:

hi,

i try to get the asp.net 2.0 security controls to work with SQL Server
2005 Dev RTM, this is my connetion string in mashine.config

<connectionStri ngs>
<add name="LocalSqlS erver" connectionStrin g="data
source=.;Integr ated
Security=SSPI;A ttachDBFilename =|DataDirectory |aspnetdb.mdf;U ser
Instance=false; " providerName="S ystem.Data.SqlC lient" />
</connectionStrin gs>

the aspnet account has sql login w/ administrative rights, this is the
error msg:
[SqlException (0x80131904): An attempt to attach an auto-named database
for file c:\inetpub\wwwr oot\WebSite\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.]

the c:\inetpub\wwwr oot\WebSite\App _Data\ folder is local, this is new
install of the sql server, there r no databases created after install,
App_Data folder exists and aspnet has full control over it

[Freddie]

becouse it`s harder to deploy

Why atatch the MDF file in the connection string. I would atatch the DB
using the SQL Server Management Studio and then just connect to it using the
connection string.

"Freddie" wrote:

>>hi,

i try to get the asp.net 2.0 security controls to work with SQL Server
2005 Dev RTM, this is my connetion string in mashine.config

<connectionSt rings>
<add name="LocalSqlS erver" connectionStrin g="data
source=.;Inte grated
Security=SSPI ;AttachDBFilena me=|DataDirecto ry|aspnetdb.mdf ;User
Instance=fals e;" providerName="S ystem.Data.SqlC lient" />
</connectionStrin gs>

the aspnet account has sql login w/ administrative rights, this is the
error msg:
[SqlException (0x80131904): An attempt to attach an auto-named database
for file c:\inetpub\wwwr oot\WebSite\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.]

the c:\inetpub\wwwr oot\WebSite\App _Data\ folder is local, this is new
install of the sql server, there r no databases created after install,
App_Data folder exists and aspnet has full control over it

[heitai]

There are umpteen people who have wasted countless hours over the
message "an attempt to attach an auto-named database....... ." One reply
has at least a half a dozen fixes, none of which work. Where, pray
tell, is the SQL Server Management Studio. I use Visual Web Management
2005 Express. What do I click to get to the SQL Management Studio. It's
the only approach I haven't tried. Maybe VWM 2005 Express doesn't have
SQL Mgmt Studio.
Many thanks for your help
clickon wrote:

Why atatch the MDF file in the connection string. I would atatch the DB
using the SQL Server Management Studio and then just connect to it using the
connection string.

"Freddie" wrote:

hi,

i try to get the asp.net 2.0 security controls to work with SQL Server
2005 Dev RTM, this is my connetion string in mashine.config

<connectionStri ngs>
<add name="LocalSqlS erver" connectionStrin g="data
source=.;Integr ated
Security=SSPI;A ttachDBFilename =|DataDirectory |aspnetdb.mdf;U ser
Instance=false; " providerName="S ystem.Data.SqlC lient" />
</connectionStrin gs>

the aspnet account has sql login w/ administrative rights, this is the
error msg:
[SqlException (0x80131904): An attempt to attach an auto-named database
for file c:\inetpub\wwwr oot\WebSite\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.]

the c:\inetpub\wwwr oot\WebSite\App _Data\ folder is local, this is new
install of the sql server, there r no databases created after install,
App_Data folder exists and aspnet has full control over it