Hello,

I use apsnet built in database for user and roles management and authentication.
but I would like to use a single connection string. it is posible? does anybody have a clue how to do that?

my current cs is: 

  <connectionStrings>
    <clear/>
    <add name="LocalSqlServer" connectionString="Data Source=Server1\SQLEXPRESS; Initial Catalog=dbname; User ID=aaa;Password=bbb;"  />
    <add name="MicroCommerce" connectionString="Data Source=Server1\SQLEXPRESS; Initial Catalog=dbname; User ID=aaa;Password=bbb;"
         providerName="System.Data.SqlClient" />
  </connectionStrings>

and this what i want to use

  <connectionStrings>
    <clear/>
    <add name="ZCommerce" connectionString="Data Source=Server1\SQLEXPRESS; Initial Catalog=dbname; User ID=aaa;Password=bbb;"
         providerName="System.Data.SqlClient" />
  </connectionStrings>

i got an an errors when i accessing the aspnet config, when i use the a single cs.

just a single con string name. is it posible?

regards,

md5.

It should be possible but you have to make sure that all reference to the old connection strings are changed to the new one

(check the Web.Config and maybe some cs files)

also you will need to put the tables, views, and stored procedures from the aspnetdb into your db. .NET comes with a tool to do this: http://aspnet.4guysfromrolla.com/articles/040506-1.aspx.