Hi,
I am stumped for the moment trying to configure my connection string in my web.config file. I am using a database that is different than the default aspnetdb that gets automatically created. I created a database will all the user and membership tables and copied it into my websites App_Data folder. The problem is when I add new users either programmatically or through the ASP.net Website Administration Tool, these get stored in the database originally created in SQL Server Management Tool (which resides somewhere under Program Files). My original connection string (which I have commented out while working on the new one) is:
<!--<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer"
connectionString="Data Source=TIM-LAPTOP\SQL2008EXPRESS;Initial Catalog=ChicagoPartyAnimals;Integrated Security=True"
providerName="System.Data.SqlClient"/>
</connectionStrings>-->
My current string is:
<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer"
connectionString="Data Source=TIM-LAPTOP\SQL2008EXPRESS;AttachDbFilename=|DataDirectory|ChicagoPartyAnimals.mdf;Integrated Security=True;User Instance=true"
providerName="System.Data.SqlClient"/>
</connectionStrings>
My current string is causing an error in the Website Administration Tool when going to the Security Tab.
Any thoughts or guidance as to where I can find the solution? All of my attempts at search have proved futile thus far.
Thank you.