SQL BI

My Experience - Troubleshooting SQL BI Stack

SQL Server Deployment Property (Retain Configuration Setting)

SQL Server Deployment Property (Retain Configuration Setting)

  • Comments 3

 

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
  • Here are this and some other articles on SSAS Deployment ssas-wiki.com/.../Articles

  • 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.

  • 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.

Page 1 of 1 (3 items)
Leave a Comment
  • Please add 8 and 3 and type the answer here:
  • Post