Login Controls

mashype · January 26th, 2009, 06:15 AM

This may be stupid, but I can not figure it out.

I am using visual web developer. On my local version, I am able to use the web administration and create the aspnetdb to create users, login, etc. When I upload this, I needed to migrate the db to a new location and I can not seem to figure out how I redirect everything from the app data folder into the new mssql db. I have looked all through the code but can not seem to find out where I point my user controls to this new db. Any help would be greatly appreciated.

Lee Dumond · January 26th, 2009, 10:37 AM

All you really need to do is modify the connection string in web.config to point to the new location.

mashype · January 26th, 2009, 11:32 AM

Thanks Lee. I have added the new connection string. My problem is I do not find any of the old connection string used to point the default login controls to the aspnetdb file. I am not sure if this was hidden somewhere in the code, but I can not tell where to point from. When using the standard 'web site administration' tool in VWD, this is all set up for you, and I don't seem to find how it is pointing to the add data folder.

Lee Dumond · January 26th, 2009, 12:02 PM

When you create a new site using the RAD tools as you have, it is automatically configured to use a connection string called "LocalSqlServer", which is located in machine.config.

To "override" that string, you can just "remove" the reference to the default LocalSqlServer connection string, and create a new one also called LocalSqlServer. That way, you won't have to alter any of the providers to use a new name.

Essentially, it would go like this:

Code:

<connectionStrings>
      <remove name="LocalSqlServer" />
      <add name "LocalSqlServer" 
           connectionString="your_connection_string_goes_here"
           providerName="System.Data.SqlClient" />
 </connectionStrings>

mashype · January 26th, 2009, 03:07 PM

Thanks so much Lee! I have been fiddling with this forever and got nowhere. I am not quite done with it, but I see now that the login controls are connecting to the sql db. SOOOOOO much appreciated.