Morning Review not working on SQL 2008 Servers

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by David Bird » Morning Review not working on SQL 2008...

Morning Review not working on SQL 2008 Servers

Rate Topic

Display Mode

Topic Options

Author

Message

Kim Killian-SiteDataView

Posted Thursday, January 13, 2011 11:01 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 12:06 PM
Points: 30, Visits: 233

Morning Review not working on SQL 2008 Servers.

I've been using the "Morning Review" at every job I have since I discovered it. Love it and it's so useful. I am having an issue though getting it to work with SQL Server 2008. Is there something I need to tweek in the SSIS packages or on the 2008 servers to get it to work? I love it and really want to continue to use it as I migrate from 2000 and 2005 servers to 2008.

Thanks,
Kimberly Killian
Sr. DBA / DB Engineer
www.sitedataview.com

Post #1047462

WayneS

Posted Thursday, January 13, 2011 11:51 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:12 AM
Points: 6,370, Visits: 8,235

If this is the one I'm thinking about, then I use it also. Do you have a table names "SSIS_Errors"? Check that out for the error message being returned for those servers. I ran into the same problem, and I remember needing to change the width of some columns to handle expanded widths in SQL 2008. I just don't remember which ones we needed to modify.

Wayne
Microsoft Certified Master: SQL Server 2008

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings

Post #1047482

Kim Killian-SiteDataView

Posted Thursday, January 13, 2011 12:09 PM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 12:06 PM
Points: 30, Visits: 233

Thanks for responding Wayne! Here are the errors I'm seeing:

component "OLE DB Source" (1) failed validation and returned error code 0xC020801C.

One or more component failed validation.

SSIS Error Code
DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "MultiServer" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

There were errors during task validation.

component "OLE DB Source" (1) failed validation and returned error code 0xC020801C.

Did you receive any of these on your 2008 server?

Thanks,
Kimberly Killian
Sr. DBA / DB Engineer
www.sitedataview.com

Post #1047504

WayneS

Posted Thursday, January 13, 2011 12:43 PM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:12 AM
Points: 6,370, Visits: 8,235

Are you specifying the instance name in the servername fields?
If you're using an alias - is it set up with the instance name?

That error sounds like something we saw dealing with connecting to servers, but I honestly don't remember is that was with the morning review stuff, or in general.

Wayne
Microsoft Certified Master: SQL Server 2008

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Post #1047523

Kim Killian-SiteDataView

Posted Thursday, January 13, 2011 12:53 PM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 12:06 PM
Points: 30, Visits: 233

yes i've tried both the server name and the named instance, neither works Sad

Thanks,
Kimberly Killian
Sr. DBA / DB Engineer
www.sitedataview.com

Post #1047534

WayneS

Posted Thursday, January 13, 2011 12:59 PM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:12 AM
Points: 6,370, Visits: 8,235

At this point, I'm not sure. How about posting everything in the SSIS_Errors table for the last run only? There might be other messages in there that will give us a clue to it.

You can connect to these servers remotely?

Wayne
Microsoft Certified Master: SQL Server 2008

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Post #1047537

Kim Killian-SiteDataView

Posted Thursday, January 13, 2011 1:39 PM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 12:06 PM
Points: 30, Visits: 233

those messages above are all I have in ssi_errors.

Thanks,
Kimberly Killian
Sr. DBA / DB Engineer
www.sitedataview.com

Post #1047554

« Prev Topic | Next Topic »

Permissions