09/25/13
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
09/23/13
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.
09/17/13
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.
Tags: error 0x80004005
08/01/13
Tags: sql profiler
07/22/13
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.
Tags: access denied
|
|