July 31, 2013 at 2:12 pm
On a single VM, I have the following
1) A default Instance of SQL Server 2012 (SP1 build number 11.0.3128.0) with database engine, SSAS, SSIS, DQS and MDS etc
2) A named instance of SSAS for SSAS tabular mode
3) A named instance of SSAS in SharePoint integrated mode for PowerPivot.
1) After the initial installation of SQL Server 2012, I have installed the SP1 on default instance. So, all is good.
2) Now, I want to install the sp1 on SSAS tabular mode instance ( I have couple of databases installed on this currently) and SP1 on SSAS in SharePoint integrated mode(Nothing on this instance).
Can somebody please provide me a guide or steps or link as to how I can approach this. When I apply service pack, obviously I dont want to disturb my default instance because everything is good there. When I apply service pack on tabular mode, will it effect my existing databases? If yes, how should i approach it? Greatly appreciate if anybody can give me some pointers and I am under the gun to get this done.
July 31, 2013 at 3:55 pm
I have never worked with SSAS, but as I recall when you install a Service Pack, there is a screen where you select which instances to upgrade. And since your default instance is already at SP1, it will not touch that instance.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply