Sunday, March 25, 2012

Can't Attach sqlexpress db

Hi,

After having published the timetracker starterkit from visual studio 2005 to local wwwroot,

I try to access my homepage with ie.

But still get the same error message :

An attempt to attach an auto-named database for file C:\Documents and Settings\Emmanuel\My Documents\Visual Studio 2005\WebSites\GestWares\App_Data\TimeTracker.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

This is how i configure my web.config :

<connectionStrings>

<remove name="LocalSqlServer"/>

<add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;AttachDBFilename=|DataDirectory|\TimeTracker.mdf;User Instance=true"/>

<add name="aspnet_staterKits_TimeTracker" connectionString="Data Source=.\SQLExpress;Integrated Security=True;AttachDBFilename=|DataDirectory|\TimeTracker.mdf;User Instance=true"/>

<add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\TimeTracker.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>

</connectionStrings>

Has someone any idea how my connectionstrings statement has to look like?

thanks in advance.

Manu.

Hi,

Refer below links for work around.

http://www.aspspider.com/resources/Resource170.aspx

http://www.sqljunkies.com/WebLog/ktegels/archive/2005/11/15/17401.aspx

http://www.ozzu.com/ftopic43909.html

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=989092&SiteID=1

Hemantgiri S. Goswami

No comments:

Post a Comment