RS 6.2 - Report error: Could not find server 'server_name' in sysservers

Article:TECH44742  |  Created: 2009-09-09  |  Updated: 2009-09-09  |  Article URL http://www.symantec.com/docs/TECH44742
Article Type
Technical Solution

Issue



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'

Solution



Error occurs because remote RS SQL server is not configured as Linked Server.

Execute stored procedure on a server hosting NS (Altiris) database:

USE master;

GO

EXEC sp_addlinkedserver

'server_name'

GO


Legacy ID



48990


Article URL http://www.symantec.com/docs/TECH44742


Terms of use for this information are found in Legal Notices