An attempt to attach an auto-named database for file ….database1.mdf failed

by

I had this problem also and it was a pain. I configured my connection string and managed to solve the problem. In the connection string I replaced the value |DataDirectory|\dbfilename.mdf for AttachDbFilename property, with the path to the file. |DataDirectory| can only be used if the database file is in the App_Data folder inside same project.

So changing the AttachDbFilename property to the direct path of the mdf file, fixed my issue.

AttachDbFilename=C:\MyApp\App\DAL\db.mdf

I hope this works for you.

More Related Contents:

  1. Generating an Excel file in ASP.NET [closed]
  2. ValidateRequest=”false” doesn’t work in Asp.Net 4
  3. Stored procedure slow when called from web, fast from Management Studio
  4. How should I perform a long-running task in ASP.NET 4?
  5. Error – SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM
  6. Howto? Parameters and LIKE statement SQL
  7. Is there a way to programmatically determine if a font file has a specific Unicode Glyph?
  8. A network-related or instance-specific error occurred while establishing a connection to SQL Server [closed]
  9. HTTP Error 500.22 – Internal Server Error (An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode.)
  10. SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified [closed]
  11. The transaction manager has disabled its support for remote/network transactions
  12. Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’
  13. How can I JSON encode an array in VB.NET?
  14. Store String Array In appSettings?
  15. how to remove ‘name’ attribute from server controls?
  16. Preventing SQL Injection in ASP.Net
  17. Stopping onclick from firing when onclientclick is false?
  18. How to configure SMTP settings in web.config
  19. IFrame: This content cannot be displayed in a frame
  20. Entity Framework v2 doesn’t support sql 2000?
  21. Conversion from type ‘DBNull’ to type ‘String’ is not valid
  22. Editing Web.config programmatically
  23. asp.net 4.0 web forms routing – default/wildcard route
  24. URL Routing, Image Handler & “A potentially dangerous Request.Path value”
  25. Windows 7 Could not create SSL/TLS secure channel.”} System.Net.WebException
  26. How to stop ASP.NET from changing IDs in order to use jQuery
  27. How to login and then download a file from aspx web pages with R
  28. “This operation requires IIS integrated pipeline mode.”
  29. “Exception has been thrown by the target of an invocation” error (mscorlib)
  30. How to forcefully set IE’s Compatibility Mode off from the server-side?

Leave a Comment