When trying to rollup database to rollup core getting error: The database link is invalid

Version 1

    Description: When trying to rollup database to rollup core getting error: The database link is invalid

     

    invalidlink.JPG

     

    Resolution:

    1. Make sure database link is created correctly. See Article: http://community.landesk.com/support/docs/DOC-1097  (This does say for 8.7, but it hasn't changed so use this article)

    2. If using a port other than 1433 then in your datasource type in childdatabasesqlservername, port

    3. If IndexAccessPath is enabled you will need to disable it by doing the following:

         a. Connect to <SQL Server Name>

         b. Expand Server Objects > Linked Servers > Providers

         c. Rick click on SQLNCLI and select properties

         d. You will see this dialog. Make sure 'Index as access path' is unchecked.

    Accesspath.JPG