Puzzled by Q10413

Hello.

I don't understand Q10413. Are the steps in this article supposed to be performed locally? If so, then why is the connection string pointing to a database on the discountAsp.net server?

I have not been able to get past step 6. yet. I'm not sure if it is because the connection stringdoes not point to a local database or if it is some other problem.

I thought the connection string was supposed to point to where your database is.

Can anybody explain this?

Thanks,
Tony

 

I plan on adding a few videos for this soon as it is rather confusing.
Do you have a copy of SQL Server installed?
If so, you can just double-click on aspnet_regsql.exe and run itas a wizard.

The methods pointed out in the KB...
http://kb.discountasp.net/article.aspx?id=10413

...are showing you how to create the Membership roles from your local system to your remote account.

I highly recommend this article by Peter:
http://www.eggheadcafe.com/articles/20060529.asp
Salute,
Mark

 

Mark,


I still don't understand this.
>>...are showing you how to create the Membership roles from your local system to your remote account.<<

If there are no steps in that article to upload my database to the remote account, how does it create the Membership roles frommy local system tomy remote account?

Still puzzled.

Tony

 

I'll do my best here but to be honest there is a reason you can buy an entire .NET book about this.

The reg tool is something you can find a lot of information on in the MSDN site.
Is that someplace you resort to currently? It's a great resource:
http://msdn2.microsoft.com/en-us/default.aspx

It's been one of my best friends for years now.

Now, here's the part where I'll try to make this less confusing, but I may fail...
The reg tool can be used to create the table and roles locally or remotely.
In the KB article it is doing the best job to provide information for those who may or may not have SLQ Server locally.
Also does not assume the user has a knowledge of SQL.
As you can create everything locally and then use your own scripts to create them on your remote account.
That however is for advanced SQL users.

Something I like to do is run the reg tool locally for my local SQL Server...
Then use the SQL Server management tools to push the data to the remote SQL Server.

That reg tool has multiple uses, as you may discover.
Let me know what I can try to help with...

 

Mark,


Yes, i do use msdn a lot and after this reply, ill try to find outout how using a remote connection string in web.config can create the Membership roles frommy local system tomy remote account.


I have Microsoft SQL Server 2005 Express and Microsoft SQL Server Management Studio Express installed. I have read numerous articles and books on this subject and that is why i am confused by Q10413. All of those articles and books left me with the impression that the connection string points to where your database is physically.
>>The reg tool can be used to create the table and roles locally or remotely.<<

What do you mean by "reg tool". I'm not sure if you mean the aspnet_regsql.exe command or the ASP.NET Configuration.


>>As you can create everything locally and then use your own scripts to create them on your remote account.<<

I thought that i could create them on my remote account by just uploading the my local database.

Still confused.

Tony

 

Yes by Reg tool I was referring to the aspnet_regsql.exe tool, not the ASP.NET config, which is for your local settings.


I've got another PC here, older system with XP on it, my kids use for games.


May install the express tools on that one so I can give better help here.


I can not honestly answer which capabilities I refer to apply to the express tools.


It's not very expensive to pick up a Developer copy of SQL Server if you do a lot of work with express it will pay off.
Check Amazon, you can find developer versions of both 2000 and 2005, probably for less than you would imagine.
Salute,
Mark


P.S. I'm still willing to help with whatever you need.

 

Mark,


I already have Microsoft SQL Server 2000 Standard Edition, Microsoft SQL Server 2005 Standard Edition and Microsoft SQL Server 2005Developer Edition.


What can i do with them that i can't do with express versions?


Thanks,
Tony

 

I'd have to use the express versions to answer that.
Seems they have changed, allowing more capabilities than they did one year ago.
What I'd like to look into is if the express versions allow you to open connections to local and remote servers...
Then pump data and objects to or from either source.

In the developer version of SQL Server 2005 for example...
You could use create and test everything locally...
Then open the SQL Server management console and make use of the Import/Export wizards.

A nice feature on the DASP SQL accounts is the on-line backup.
You can easily make a backup, then export your data and objects.
If it doesn't work out, restore your SQL DB.

By the way, if you have a developer copy of SQL Server running locally you can work with a temp DB.
No need for your local and remote DB's to have the same name, just the tables and objects you want to transfer.
Reason I mention this is, you can use a temp DB locally to create these functions...
If things don't work out you just drop the local DB and try again.

Hope I'm not confusing you, just trying to offer some tips.