Time Tracker Starter Kit

Re: An attempt to attach an auto-named database for file ... failed

chetan.sarode — Tue, 06 Oct 2009 03:05:57 GMT

Another way to solve this query...Thanks

Re: An attempt to attach an auto-named database for file ... failed

Taiwo Egun — Fri, 02 Oct 2009 17:56:47 GMT

Guys, if you are getting this error running it locally, Visual Studio provides the connection string that you can use. Go to Server Explorer-> and aright click on the name of the .mdf file. Click "Modify Connection..." and select "Advanced" at the bottom, there's a Textbox with the connection string. Use this if testing locally. When Deployed, change the "AttachDbFilename" to the deployed location. (i.e. "AppData/DBName.mdf". Hope this helps.

Re: An attempt to attach an auto-named database for file ... failed

chetan.sarode — Mon, 13 Jul 2009 03:02:05 GMT

CAn you put here more error details here, So that it will be helpful to solve it

Re: An attempt to attach an auto-named database for file ... failed

aebordones — Fri, 10 Jul 2009 15:28:55 GMT

THE MAIN PROBLEM IS THIS ERROR:

"OR IT IS LOCATED ON UNC SHARE", I REALLY DON´T KNOW WHAT'S THE PROBLEM, BECAUSE I´M NOT SHARING ANYTHING... IF YOU FIND SOMETHING... PLESE WRITE ME aebordones@hotmail.com

Re: An attempt to attach an auto-named database for file ... failed

chetan.sarode — Mon, 06 Jul 2009 02:55:08 GMT

Yes thats right ,but recommondation is to use Network Service account to run.

Re: An attempt to attach an auto-named database for file ... failed

garrygrimshaw — Fri, 03 Jul 2009 09:30:04 GMT

I've just had this same problem and figured out what the cause is.

This error message is happening because the account which the Application Pool is running does not have sufficient permissions to auto-attach the database.

Please note this is NOT the account which is used to run the website. My Application Pool is the DefaultAppPool and was using Network Service account to run.

I changed this to Local System and it started working. However, I believe this has security implications which I cannot be bothered to figure out just yet. I'm just happy it's working.

Re: An attempt to attach an auto-named database for file ... failed

chetan.sarode — Mon, 11 Feb 2008 03:35:56 GMT

Try to set User Instance=false

Re: An attempt to attach an auto-named database for file ... failed

Mark Barnes — Sun, 10 Feb 2008 02:39:08 GMT

After a lot of trials, tribulations and errors, I found a solution to the problem. Please mark this as an answer if it turns out helpful. I cannot vouch for the security of this solution. Some say its bad, but I say its good because it works.

1. Update your connection string to the following:

Driver={SQL Native Client};Server=.\SQLExpress;AttachDbFilename=|DataDirectory|mydbfile.mdf; Database=dbname;Trusted_Connection=Yes;

Why is the Database parameter needed? If the named database have already been attached, SQL Server does not reattach it. It uses the attached database as the default for the connection.

2. Under the application pool properties in the identity tab, set "Network Service" or "ASP.NET" as the security account.

3. Make sure you grant read and write permissions to "Network Service" or "ASP.NET" account. Give full permissions and adjust later to be on the safe (or unsafe) side.

COMMENTARY:

The security model for .NET, ASP.NET, SQL Server, and Windows is extremely difficult to wrap your head around. You must know each technology’s security model and how they interplay with one another in order to become proficient and productive. The exception error messages don't really tell you what the problem is. There are no books or articles that cover these security models comprehensively. Consequently, many developers figure out what works by trial and error and wind up compromising security, which renders the security system useless.

Re: An attempt to attach an auto-named database for file ... failed

chetan.sarode — Fri, 18 May 2007 04:19:07 GMT

This is not depend upon what version you used...

See in the App_Data folder or see in Server Explorer in VS, you will get there..

Re: Help attaching databases

abbadum — Thu, 17 May 2007 18:56:13 GMT

If you can help me, please write directly to my email at ajarncarlos@gmail.com

Thanks

Help attaching databases

abbadum — Thu, 17 May 2007 18:55:14 GMT

I need help attaching databases. I tried to use the attach string provided by my host and it doesn't work. I don't know what to do.

This is my string:

The host is http://banana.qsh.eu

Should I keep the ldf files or they are created automatically when I tried to run the page for the first time?

Re: An attempt to attach an auto-named database for file ... failed

raikkonen — Wed, 07 Feb 2007 12:18:55 GMT

Ok,thanks for your answers...I finally copy and paste the same database.mdf from my usb flash and it worked...so a good thing to do anytime is to backup always your application...

Re: An attempt to attach an auto-named database for file ... failed

Zhao Ji Ma - MSFT — Tue, 06 Feb 2007 01:32:12 GMT

raikkonen:

Hi,

thanks for the answer but I haven't the file "aspnetdb.mdf " in my application directories...In addition,I use Sql Express Edition and I don't think is possible to attach my database file ...

What is your error message?

The original error of this thread is not able to attach the aspnetdb.mdf file using SQL Express:

[SqlException (0x80131904): An attempt to attach an auto-named database for file C:\WebSites\Test_TimeTracker\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.]

So If you are using SQL Express as Membership Provider, there is aspnetdb.mdf file, please use the asp.net Administrative Tool to configure users and roles, this tool will create this file automatically.

If your error message shows different .mdf file name, please make sure the file is already exists under App_Data folder and it is accessible. Please check your connection string as well, e.g.

Re: An attempt to attach an auto-named database for file ... failed

raikkonen — Mon, 05 Feb 2007 16:25:50 GMT

Hi,

thanks for the answer but I haven't the file "aspnetdb.mdf " in my application directories...In addition,I use Sql Express Edition and I don't think is possible to attach my database file ...

Re: An attempt to attach an auto-named database for file ... failed

raikkonen — Mon, 05 Feb 2007 16:24:18 GMT

Hi,

thanks for the answer but I haven't the file "aspnetdb.mdf " in my application directories...In addition,I use Sql Express Edition and I don't think is possible to attach my database file ...