Tuesday, January 27, 2015

ASP.NET web.config SQL connection string for local

Install SQL express on local, then change connection string below, so when you register a user. it is same.

You can import from Azure sql db to local sql server (after you migrate the localdb to Azure SQL server) 


<connectionStrings>
   <add name="DefaultConnection" connectionString="Data Source=(local);Initial Catalog=RegMSW_db;Persist Security Info=True;User ID=xx;Password=xxxxx" providerName="System.Data.SqlClient" />

 </connectionStrings>

No comments:

Post a Comment