Solved

Deploying ASP.net roles to Production

Posted on 2009-07-08
2
507 Views
Last Modified: 2013-12-12
Hi, I'm having an issue with my .net role provider when I try to move my code to the production server. Everything works fine in my local, but once it is copied over to our production server it just doesn't work anymore. It seems like it does not recognize the location of the roles databases. Membership along copies over and works just fine, as I tried this before enabling the roles.

After googling for a solution I found an article that suggested to overwrite a hidden connection string for my role provider and make sure that it pointed to my database, it also required that I took my aspnetdb.mdf database from my app_data folder and attach it to my sql server.. one problem I'm having with this particular process is that my aspnetdb.mdf seems to be in a 2008 version of sql express, where our production servers runs a 2005 version, therefore when I try to attach it.. it just gives me an error and stops.

Is this the right approach at all? or is there anything else I could try in order to fix this???
0
Comment
Question by:LostInCode
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 18

Accepted Solution

by:
David Robitaille earned 500 total points
ID: 24813934
Did you see that one ? did you  set an applicationName for the Role provider in the Web.config?
http://weblogs.asp.net/scottgu/archive/2006/04/22/Always-set-the-_2200_applicationName_2200_-property-when-configuring-ASP.NET-2.0-Membership-and-other-Providers.aspx 
also, if you use another databes in your app, you could merge the aspnetdb.mdf with it

http://www.4guysfromrolla.com/articles/040506-1.aspx
you could also use this techinque on a new datebase on your SQL 2005 server and then recreate your roles (or copy your data on the new tables...)
0
 

Author Closing Comment

by:LostInCode
ID: 31601085
Thanks this worked!
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This video demonstrates basic masking and how to edit the mask to reveal the desired image.
The viewer will learn how to successfully download and install the SARDU utility on Windows 8, without downloading adware.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question