Hi! I host a site on a server where the databases is created through a control panel. How do I customize my MembershipProvider manualy so that I can access the ASPNETDB.mdf which I created through the panel and restored with a .bak file.

I have added the line: <membership defaultProvider="MyAspNetSqlMembershipProvider">

Bu it still looks for the AspNetSqlMembershipProvider which ASP.NET uses...what must I do...because I get the following error when I try to access my MyProfile.aspx:

An attempt to attach an auto-named database for file C:\HostingSpaces\leonenjo\forro.co.za\wwwroot\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:\HostingSpaces\leonenjo\forro.co.za\wwwroot\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:


Line 40: Public Overridable Property ContactName() As String
Line 41: Get
Line 42: Return CType(Me.GetPropertyValue("ContactName"),String)
Line 43: End Get
Line 44: Set


Source File: C:\Windows\Microsoft.NET\Framework\v2.0.50727\Temp orary ASP.NET Files\root\7f053bb1\85d3df98\App_Code.5m3lv152.1.v b Line: 42

Please help me...

You shouldn't have to actually switch out the provider, simply modify the SqlConnection that is being used to point to your database.

__________________
Mitchel Sellers
Microsoft C# MVP, MCITP
Director of Development
IowaComputerGurus Inc.

My blog for .NET and DotNetNuke info

Author of "Professional DotNetNuke Module Programming"

Tech Editor on "Visual Studio 2010 six-in-one" and "Pro C# 4.0"

Thank you, I'ver figured it out in the meantime, but so much thanx for your help!