Error 500 Takes it's toll

The Error:

An attempt to attach an auto-named database for file C:\Users\CodeFreak\Documents\Visual Studio 2005\WebSites\PersonalSite\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.

I've tried allowing permissions I'VE EVEN TRIED ALLOWING EVERYONE! I've tried right clicking the datasource under the datasource explorer and clicking 'detatch.' It works Locally but fails when i pusblish with IIS. Whats with these SQL databases that just dont want to work with IIS 7 ?

Published with: IIS 7

I've tried removing the "user instance."

This is User roles and all that which uses SQL Server 2005.

So my question is, How do i publish a website with SQL Server 2005 database?

Please give it to me step by step as im still quite a newbie.

Thanks in advance

Does the Account the Web Service is running with have the appropiate permissions to access the file ? Did you made sure that once the database is opened, the connection is reused at the second time the database is accessed ? Do you have the autoclose property set on or off ?

Jens K. Suessmeyer.

http://www.sqlserver2008.de
|||It was automatically set up, I checked the permissions in both NTFS and the website's permissions they all checked out fine|||

Auto CLose?

Can you elaborate?

I even tried Microsoft's template which failed aswell

I just don't know how to publish a web page after i click and drag a login for and use the administer options to create accounts and set permissions. Remember I'm still a newbie when it comes to aspx, VWD and IIS. I've only used HTML 2 weeks ago (ps. I'm a fast learner). So I would perfer step by step instructions. It works fine during debug but falls over on publish (yes i closed VWD).

|||

Problem solved. It turns out I put it in the same directory as the website.

Moving it (and modifying the connection string accordingly works)

Old connectiong String (From web.config)

data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|datadirectory|aspnetdb.mdf;User Instance=true

Modified Connection String -works (after moving the database files of course)

data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=C:\Mydatabase\aspnetdb.mdf;User Instance=true

Soo easy, I couldn't believe I missed it!

Error 26

HI

I recently uploaded my site to a hosting company... i am now getting this error

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)] CSharpMegaDVD.MegaDVD.Product.GetNewDVD() in c:\myaspx\csharpmegadvd\business objects\product.cs:566 CSharpMegaDVD.index.LoadNewDVDList() in c:\myaspx\csharpmegadvd\index.aspx.cs:39 CSharpMegaDVD.index.Page_Load(Object sender, EventArgs e) in c:\myaspx\csharpmegadvd\index.aspx.cs:24 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +47 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061

is this a fault at my end or thier end?

how do i fix this problem?

thx

Hi

i fixed it

in my connection string i had local instead of (local)

you think the error message could be a little more accurate

anyway

cheers!!