Author: mrrogers | Posted on: 12/21/2009 10:56:25 AM | Views : 842

I get the following error when trying to setup ASP.NET security:

"Could not establish a connection to the database. If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider."

Also,  how do I initially point to a remote database? I tried adding a line to the <connectionStrings> section of my web.config.

<add name="LocalSqlServer"  connectionString="data source=MyDatabase;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true"  providerName="System.Data.SqlClient" />
It gives me an error saying that LocalSqlServer already exists.



...

Go to the complete details ...