Issue time05:10:00 am, by Tom Green Email 2734 views
Categories: SSAS

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


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


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


Full story »

Leave a comment
Issue time05:21:00 am, by Tom Green Email 2083 views
Categories: SSRS

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 »

Leave a comment
Issue time08:18:00 am, by Tom Green Email 4544 views
Categories: SSIS, Errors, SSAS, Errors


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)



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 »

Leave a comment
Issue time06:28:00 am, by Tom Green Email 16211 views
Categories: SQL Server, Performance & Tunning

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.

Leave a comment
Issue time11:16:00 am, by Tom Green Email 6100 views
Categories: SSIS, Errors


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.



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 »

Leave a comment
July 2024
Sun Mon Tue Wed Thu Fri Sat
 << <   > >>
  1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 31      


Email Subscription

Enter your email address:

Delivered by FeedBurner



XML Feeds

DBA Blog

Latest posts

SSAS More...
SSRS More...
Server Configuration More...
Server Configuration More...
Errors More...
SQL Server More...
SSIS More...


Which database platform do you use?

View Results

Powered by b2evolution