SQL Analysis Services goes crazy after Server re-imaging

Not sure if anybody else has experienced Analysis Services getting a little funky after bringing up a new Virtual Server based on an existing Virtual server image. Environment contains three servers PROD, DEV and QA; DEV and QA are mirrors of PROD. all initials installs done on PROD.

Strangeness experienced:

–  When I tried to create an analysis services database on the Dev or QA virtual servers the database would never appear

– When I tried to add a user to the Analysis Servers administrator group, the user would appear to get added but when you reviewed your changes the user vanished

– Processing of the existing cubes resulted in an ‘unexpected error’ occuring

In order to rectify all of the issues we had to unistall the Analysis Services feature from the SQL Server Instance and re-install. I would live to hear if anybody else has experienced issues like these and if there are easier fixes.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s