Showing posts with label timetracker. Show all posts
Showing posts with label timetracker. Show all posts

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