Issue time05:10:00 am, by Tom Green Email 2795 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

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 »


Leave a comment
Issue time05:21:00 am, by Tom Green Email 2105 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 4583 views
Categories: SSIS, Errors, SSAS, Errors

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 »


Leave a comment
Issue time06:28:00 am, by Tom Green Email 16268 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 6126 views
Categories: SSIS, Errors

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 »


Leave a comment
December 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        

Search

Email Subscription

Enter your email address:

Delivered by FeedBurner

Translate

Advertising









XML Feeds

DBA Blog

Latest posts

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

Poll

Which database platform do you use?

View Results

Powered by b2evolution