Showing posts with label attempt. Show all posts

Wednesday, March 7, 2012

An attempt to attach an auto-named database for file...failed. A database with the same name exi

I know allot of folks are having this problem and I tried lots of things but nothing works. I understand the problem is coping the SQL Express on another server is the problem - I just not sure what to do?

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

This is the last statement on the Stack Trace:

SqlException (0x80131904): An attempt to attach an auto-named database for file e:\wwwdata\81d0493f\www\App_Data\TestDatabase.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735091

I checked my server forum and they said I had to name a database:
Example: Database=(unique name);

But this didn't work either.

I just tried a simple web project that has only one database and one table in SQL Express with one sqldatasource and one datagrid. It works fine on my pc but when I use the copy function in Visio Studio 2005 Pro - I can't run the site on the remote server: www.myjewelrydirect.com

I tried coping the database manually. I tried disconnecting the database before I copy it. Below is my connection statement:

With all the comments in these forums - this must be a bug.

I have been working on this problem for over 2 weeks - HELP!

Since this is a web app, it is probably running under the ASPNET user account. Make sure that the ASPNET user, or what ever user your appliction is running under if you've set up something other than the default, has permissions on the directory where the database is located.

If the user doesn't have permissions to the directory, you can't attach the database.

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

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

I've read through all the posts in this fourm that are related to the problem I'm getting with this error message on my main form, but none of the fixes seen to solve the problem. So I hope someone can get me pointed in the right direction.

I'm running visual studio 2005 professional, and SQL Server 2005 Express Edition and this is a desktop application. I added the db file to the solution with the Add New Data Source wizard, I can create the datasets and preview the data correctly.

An attempt to attach an auto-named database for file C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\dbInventory.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

When I run the program the exception is throw in the Settings.Designer.vb code, Public ReadOnly Property for the connection string. The InnerException is this...

{"An error occurred loading a configuration file: Could not find a part of the path 'C:\Documents and Settings\<UserName>\<ApplicationName>.vshos_StrongName_1sdf1e34hkn1hqmkn2bgjjwstusfj2sg\1.0.0.0\user.config'. (C:\Documents and Settings\<UserName>\Application Data\...\<ApplicationName>.vshos_StrongName_1sdf1e34hkn1hqmkn2bgjjwstusfj2sg\1.0.0.0\user.config)"}

This folder doesn't exist anywhere on the system, any ideas....

TIA,

SQL Express associates specific database names with the paths where those databases reside. At some point, you've created a database with the same name as the one you're using now, but at a different path. When your code attempts to attach the database with the specific autoname, it finds that name already existing, but at a different path than the one you're specifying, so it fails.

How all this works is wrapped up in the bowles of ClickOnce deployment and SQL User Instances.

You need to clear out the pointer to your database name at the old path, which is easiest to accomplish using SSEUtil. Once you download this utility, you'll be able to easily connect to the User Instance that VS created for you and get a list of all the databases it knows about. (sseutil -L) Find the one that is the same file name as your file but in the wrong location and detach it.(sseutil -d name=c:\somepath\dbinventory.mdf) The name of the database will likely be the path to the file, this is the result of the auto naming that the error is talking about. You can learn more about auto naming and User Instances from the link I've given above.

Mike

|||

Thanks for your reply,

I have run this utility and only one instance of the database is attached. However, I have finally been able to reproduce the problem. I created two identical projects with a dataview bound to one of the tables in the dataset. In one of the test app's, I checked the "Enable ClickOnce Security Settings" in the Security Tab of MyProject settings and ran the app. This caused the error that I'm getting in my real project.....

I went back and unchecked the the Enable ClickOnce Security Setting, ran the project again and it worked fine! So I checked the real project settings and found that indeed the "Enable ClickOnce Security Settings" was enabled, however,after unchecking it and verfiying the other project settings I still am getting the same error!

I ran the sseutil again to see if something was going on, but only one instance of the database is running.

So I went back to the test app and messed around with the settings to see if I could get it to fail, nothing I did seem to create a condition that I couldn't change and get it back working correctly............until I closed the application and reopened it..........It failed as soon as I ran it and I cannot get it running by restoring the settings. I didn't change any code.

The second test app works fine................I compared the code files in the project and can't find anything different between the two.

Is there anything outside of the project files somewhere that might be causing this, registry key or such.......My brain is turning to mush at this point.

Thanks for the help, Burl

|||

Additional information,

Looks like I had multipe problems. I have a habit of moving the solution files around to different folders in VS-2003, such as ActiveProjects, ReleaseProjects, doing so never gave me so much grief as doing this in VS-2005. Just renaming the parent folder cause's the error's along with the above examples.

So, what is the answer to moving a solution to another location?

|||

In your case, it seems your configuration file had a connection string specifying the path to the database. When you moved your project, the path to the database changed and the error was generated cause your connection string was looking in the wrong place. Typically, movement of the data file is handled by the use of the |DataDirectory| macro being used as part of the connection string as in...

AttachDbfilename=|DataDirectory|MyDatabase.mdf

VS knows where the Data Directroy is for your project (or you can set it yourself programatically) and attaches the database for you. If you specify an absolute path, the database has to stay in that path as VS will not automatically change the stored connection string for you.

Mike

|||

Thanks for the reply Mike:

After finally getting this application running again, after a few days I ran into this related problem: When I try to open the Main Form in the Designer I get the Big Red X with a stack trace list and the error message as follows.

"An attempt to attach an auto-named database for file C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\dbInventory.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share."

At this point the application runs fine, but I just can't view the Main Form in the designer without it barking about the database connection. Looking at the trace info, it was complaining about a userControl that gets added to the form. So I commented out the line in the designer.vb file where the userControl is added to the forms collection. The form designer now shows the form layout with no errors. I uncommented that line of code and the error came back. So this time I commented out the line again and ran the application just fine. I again uncommented the code and this time the form layout came back OK, no errors.....

Somewhere, somehow a file is getting out of sync but I sure can't find it. The connection string in the app.config file and in the Settings.Designer.vb file look correct.

App.config file string.

<add name="<MyApplicationName>.My.MySettings.dbInventoryConnectionString"

connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\dbInventory.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"

providerName="System.Data.SqlClient" />

</connectionStrings>

Settings.Designer.vb Connection String Property

<Global.System.Configuration.ApplicationScopedSettingAttribute(), _

Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _

Global.System.Configuration.SpecialSettingAttribute(Global.System.Configuration.SpecialSetting.ConnectionString), _

Global.System.Configuration.DefaultSettingValueAttribute("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\dbInventory.mdf;Integra"& _

"ted Security=True;Connect Timeout=30;User Instance=True")> _

Public ReadOnly Property dbInventoryConnectionString() As String

Get

Return CType(Me("dbInventoryConnectionString"),String)

End Get

End Property

End Class

At least I know how to get it fixed at this point, any ideas on the cause. I deleted the bin folder contents and that didn't help.

Thanks, Burl

|||

I'm having a real problem with the path to your database in the error: C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\dbInventory.mdf

I would never expect a database to be located there, that is part of the VS program installation and is not normally used as the Data Directory. Are you doing anything in your application to set the DataDirectory to this location? Where are your project files located? How did you create this database?

Also, is this a Windows Forms application or ASP.NET? Are you running your application by hitting F5?

Thanks for the additional information.

Mike

|||

I created the database using the Microsoft SQL Server Management Studio Express, version 9.00.2047.00. Later I detached the database and moved the files into a folder located in C:\MySqlDatabases. This is a Windows form application, I created a Setup Project for it as well, no clickOnce deployment. I get the errors by clicking the "Start Debugging Icon" or by pressing F5.

I started working on some userControls for this project a few weeks ago and didn't need the database until recently. So I go the add the database using the Data Source Configuration Wizard. I browsed to the file location and selected the mdf for this project in the C:\MySqlDatabases folder using Windows authentication and DataSource is Microsoft SQL Server Database(SqlClient), the connection string shows up like this "Data Source=.\SQLEXPRESS;AttachDbFilename=C:\MySqlDatabases\dbInventory.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True". It then asks if I want to copy the data file to my project and I say Yes. It then saves my connection string to the app.config file as "dbInventoryConnectionString". The connection string in the Settings Designer is "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\dbInventory.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True". The connection string in the app.config file is the same.

I don't understand why the designer is barking about the database in "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\dbInventory.mdf " when that userControl is trying to load in the main form, again if I comment out the line where it gets added to the forms collection, run the application and uncomment the line the error goes away. However, in that userControl I have one call to the database to fill a dataset, I had that code commented out while I tried to figure out what was going on. Here is the code for that call.

Private Sub CreateCategoryButtons()
Dim da As New dsCategoriesTableAdapters.CategoriesTableAdapter
Dim ds As New dsCategories da.Fill(ds.Categories)

Me.CategoryStackStrip.Items.Clear()
For Each row As DataRow In ds.Categories
Dim btn As New ToolStripButton
With btn
.Text = row.Item("Category").ToString
.Font = New Font("Tahoma", 8.25, FontStyle.Bold, GraphicsUnit.Point)
.Image = My.Resources.alarmclock
.ImageScaling = ToolStripItemImageScaling.SizeToFit
.CheckOnClick = True
.Alignment = ToolStripItemAlignment.Left
.DisplayStyle = ToolStripItemDisplayStyle.ImageAndText
.ImageAlign = ContentAlignment.MiddleLeft
.Margin = New Padding(0)
.Padding = New Padding(2)
.TextAlign = ContentAlignment.MiddleRight
End With

' Add to Category stack.
Me.CategoryStackStrip.Items.Add(btn)

' Add click event handler for category buttons.
AddHandler btn.Click, AddressOf OnCategoryButton_Click Next

' Activates the first button in the stack.
Me.CategoryStackStrip.Items(0).PerformClick()
End Sub

Now that this code is back into the game, the application fails on trying to read the connection string property in the Settings.Designer.vb code. Exception is {"Configuration system failed to initialize"} and the innerException is {"An error occurred loading a configuration file: Could not find file 'C:\Documents and Settings\Burl\<ApplicationNameHere>.exe_Url_trdwo0grhpv0v5se5luy1xl11k1tlbl2\1.0.0.0\user.config'. (C:\Documents and Settings\Burl\Application Data\...\<ApplicationNameHere>.exe_Url_trdwo0grhpv0v5se5luy1xl11k1tlbl2\1.0.0.0\user.config)"}.

I have no idea why its looking in this location for the config file. I even deleted the dataset and rebuilt it by drag and drop from the Server Explorer onto a new dataset file. Same problem.... All the connection string information in this solution is the same.........

"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\dbInventory.mdf;Integra"& _

"ted Security=True;Connect Timeout=30;User Instance=True"

This was all working a few days ago, then I started working on it the next day and this is the mess I'm in now...........ugh.

Burl

|||

I finally uncovered the root cause of the problem......

When you try to add a user control to a Microsoft Windows Forms-based application in Microsoft Visual Studio 2005, you may receive the following error message:

An attempt to attach an auto-named database for file DriveLetter:\Program Files\Microsoft Visual Studio 8\Common7\IDE\DatabaseName.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

You experience this problem if the user control contains a data-binding object that uses an attached local database file.

http://support.microsoft.com/default.aspx/kb/908038

Ok, here is the workaround I came up with. In my userControl for the Load Event I have code that hits the database and builds some buttons for a menu strip. I wrapped the code with a designMode test.

Original UserControl Load Event:

Private Sub ucNavigation_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
' Add Category Items and Overflow items.
CreateCategoryButtons()
AddOverflowItems()
' Set Height.
InitializeSplitter()
End Sub

New UserControl Load Event:

Private Sub ucNavigation_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
' Add Category Items and Overflow items.
If Not Me.DesignMode Then
CreateCategoryButtons()
End If

AddOverflowItems()
' Set Height.
InitializeSplitter()
End Sub

After adding the code I closed all the open windows in the designer and rebuilt the solution, now all of the forms open with no errors and no more database or connection string errors. I hope this information helps someone else, cause it's been a real nightmare for me, so for now I've got my fingers crossed...........

Burl

|||

Thanks for the update Burl,

This is good information for everyone who is working with user controls.

Mike

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

Hi,

I recently installed VS Web Developer Express Ediition and SQL Server Express and I'm doing the How To tutorials and I can't finish the basic data access walkthrough:

http://msdn2.microsoft.com/en-US/library/tw738475.aspx

Because I get an error like this (link for complete error below):

An attempt to attach an auto-named database for file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\test.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: An attempt to attach an auto-named database for file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\test.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

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.

http://pastecode.com/6196

When I am setting up the data source for the gridview tool, everything works fine and the test query works fine, but then when I try to actually test the output in the browser with Cntrl+F5 I get this error.

I have been trying for 48 hours to find a solution on my own. I have googled, I have searched everything and I just am at a point where I think I need to ask someone for help.

Please help.

Make sure the file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\test.mdf failedis not being used by other process. If it is the data file of some database in the SQL instance, you can't attach it by using AttachDBFileName property in the connection string.|||How do I do make sure it's not being used by an other process?|||

In other words, make sure it has not been attached in any SQL instance, and no other application is using it to create a connection.

|||

Thanks for your help so far.

But, how do I do that? How can I tell if another application is using 'it' to create a connection? I am using Visual Web Developer and SQL Server Management Studio Express and SQL Server Configuration Manager. Also when I hit 'Cntrl+F5' while in Visual Web Developer the page opens up in Firefox (my default browser).

I am not using the database for anything else. I have no idea how to monitor SQL instances. I am just beginning to learn these things and am working with tutorials that aren't working for me.

|||

First of all, you aren't crazy or a no brained soul. This is not you. This is quirkiness in how Microsoft (and I am their biggest fan), in trying to make things easier, has somehow made CHANGES to your SQL environment difficult. I am working on sorting this out and creating some kind of a flow chart to troubleshoot all of this, but here are some insights in the meantime (Gurus - please correct me where I am wrong on any of this):

* ASPNETDB.MDF seems to occur for every ASP.NET application and should appear in the |DataDirectory| - which is normally(?/automatically?) APP_DATA

* I think it gets automatically created the first time you run your app (because it seems to me to not be there, then suddenly appear) but it may be under program control - I don't know

* if you have an instance that has been named ASPNETDB or ASPNETDB.MDF in your Sql database, connecting a new one will fail as a duplicate, so use Sql Management Studio to rename any such instances to something unique, like "c:\Webs\PartnerPortal\Northwind Traders\App_Data\ASPNETDB.MDF" instead of just "ASPNETDB.MDF"

* In my environment I have several named instances of Sql Server, including: "STARTEAM" (a Borland created named instance), "OFFICESERVER" "SQLEXPRESS" "MSSQLSERVER" and "MICROSOFT##SSEE" (Mobile edition). However, none of these are useful to me. I have uninstalled SQLSERVER (SQL 2000) and SQLEXPRESS. The one I NEED does not appear - which is the unnamed instance - SQL Enterprise 2005. To access that all I do is enter the server name, ip or .\

* I was using Microsoft Expression Web to edit the default connection string (and this is identical in Server Explorer in VS 2005 also). It asks you the provider. I was using the defaul and could not enter .\ as my Sql Server. I only had the other useless named instances and could not successfully connect. SOOOO I changed the provider. I had two choices:

"Microsoft Sql Server" and "Microsoft Sql Server Database File" (along with "Sql Server Mobile Editiion", etc).

* I changed my selection FROM "Microsoft Sql Server" TO "Microsoft Sql Server Database File". This allowed me to edit the server to be .\ when I went back to my connection string

* Then I changed the provider BACK and now I had the choice I needed! I think that the choice are coming from the registry and it got out of sync

Anyway, now I can connect. I think that connectionString updates the registry, where the problems lie.

*************************************************
Here is the skinny on troubleshooting connections:
*************************************************

(1) have you run aspnet_regsql from a command prompt at the c:\windows\Microsoft.net Framework v2xxx directory?

(2) did you create a virtual directory for your app and enable Asp?
(I have a separate memory pool for each version of Asp - another matter)

(3) did you change the Asp settings to the right connection string? The important things are: .\SQLEXPRESS or .\ or your named instance. If you do not use SQLEXPRESS then User Instance must be False

(4) are all of your instances of ASPNETDB.mdf named uniquely? (Ie: include a path)

(5) does IIS_WPG have sufficient rights to your web directory (this may not be true if you put your webs in your "My Documents")

(6) In VS2005, did you go to Websited-Asp config?

(7) Do you have the right settings in your Web.config?

(8) You must not have extraneous copies of Web.config on your path - they will be automatically referenced in the project. Ie, creating a backup in a subdir, is trouble.

(9) did you set your Default.aspx as the Startup page? (and the right project as the startup project if you have multiple projects?)

(10) did you use Server Explorer to try a different provider, update the registry choices of servers and to include your unnamed instance, per above?

Does Machine.config figure into this?

What have I missed or misstated?

To be honest, having done all of this, I still seem to have a web that I am still troubleshooting the connection for!

****
If anyone can correct, add or improve on the above, please do. What i would love to see is a Visio flowchart in a .pdf that could be emblazoned here. I can be reached at my gmail account of norisksoftware at gmail . com
AND I am looking for contract work doing almost anything technical (web, C#, consulting, Cobol, EDI..) that pays well. I was out of the country for 2 1/2 years and my business kind of dried up. Go figure.

Bill Ross

|||Hi Bill, by default .NET 2.0 security providers(membership, profile, ect.) use a connection string named LocalSqlServer, to learn more details you can take a look at this article:

http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx

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

I have a problem when I want to open a page with the database record. This page is created in Visual Web Developer 2005 Express. When I try to open a page I get the following error message even though the connection between the database is ok:

An attempt to attach an auto-named database for file C:\Inetpub\wwwroot\membership\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.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.Data.SqlClient.SqlException: An attempt to attach an auto-named database for file C:\Inetpub\wwwroot\membership\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 have a computer with Windows XP Professional running IIS 5.1 and ASP.NET 2.0.
Also I have SQL Express on my machine.
Does any one know how to resolve it.
Thanks Smile [:)]

Here is the entire error message that I am getting:

Server Error in '/membership' Application.

An attempt to attach an auto-named database for file C:\Inetpub\wwwroot\membership\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.

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 attempt to attach an auto-named database for file C:\Inetpub\wwwroot\membership\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.] System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +437 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84 System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197 System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +1121 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42 System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +83 System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +160 System.Web.UI.WebControls.Login.AttemptLogin() +105 System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +99 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

|||

This is what I found in the event viewer:

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 1/24/2006
Time: 5:17:15 PM
User: N/A
Computer: DEVELOMPMENT-CO
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 1/24/2006 5:17:15 PM
Event time (UTC): 1/24/2006 10:17:15 PM
Event ID: 29652843fd234fc6a5a00bd4f9652894
Event sequence: 4
Event occurrence: 3
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/1/ROOT/membership-7-127826143653860928
Trust level: Full
Application Virtual Path: /membership
Application Path: C:\Inetpub\wwwroot\membership\
Machine name: DEVELOMPMENT-CO

Process information:
Process ID: 2724
Process name: aspnet_wp.exe
Account name: DEVELOMPMENT-CO\ASPNET

Exception information:
Exception type: SqlException
Exception message: An attempt to attach an auto-named database for file C:\Inetpub\wwwroot\membership\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.

Request information:
Request URL:http://localhost/membership/Login.aspx
Request path: /membership/Login.aspx
User host address: 127.0.0.1
User:
Is authenticated: False
Authentication Type:
Thread account name: DEVELOMPMENT-CO\ASPNET

Thread information:
Thread ID: 1
Thread account name: DEVELOMPMENT-CO\ASPNET
Is impersonating: False
Stack trace: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate)
at System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation)
at System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate)
at System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat)
at System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved)
at System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password)
at System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e)
at System.Web.UI.WebControls.Login.AttemptLogin()
at System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e)
at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
at System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Custom event details:

For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp.

This is the connection string:

<addname="Membership"connectionString="Data Source=.\SQLEXPRESS;Integrated Security=True;User Instance=True;AttachDbFilename=|DataDirectory|aspnetdb.mdf;"

providerName="System.Data.SqlClient" />

</connectionStrings>

Thanks for any responses.

|||

More information about this error. My web site works fine when I run it on this built in Asp.net Developer Server that comes with Visual Web Developer. I don't know why it doesn't work on my IIS 5.1 Server.

Any suggestions?

|||

Hi,

The following URL has some explainations and things to try with this error

http://forums.microsoft.com/msdn/showpost.aspx?postid=98346&siteid=1

Hope that helps,

Lan

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

Hi,

I recently installed VS Web Developer Express Ediition and SQL Server Express and I'm doing the How To tutorials and I can't finish the basic data access walkthrough:

http://msdn2.microsoft.com/en-US/library/tw738475.aspx

Because I get an error like this (link for complete error below):

Source Error:

http://pastecode.com/6196

I have been trying for 48 hours to find a solution on my own. I have googled, I have searched everything and I just am at a point where I think I need to ask someone for help.

Please help.

Hi,

I guess you want to attach a user instance to SQL Server. But the path specified for the user instance is a server attached instance, which makes you able to view the data through the server explorer but won′t make you able to use the run the code, because at startup VS will try to create a user instance at the location specified (which is already occupied by the server instance database) and which will fail. The solution is to specify another folder to create the suer attached instance during the build of the code, thats all. That should make you able to run the build process as well as the code.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Try this in the config file ...

Data Source=.\SQLEXPRESS;AttachDBFilename=C:\...\db.mdf;User Instance=true

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

Hi,

I recently installed VS Web Developer Express Ediition and SQL Server Express and I'm doing the How To tutorials and I can't finish the basic data access walkthrough:

http://msdn2.microsoft.com/en-US/library/tw738475.aspx

Because I get an error like this (link for complete error below):

Source Error:

http://pastecode.com/6196

I have been trying for 48 hours to find a solution on my own. I have googled, I have searched everything and I just am at a point where I think I need to ask someone for help.

Please help.

Hi,

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

Try this in the config file ...

Data Source=.\SQLEXPRESS;AttachDBFilename=C:\...\db.mdf;User Instance=true

An attempt to attach an auto-named database for file aspnetdb.mdf

having exhaustively searched the forum and tried everything over the pas few days im still recieving :

Error Caught in Application_Error event
Error in: http://mysite.com/site1/index.aspx
Error Message: An attempt to attach an auto-named database for file E:\Inetpub\wwwroot\mvate.com\WapCms\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.
Stack Trace: at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate)
at System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation)
at System.Web.Profile.SqlProfileProvider.GetPropertyValuesFromDatabase(String userName, SettingsPropertyValueCollection svc)
at System.Web.Profile.SqlProfileProvider.GetPropertyValues(SettingsContext sc, SettingsPropertyCollection properties)
at System.Configuration.SettingsBase.GetPropertiesFromProvider(SettingsProvider provider)
at System.Configuration.SettingsBase.GetPropertyValueByName(String propertyName)
at System.Configuration.SettingsBase.get_Item(String propertyName)
at System.Web.Profile.ProfileBase.GetInternal(String propertyName)
at System.Web.Profile.ProfileBase.get_Item(String propertyName)
at System.Web.Profile.ProfileGroupBase.GetPropertyValue(String propertyName)
at ProfileGroupUser.get_ClientID()
at InfoPage.Page_PreInit(Object sender, EventArgs e)
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
at System.Web.UI.Page.OnPreInit(EventArgs e)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

help and suggestions appreciated

Looks like you are trying to attach the mdf files with a name that already exists on the server. Your best option is to rename the mdf/ldf files to a new name. then attach them. SQL Server by default tries to use the same name as the filename for the mdf/ldf files. and if a DB with the same name exists on the server it complains like it did in your message.

An attempt to attach an auto-named database for file

I build a WebApp which i use the default DataBase that come with the App_Data folder.

I have Users and roles into that folder with all my tables regarding my new App.

Why i cant make it work under IIS on my webserver ? When i open it with Visual Studio everything works but outside of it nothing.

An attempt to attach an auto-named database for file c:\inetpub\wwwroot\Survey\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.

Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|aspnetdb.mdf;

I look arround and cant find a thing on how to fix my issue. I try deleting the Folder under my User Account for SQL Express and nothing happend.

Make sure your IIS account (ASPNET or NETWORK SERVICE) has read&write permission on the folder where the database file locates.|||Yes i did that ! even uers have modify to it. under that folder !|||

Im still looking for help arround here !

anybody fix the issue?

|||

It is not working because IIS is not the place to store database files, you store those in the data subfolder of Microsoft SQL Server in programs. You can modify the code in the thread below for your use. You may need to start with the trail version of SQL Server and later buy the developer edition it is under $40 on the web. Hope this helps.

http://forums.asp.net/thread/977493.aspx

An attempt to attach an auto-named database failed

I have a problem with Microsoft SQL Server 2005 Express,
My web application runs fine on my development PC, but when I copy it to my
server (My server is running Windows 2000 Server) and try to access it from
the web I get following error:
An attempt to attach an auto-named database for file
C:\Inetpub\okbehappy.net\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.
The ASPNET account has full control of the database.
Is this a known bug in Microsoft SQL Server?
What should I do?
Thanks for your help in advance,
Noah.Noah
How do you perform an attach operation?
"Noah" <Noah@.discussions.microsoft.com> wrote in message
news:227BE70D-49A8-4987-8CF3-DCADFDEE777E@.microsoft.com...
>I have a problem with Microsoft SQL Server 2005 Express,
> My web application runs fine on my development PC, but when I copy it to
> my
> server (My server is running Windows 2000 Server) and try to access it
> from
> the web I get following error:
> An attempt to attach an auto-named database for file
> C:\Inetpub\okbehappy.net\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.
> The ASPNET account has full control of the database.
> Is this a known bug in Microsoft SQL Server?
> What should I do?
> Thanks for your help in advance,
> Noah.
>|||Assuming you are using the default settings, the .mdf and .ldf files must be
located in the same directory as your application on the server. The other
common cause for this is having the database open in the IDE or having the
database files with no write permissions for the ASPNET account. There is
more info here:
http://msdn.microsoft.com/sql/express/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Noah" <Noah@.discussions.microsoft.com> wrote in message
news:227BE70D-49A8-4987-8CF3-DCADFDEE777E@.microsoft.com...
>I have a problem with Microsoft SQL Server 2005 Express,
> My web application runs fine on my development PC, but when I copy it to
> my
> server (My server is running Windows 2000 Server) and try to access it
> from
> the web I get following error:
> An attempt to attach an auto-named database for file
> C:\Inetpub\okbehappy.net\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.
> The ASPNET account has full control of the database.
> Is this a known bug in Microsoft SQL Server?
> What should I do?
> Thanks for your help in advance,
> Noah.
>|||I use the following command:
data source=.\SQLEXPRESS;Integrated
Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true
"Uri Dimant" wrote:
> Noah
> How do you perform an attach operation?
>
> "Noah" <Noah@.discussions.microsoft.com> wrote in message
> news:227BE70D-49A8-4987-8CF3-DCADFDEE777E@.microsoft.com...
> >I have a problem with Microsoft SQL Server 2005 Express,
> > My web application runs fine on my development PC, but when I copy it to
> > my
> > server (My server is running Windows 2000 Server) and try to access it
> > from
> > the web I get following error:
> >
> > An attempt to attach an auto-named database for file
> > C:\Inetpub\okbehappy.net\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.
> >
> > The ASPNET account has full control of the database.
> > Is this a known bug in Microsoft SQL Server?
> > What should I do?
> >
> > Thanks for your help in advance,
> >
> > Noah.
> >
>
>|||As I said... The ASPNET account has full control of the database and of the
application root folder.
Read, Write, Modify, etc.
I thought that was the problem, but it isn't. I had already given the ASPNET
account full control when I had problems with a hit counter. That took me two
days to figure out...
Anyway,
With the info you have now what do you suggest I do?
Thanks,
Noah.
"Roger Wolter[MSFT]" wrote:
> Assuming you are using the default settings, the .mdf and .ldf files must be
> located in the same directory as your application on the server. The other
> common cause for this is having the database open in the IDE or having the
> database files with no write permissions for the ASPNET account. There is
> more info here:
> http://msdn.microsoft.com/sql/express/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Noah" <Noah@.discussions.microsoft.com> wrote in message
> news:227BE70D-49A8-4987-8CF3-DCADFDEE777E@.microsoft.com...
> >I have a problem with Microsoft SQL Server 2005 Express,
> > My web application runs fine on my development PC, but when I copy it to
> > my
> > server (My server is running Windows 2000 Server) and try to access it
> > from
> > the web I get following error:
> >
> > An attempt to attach an auto-named database for file
> > C:\Inetpub\okbehappy.net\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.
> >
> > The ASPNET account has full control of the database.
> > Is this a known bug in Microsoft SQL Server?
> > What should I do?
> >
> > Thanks for your help in advance,
> >
> > Noah.
> >
>
>|||So, you eliminated one of the three things I suggested. How about the other
two? Di reading the article give you any things to try?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Noah" <Noah@.discussions.microsoft.com> wrote in message
news:C270718F-C4ED-4D9D-9154-BE54671192B2@.microsoft.com...
> As I said... The ASPNET account has full control of the database and of
> the
> application root folder.
> Read, Write, Modify, etc.
> I thought that was the problem, but it isn't. I had already given the
> ASPNET
> account full control when I had problems with a hit counter. That took me
> two
> days to figure out...
> Anyway,
> With the info you have now what do you suggest I do?
> Thanks,
> Noah.
> "Roger Wolter[MSFT]" wrote:
>> Assuming you are using the default settings, the .mdf and .ldf files must
>> be
>> located in the same directory as your application on the server. The
>> other
>> common cause for this is having the database open in the IDE or having
>> the
>> database files with no write permissions for the ASPNET account. There
>> is
>> more info here:
>> http://msdn.microsoft.com/sql/express/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp
>>
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> Use of included script samples are subject to the terms specified at
>> http://www.microsoft.com/info/cpyright.htm
>> "Noah" <Noah@.discussions.microsoft.com> wrote in message
>> news:227BE70D-49A8-4987-8CF3-DCADFDEE777E@.microsoft.com...
>> >I have a problem with Microsoft SQL Server 2005 Express,
>> > My web application runs fine on my development PC, but when I copy it
>> > to
>> > my
>> > server (My server is running Windows 2000 Server) and try to access it
>> > from
>> > the web I get following error:
>> >
>> > An attempt to attach an auto-named database for file
>> > C:\Inetpub\okbehappy.net\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.
>> >
>> > The ASPNET account has full control of the database.
>> > Is this a known bug in Microsoft SQL Server?
>> > What should I do?
>> >
>> > Thanks for your help in advance,
>> >
>> > Noah.
>> >
>>|||Yes.
"Roger Wolter[MSFT]" wrote:
> So, you eliminated one of the three things I suggested. How about the other
> two? Di reading the article give you any things to try?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Noah" <Noah@.discussions.microsoft.com> wrote in message
> news:C270718F-C4ED-4D9D-9154-BE54671192B2@.microsoft.com...
> > As I said... The ASPNET account has full control of the database and of
> > the
> > application root folder.
> > Read, Write, Modify, etc.
> > I thought that was the problem, but it isn't. I had already given the
> > ASPNET
> > account full control when I had problems with a hit counter. That took me
> > two
> > days to figure out...
> > Anyway,
> > With the info you have now what do you suggest I do?
> >
> > Thanks,
> > Noah.
> >
> > "Roger Wolter[MSFT]" wrote:
> >
> >> Assuming you are using the default settings, the .mdf and .ldf files must
> >> be
> >> located in the same directory as your application on the server. The
> >> other
> >> common cause for this is having the database open in the IDE or having
> >> the
> >> database files with no write permissions for the ASPNET account. There
> >> is
> >> more info here:
> >>
> >> http://msdn.microsoft.com/sql/express/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp
> >>
> >>
> >>
> >> --
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >> Use of included script samples are subject to the terms specified at
> >> http://www.microsoft.com/info/cpyright.htm
> >>
> >> "Noah" <Noah@.discussions.microsoft.com> wrote in message
> >> news:227BE70D-49A8-4987-8CF3-DCADFDEE777E@.microsoft.com...
> >> >I have a problem with Microsoft SQL Server 2005 Express,
> >> > My web application runs fine on my development PC, but when I copy it
> >> > to
> >> > my
> >> > server (My server is running Windows 2000 Server) and try to access it
> >> > from
> >> > the web I get following error:
> >> >
> >> > An attempt to attach an auto-named database for file
> >> > C:\Inetpub\okbehappy.net\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.
> >> >
> >> > The ASPNET account has full control of the database.
> >> > Is this a known bug in Microsoft SQL Server?
> >> > What should I do?
> >> >
> >> > Thanks for your help in advance,
> >> >
> >> > Noah.
> >> >
> >>
> >>
> >>
>
>

An attempt to attach an auto-named database failed

An attempt has been made to use a rendering extension that is not registered for this repo

Hai All,

I have tried to render a Report in my Server to HTML Format.But i got an Error "An attempt has been made to use a rendering extension that is not registered for this report server".I tried using the URL.the Report is worlking fine.But i can't able to render it.

Please Enlighten me.

Thanx,

Karthik.A

Hai All,

I fixed this problem.

I treid to render the Report into HTML Format.

But there's no way to render it to HTML .

But we can render to MHTML.

Thanx,

Karthik.A

An attempt has been made to use a data extension OLEDB that is not registered for this report se

I am using SQL Server 2005 Express along with the other Express reporting tools (VS Express). I am trying to report against an oracle database. I can design and preview the report however when I attempt to 'deploy' the report to a report server that is on the same machine I am developing on, I get the above error. Is this because I am running an Express version of SQL Server or is this an error?

Thanks,

Sam

Yes, the Express Edition only allows connections to local data sources with a limited set of data extensions. Not all types of data sources are supported in the Express Edition.

-- Robert

An attempt has been made to use a data extension OLEDB that is not registered for this repor

Thanks,

Sam

Yes, the Express Edition only allows connections to local data sources with a limited set of data extensions. Not all types of data sources are supported in the Express Edition.

-- Robert

An attempt has been made to use a data extension 'DLLName' that is not registered for this

Hello,

I've created my own data extension which uses ADODB.NET (OleDB Provider) and connects to the named SQL instance. During the development phase of the report I can connect to my data source, retrieve data from it and display it in the report preview with no problems. But as soon as I want to deploy this report and my data source I get the message: “An attempt has been made to use a data extension 'DLLName' that is not registered for this report server.". I went thru all *.config files and set up them up as per instructions how to. I can see my extension in the combo box during designing my report which tells me that this is done correctly. I can create the report in the preview as well. But whatever I do, when I want to deploy it I'm always getting this message.

I've come across one post where it says that Reporting Services are limited to the default, unnamed instance of SQL Server (local). I don't think it should matter to me in this case because I'm using my OleDB Provider to connect to the database. Report doesn't know anything about it. It gets data from my extension, not directly from the database. But I've tried switching from my named instance to (local) just to see if it is going to work, but no luck.

I'd appreciate somebody giving me some suggestions on this issue.

Thanks...

did you update rssrvpolicy.config to grant fulltrust to your extension? Usually this error message appears when report server gets an exception when loading the extension, and this usually happens when extension is not trusted or it fails in constructor. The fact that it works in report designer (which runs everything in fulltrust by default) most likely means that extension is not getting fulltrust when loaded on server.|||

Yes I did. Here is the code from the rssrvpolicy.config:

</CodeGroup>

But it still doens't work. I still am getting the same message when I try to deploy my report.

Any suggestions would be appreciated.

Thanks...

Wednesday, March 7, 2012

An attempt to attach an auto-named database for file...failed. A database with the same name exi

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

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

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

An attempt to attach an auto-named database for file C:\Inetpub\wwwroot\membership\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.

Server Error in '/membership' Application.

An attempt to attach an auto-named database for file C:\Inetpub\wwwroot\membership\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.

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

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

An attempt to attach an auto-named database for file aspnetdb.mdf

An attempt to attach an auto-named database for file

An attempt to attach an auto-named database failed

An attempt to attach an auto-named database failed

An attempt to attach an auto-named database failed

An attempt has been made to use a rendering extension that is not registered for this repo

An attempt has been made to use a data extension OLEDB that is not registered for this report se

An attempt has been made to use a data extension OLEDB that is not registered for this repor

An attempt has been made to use a data extension 'DLLName' that is not registered for this

SQL Alternative to cursor

Blog Archive

About Me