IIS 7 and Above
LocalSqlServer on Database connections
Last post Jun 26, 2009 02:27 PM by SaadL
Apr 23, 2009 05:49 AM|clustermaster|LINK
I have install the latest database manager and is really cool.
I have one problem i want to delete the LocalSqlServer on Database connections.
Even when i deleted if i log-off and log-on this appears again. I greated a new connection that works try again to delete but appears again.
Apr 23, 2009 07:34 AM|ma_khan|LINK
Jun 26, 2009 02:27 PM|SaadL|LINK
The LocalSqlServer connection string is created by default when the .NET Framework is installed.
To remove this connection string, you will need to edit your machine.config file that is located in: "C:\Windows\Microsoft.NET\Framework\v2.0.50727\CONFIG".
Open machine.config in your favorite editor, then search for the following section:
<add name="LocalSqlServer" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient"/>
Then delete the <add> element in that section. The section will be empty or should only contain connection strings you added:
Let me know if you need further help.