ASP.NET configuration
-
Hello, I am working with ASP.net 2008. I am using Users, Membership, roles through Website->ASP.NET configuration menu. I would like to use it while is pointing to an external database not the local one. How do I tell him to use external SQL server database. I have already add the database through aspnet_regsql.exe. Thank you
Eric H.
-
Hello, I am working with ASP.net 2008. I am using Users, Membership, roles through Website->ASP.NET configuration menu. I would like to use it while is pointing to an external database not the local one. How do I tell him to use external SQL server database. I have already add the database through aspnet_regsql.exe. Thank you
Eric H.
By Default ASP.NET stored membership information in local database. If you want to store it in remote database you have to add the database using
aspnet_regsql.execommand.As You have already add the database, you are now one step ahead. Just do the following entry in web.config. In theConnectionStringssection of the web.config add the new ConnectionString for the new DatabaseIn the Membership section of the web.config, give the same connection string the you have added for new database
Hope this will help you.
cheers, Abhijit CodeProject MVP Web Site:abhijitjana.net
-
By Default ASP.NET stored membership information in local database. If you want to store it in remote database you have to add the database using
aspnet_regsql.execommand.As You have already add the database, you are now one step ahead. Just do the following entry in web.config. In theConnectionStringssection of the web.config add the new ConnectionString for the new DatabaseIn the Membership section of the web.config, give the same connection string the you have added for new database
Hope this will help you.
cheers, Abhijit CodeProject MVP Web Site:abhijitjana.net
Thank you for your precious help, it works
Eric H.