how to change ASP.NET Configuration tool connection string
        Posted  
        
            by 
                Zviadi
            
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by Zviadi
        
        
        
        Published on 2011-01-10T08:50:45Z
        Indexed on 
            2011/01/10
            8:53 UTC
        
        
        Read the original article
        Hit count: 321
        
Hello, how can I change ASP.NET Configuration tool-s connection string name? (Which connection string will ASP.NET Configuration tool will use) I'm learning ASP.NET and everywhere and in book that I'm reading now theres connection string named: LocalSqlServer.
I want to use my local sql server database instead of sql express to store Roles, Membership and other data.
I have used aspnet_regsql.exe to create needed data structures in my database. after that I changed my web.config to look like:
<connectionStrings>
      <remove name="LocalSqlServer"/>
    <add name="LocalSqlServer" connectionString="Server=(LOCAL); Database=MyDatabase;Integrated Security=True" providerName="System.Data.SqlClient" />
  </connectionStrings>
but when I run ASP.NET Configuration tool it says that: "The connection name 'ApplicationServices' was not found in the applications configuration or the connection string is empty."
ASP.NET Configuration tool uses connection string named: ApplicationServices not LocalSqlServer.
cause of that I have to modify web.config to:
<connectionStrings>
    <add name="ApplicationServices" connectionString="Server=(LOCAL); Database=MyDatabase;Integrated Security=True" providerName="System.Data.SqlClient" />
  </connectionStrings>
and everything works fine.
I wish to know why the hell my web site uses connection string named: ApplicationServices and all books and online documentations uses LocalSqlServer? and how to change it to LocalSqlServer?
I have: Windows 7 Sql Server 2008 R2 Visual Studio 2010 Premium Project type is website
© Stack Overflow or respective owner