SQL Server 2008 - Package data source connection string ignored.

Posted on 2009-12-17
Last Modified: 2012-05-08

I have been trying to install RSExecutionLog_Update in order to monitor and analyse my reporting services usage.
After following every step in the following guide - the package worked in my test environment.

However, when doing the same in my production environment, when I try to run the job I started getting the following error:

An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80004005  Description: "Login timeout expired".
An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80004005  Description: "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured

Initial investigation lead me to this articles which solved this error
and another one about changing my Data Source to instead of (local).

My problem now is that when I configure the data source for the RSExecutionLog_Update as follows: Data Source=;Initial Catalog=ReportServer$SUPPORTSPACE;Provider=SQLNCLI10.1;Integrated Security=SSPI;Auto Translate=False;

I get the following job error:

rror: 2009-12-17 13:21:22.62
   Code: 0xC0202009
   Source: RSExecutionLog_Update Connection manager "Source"
   Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80004005  Description: "Login failed for user 'S2REPORTS\AnalysisAdmin'.".
An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80004005  Description: "Cannot open database "ReportServer" requested by the login. The login failed.".

Whatever I try to put in the "Initial Catalog" parameter (Test, XXXXXX) I get the same error and it's clear I do not ask for ReportServer database.
Furthermore, when I create a dummy database called ReportServer, it seems like it is connecting and I get a statement failed error.

Please note that I also tried most variations of connection strings from here:

Appreciate the help,
Question by:supportspace

    Accepted Solution


    The solution was to configure the RSExecutionLog_Update.dtsConfig file that is over riding the instance specified in the data source.
    LVL 29

    Expert Comment

    accept your own solution as the answer and the question will be cleaned up.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now