SQL Server Deployment Property (Retain Configuration Setting)

  • Article

 

Well one of my customers had asked the as significance of this property as he didn’t find anything on net so thought of writing an article about it.

image

Retain Configuration Setting:
Will retain all properties of Connection String except Password.

Project which you want to deploy, have SQL DB Server Name – Server A and Database Name as Test specified  in Data Source Connection String but in your Destination server where you are deploying, Server Name is Production and Database Name is ProdDb.

1)            If you check the Retain Configuration Setting
Server Name on the AS Server will remain as Production
RDBMS Database Name will remains as ProdctDB but if you will process it will fail (which is by design) you need to provide the password explicitly.

2)            If you un-check the Retain Configuration Setting
Server Name on the AS Server will change to your Project’s Server name which is Server A
RDBMS Database Name will  be changed to your Project’s Database Name which is Test

Comments

  • Anonymous
    February 24, 2011
    Here are this and some other articles on SSAS Deployment ssas-wiki.com/.../Articles

  • Anonymous
    April 14, 2013
    Hi Karan, the same lack of information exists for the "Retain optimization settings" flag... If you have more infos about it, could you explain how it works? Thank you so much.

  • Anonymous
    April 14, 2013
    Hi Karan, the same lack of information exists for the "Retain optimization settings" flag... If you have more infos about it, could you explain how it works? Thank you so much.