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: 234

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

Related posts about ASP.NET

Related posts about string