Issue time08:23:00 am, by Tom Green Email 2270 views
Categories: SQL Server
Problem When trying to restore a backup taken on SQL Server 2000 on a SQL Server 2012 the following error appears:     Msg 3169, Level 16, State 1, Line 2 The database was backed up on a server running version 8.00.0818. That version is incompatible… more »

Leave a comment
Issue time03:04:00 pm, by Tom Green Email 4811 views
Categories: Errors, Server Configuration
When trying to install SQL Server 2008R2 SP1 the following error can appear:   A Failure was detected for a previous installation, patch, or repair For instance ?MSSQLSERVER? during configuration for features [SQL_Engine_Core_Shared, SQL_POWERShel… more »

Leave a comment
Issue time04:33:00 pm, by Tom Green Email 2324 views
Categories: SSIS, Errors
Problem When trying to open / run an SQL Server 2005 SSIS package from BIDS (Business Intelligence Development Studio) or Dtexec.exe tool, the following error can occur: Error 1 Error loading PACKAGE_NAME.dtsx: Failed to decrypt protected XML node "Pa… more »

Leave a comment
Issue time08:18:00 am, by Tom Green Email 4438 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 0x… more »

Leave a comment
Issue time10:51:00 am, by Tom Green Email 2014 views
Categories: SSRS, Errors
Problem When executing an SSRS report the following error appears: An error has occurred during report processing. (rsProcessingAborted) Cannot set the command text for dataset 'DATASET_NAME'. (rsErrorSettingCommandText) Error during processing of t… more »

Leave a comment
September 2023
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


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