Compresses, encrypts, secures and monitors SQL Server backups.
Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey
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!
- Posts: 1
- Joined: Mon Dec 03, 2012 8:37 pm
Return to SQL Backup 7
Who is online
Users browsing this forum: No registered users and 0 guests