Setting the LocalSQLServer connection string in web deploy
If you are using Webdeploy you might wish to alter the connection string the for the LocalSQLServer that is used by the ASP.NET provider for web part personalisation. The default is to use ASPNETDB.mdf in the APP_Data folder, but in a production system you could well want to use a ‘real’ SQL server. If you look in your web config, assuming you are not using the default ‘not set’ setting, will look something like...