Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 747
  • Last Modified:

Copying from Visual Web Developer Express to my GoDaddy website doesn't take membership data with it

I'm a total novice to ASP.NET 2.0 as well as to Visual Web Developer Express, so this is probably due to some very basic lack of understanding on my part. Here's the scenario:

I built a (very simple) membership web site using VWD Express. There are only 2 roles defined.

When I copy the website to my GoDaddy account, none of the roles (or any other data, for that matter) is transferred. Since GoDaddy refuses to help me, I'm not sure what to do. Am I supposed to re-create the roles on the GoDaddy server?

Thanks in advance for your help!

Cheers,
Tracy
0
shagnea
Asked:
shagnea
  • 5
  • 4
1 Solution
 
Sammy AgeilCommented:
I am not sure if Godaddy support SQLExpress, You can ask them that and they should let you know. If they dont then Yes you have to setup your database on their server.


HTH
0
 
Carl TawnSystems and Integration DeveloperCommented:
The problem you will be having is that Membership information is stored in a database (SQL Express by default) that you will need to transfer to your hosting site as well as your website files.
0
 
shagneaAuthor Commented:
Yes -- I understand that the data is contained in my local ASPNETDB.mdf. The problem is HOW do I get the roles, etc into the web server's DB?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
shagneaAuthor Commented:
Just to elaborate further.. there is no obvious tool in the GoDaddy control panel for SQL Server that allows this. When I asked, they only told me they don't support 3rd party applications, period. So.... I'm hoping one of you has tackled this and can tell me how. I don't want to have to dump and import each individual ASP.NET table if I don't have to do so.
0
 
Sammy AgeilCommented:
If you have godaddy's sql IP address, username and password then you can register the membership tables to your database by using aspnet_regsql.exe
You can do this like this
Start, All Programs, go to Microsoft .NET Framework SDK v2.0, go to SDK Command Prompt click there and you will get the command prompt, at that command prompt type aspnet_regsql.exe and hit enter
follow the wizard and provide it with godaddy's SQL server IP Address, your username to the server and of course the password. once you are done, your db will have all tables for the membership class to work with.

Good luck
0
 
shagneaAuthor Commented:
Sadly, GoDaddy does not allow this, nor do they permit a remote connection that would allow me to do this in an easier fashion.


I appreciate the suggestions so far, but I need more explicit guidance.

I'm really hoping that one of you has already managed to move your roles/membership data to a GoDaddy account and can give me more of a "step-by-step" for it, since I'm really quite green in the web development/sql-server department.
0
 
Sammy AgeilCommented:
Okay, Godaddy doesnt allow remote connection but they have their own tools to add the schemas to the SQL database to use membership and roles
http://help.godaddy.com/article.php?article_id=694&topic_id=216&prog_id=GoDaddy&isc=

http://help.godaddy.com/article.php?article_id=695&topic_id=216&prog_id=GoDaddy&

0
 
shagneaAuthor Commented:
Right.

I have the schemas in place. The problem is the data. How do I bring the roles I create locally to my GoDaddy implementation? The 2nd link provided by sammy1971 above shows how to do a specific implementation of a canned website. But that's not what I need. I need a general solution that I can use for membership sites I create.
0
 
Sammy AgeilCommented:
Simple answer, wsith the way Godaddy setting up their system and their permission you can only do that manually!
If they dont allow remote connections to their SQL server, I dont see a possible way to do it other than the manually!!
by the way, it makes NO sense that a host doesnt allow remote connections to an sql server and expect developers to do their work on a production server. I have yet to see a host that does that.
there has to be a way for you to connect to their SQL server from your home/work.


0
 
shagneaAuthor Commented:
GoDaddy explicitly states that remote connections to SQL Server are verboten. Of course, they'd be happy to give me a dedicated server where I could have admin rights, if I were willing to sell 2 of my 3 children and a few spare internal organs to pay for it.

Nevertheless, I think you're right. I'm going to have to create some SQL scripts and upload the data "manually." Yuck. A very inelegant solution to what should be a simple task.

Thanks for you're help anyway, all.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now