Sunday, April 22, 2012 12:21 PM
Is there a way to create an assemblly on SSAS programmatically through a command that could be executed from the ASCMD.EXE utility instead of doing that manually from SSMS or BIDS?
Tuesday, April 24, 2012 10:16 AMModerator
Yes, please refer to http://msdn.microsoft.com/en-us/library/ms175340(v=sql.90).aspx on how to do it.
Tuesday, April 24, 2012 10:34 AM
How do you fill-in the below section: ??!!
Wednesday, December 05, 2012 10:24 AM
Found the answer :-)
From SSMS on your development server, open the create new assembly wizard from Assemblies > New Assembly... , select the assembly dll file and enter the impersonation information, then click the Script button at the top-left of the screen in order to store this in an XMLA script file.
Later on you can take this XMLA script file and execute it against the production server through ASCMD.EXE
Note: To set up a password for the impersonation, you need to manually add the section:
inside the XMLA file just below the account name section. However, make sure to dispose or hide the XMLA file afterwards to avoid someone getting the password... :-)