Error when Reporting on Multiple Servers

Forum for users of Redgate's SQL Backup tool

Error when Reporting on Multiple Servers

Postby jonathan.brown » Mon Dec 03, 2012 7:44 pm

Hello,

I am trying to setup Reporting on multiple servers, and I keep getting the following error message when trying to generate a report:

The metadata could not be determined because statement 'EXECUTE master..sqbdata 'SELECT id,backup_set_uuid,backup_start,backup_end,backup_type,dbname,[encr' invokes an extended stored procedure.

I have successfully created the reporting database, and successfully created and tested the linked servers on the sql server where the reporting database is on. I also made sure the user that is being authenticated has execute rights to the stored procedures in the master database.

I should note that the sql servers that I'm trying to run the report on are sql 2012 servers.

Any help would be appreciated!

Thank you,
Jon
jonathan.brown
 
Posts: 1
Joined: Mon Dec 03, 2012 7:37 pm

Postby andy.campbell.smith » Thu Dec 06, 2012 3:31 pm

It looks like this is a known problem with SQL 2012:

http://connect.microsoft.com/SQLServer/ ... rows-error

There's a few workarounds listed there - does anything there help?
Andy Campbell Smith

Red Gate Technical Support Engineer
andy.campbell.smith
 
Posts: 173
Joined: Thu Oct 20, 2011 10:19 am
Location: Red Gate Software

Re: Error when Reporting on Multiple Servers

Postby MDG_ATI » Wed Sep 21, 2016 8:47 pm

Wow. Issue since 2012. Msft says "not fixing". Any updates? This effectively makes the SQL BACKUP multi-server REPORTING useless for me.
MDG_ATI
 
Posts: 1
Joined: Wed Sep 21, 2016 8:45 pm


Return to SQL Backup Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests

cron