Recovery Solution reports fails with an error: Sql error in query. Error: System.Data.SqlClient.SqlError: Could not find server 'SERVER_NAME' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.System.Data.SqlClient.SqlError: Could not find server 'SERVER_NAME' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.System.Data.SqlClient.SqlError: System.Data.SqlClient.SqlError: Sql CommandText: -- MAX ROWCOUNT SET ROWCOUNT 50000 -- EXEC dbo.sp_RS_DaysWithoutFSSReport @in_ClusterGuid = 'DDD200D1-8156-45EC-A522-45CD44CDABA6', @in_SnapshotDays = '7', @in_Culture = 'en-US'
Error occurs because remote RS SQL server is not configured as Linked Server.
Execute stored procedure on a server hosting NS (Altiris) database:
Imported Document Id
This is machine translated content
Login to Subscribe
Please login to set up your
For security reasons, your link to this document has expired. Please click on the attachment link to access this file.
The attachment that you are looking for no longer exists.
There has been an issue retrieving your attachment. Please try again.
Currently server is down.
Didn't find the article you were looking for? Try these resources.