Hi,
am trying to get remote backup of MSSQL server.
AM getting below error.
Failed to backup XXXX database with “Full” backup type: The StoredProcedure ‘[dbo].[USP_]’ cannot be scripted as its data is not accessible. > Property TextHeader is not available for StoredProcedure ‘[dbo].[USP_]’. This property may not exist for this object, or may not be retrievable due to insufficient access rights. The text is encrypted.
If I connect run the utility on same server, then it is working.
Could you please help me.