Membership and Roles on Remote Database

Hi there, I am very new to .NET but I have have been working with Classic ASP forever! I have now pulled my finger out and decided to start learning.

I was starting to follow the video tutorial on Membership and Roles,but I have a problem in that I did not install a copy of SQL Sever 2005 Express as I have a remote installation of SQL Server 2000.

I ranaspnet_regsqlwhich created the database etc on my Server, but this Server still does not appear in providers and I can only see 'AspNetSqlProvider'?

Is there something I should really be doing to get THIS website to use a particular SQL Server for Membership and Roles??

Thanks for and advice / help

Tony

Hi Tony

if you want add new other provider for member ship you should add it in web.config

for more details seeSqlMembershipProvider andRoleManager element and if you want use profile seeprofile element

i hope this help

Ah ok, so I need to create a connection string in the web config to my SQL Server, then add the provider information?

Should these database tables/views for membership and roles be in a seperate database or is it ok to add them to my main application database; so when I migrate this to a live environment I only need to change the connection string?

yes you need add a connetcion string because the provider new a name of connection string.

umm you can use exists database even Sql Server 2000 database and configure it by aspnet_reqsql command , and you don't need to separate database

hope this help

Yes thanks, got it working now.