To determine the SQL Server Analysis Services Version and Edition go to the following registry keys (click Start, click Run, type regedit, and then click OK):

SQL 2008 R2

Version

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSAS10_50.InstanceName \MSSQLServer\CurrentVersion -> CurrentVersion Key

Edition

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSAS10_50.InstanceName \Setup -> Edition key

Full story »

Method 1 (From Configuration manager)

Open the Reporting Services Configuration manager and go to Report Server Status page. The version and and edition information will be displayed in this page.

Method 2 (From log file)

Go to C:\Program Files\\Microsoft SQL Server\<SQL Server Instance>\Reporting Services\LogFiles folder and edit the ReportServerService_<timestamp>.log file.

Full story »

Problem

The following error appears after executing a scheduled SQL Agent job that runs an SSIS package:

 Code: 0xC0014023     Source: Foreach Loop Container      Description: The GetEnumerator method of the ForEach Enumerator has failed with error 0x80004005 "Unspecified error". This occurs when the ForEach Enumerator cannot enumerate.  End Error  DTExec: The package execution returned DTSER_FAILURE (1)

Solution

In this situation, the SSIS package is used to automatically back up all the database cubes from an SSAS instance running on the same machine. The service account used to start the SQL Agent doesn?t have rights in SSAS.

Full story »

To specify multiple values for LIKE or NOT LIKE column filter you must simply press enter after you have typed the first value. Another textbox will be automatically shown under the first one, giving you the possibility to insert multiple filters based on ?OR? condition.

Problem

When trying to modify the MsDtsSrvr.ini.xml file (C:\Program Files\Microsoft SQL Server\110\DTS\Binn) in order to create MSDB directories for storing SSIS packages from multiple instances the ?Access denied? error is received.

The SSIS service is stopped and the user that tries to modify the file is administrator on the server.

Solution

To modify the file you need to start the editor (notepad for example) AS administrator and then open the MsDtsSrvr.ini.xml file.

Full story »