Moving AspNetDB on thte sql server

bex · March 18th, 2009, 09:38 AM

Hi there

i use vs2008, Sql 2005.

i created an application that uses login, as you all know when u use Asp-Net configuration tool in VS it creates the asp-net db, every thing works so far but when i remove the db from app_data folder and attach it in the sql is not reading it, instead it creates a new aspnetdb in the app_data,
how can i change the provider so it will point to the sql and not to the app_data folder.

thanks

Lee Dumond · March 18th, 2009, 12:10 PM

Add a connection string that points to the attached database, and change the Membership provider to use the new connection string.

bex · March 18th, 2009, 01:16 PM

I did add the connection string that points to the attached database but i don't know how to change the Membership provider, is that done in the web config?

Code:

<connectionStrings>
<addname="ConnectionString"connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF
;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
<connectionStrings>
<addname="NEWConnectionString"connectionString="Data Source=MAIN\SQLEXPRESS;Initial Catalog=ASPNETDB;
UserId=22222222; Password=2222222"
providerName="System.Data.SqlClient" />
 
</connectionStrings>

i comment out the first conn run the application it works, then i delete the app_data folder in the root run the application it says user not in db i run the asp configuration tool it says 0 users 0 roles.

can you give me an example of how to change the provider.

thanks

Lee Dumond · March 18th, 2009, 01:30 PM

Code:

 
<membership defaultProvider="myMembershipProvider" userIsOnlineTimeWindow="15">
   <providers>
      <add name="myMembershipProvider" 
         connectionStringName="NEWConnectionString" 
         applicationName="/" 
         enablePasswordRetrieval="true" 
         enablePasswordReset="true" 
         requiresQuestionAndAnswer="true" 
         requiresUniqueEmail="true" 
         passwordFormat="Encrypted" 
         maxInvalidPasswordAttempts="5" 
         passwordAttemptWindow="10" 
         minRequiredPasswordLength="6" 
         minRequiredNonalphanumericCharacters="0" 
         type="System.Web.Security.SqlMembershipProvider, 
            System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
      </providers>
</membership>

Of course, change the vlaues above to match whatever you want for your provider.

bex · March 18th, 2009, 04:32 PM

Hi Lee thanks 4 the code ,

i did try it and i got a little problem to access the database,

this login has user Id and Password,
i got this: Cannot open database "ASPNETDB2" requested by the login. The login failed. Login failed for user 'test'.

with the same login i can access sql management studio and have full permit ion for the ASPNETDB2 database,

i tried this
<addname="ConnectionString"connectionString="Data Source=STUDIO\SQLEXPRESS;Initial Catalog=ASPNETDB2;Integrated Security=True"
providerName="System.Data.SqlClient" />
Cannot open database "ASPNETDB2" requested by the login. The login failed. Login failed for user 'studio\name

how can i sort this?

vs added this in the webconfig



Code:

type="System.Web.Security.SqlMembershipProvider, &#xD;&#xA; System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"

Lee Dumond · March 18th, 2009, 04:56 PM

You need to check which users are configured in those databases, and what permissions they have. You also need to make sure the ASP.NET worker process has appropriate permissions as well.

Just because you can log into management studio with a given set of credentials doesn't mean you have access to any given schema in that database.

bex · March 19th, 2009, 04:23 AM

thanks Lee

done i also found this on the web
http://209.85.229.132/search?q=cache...&hl=en&ct=clnk

very helpful