Solved

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

Posted on 2006-06-11
10
739 Views
Last Modified: 2007-12-19
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
Comment
Question by:shagnea
  • 5
  • 4
10 Comments
 
LVL 27

Expert Comment

by:Sammy
ID: 16881005
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
 
LVL 52

Expert Comment

by:Carl Tawn
ID: 16881027
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
 

Author Comment

by:shagnea
ID: 16881289
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
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 

Author Comment

by:shagnea
ID: 16881324
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
 
LVL 27

Expert Comment

by:Sammy
ID: 16881983
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
 

Author Comment

by:shagnea
ID: 16886995
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
 
LVL 27

Accepted Solution

by:
Sammy earned 500 total points
ID: 16888187
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
 

Author Comment

by:shagnea
ID: 16889915
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
 
LVL 27

Expert Comment

by:Sammy
ID: 16891319
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
 

Author Comment

by:shagnea
ID: 16894435
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

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Lots of people ask this question on how to extend the “MembershipProvider” to make use of custom authentication like using existing database or make use of some other way of authentication. Many blogs show you how to extend the membership provider c…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

778 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