Error: Could not find server 'ServerName' in sys.servers. Verify that the correct server name was specified. Could not use function 'dbo.V_QUERY_RE7_APPEAL' because of binding errors.

When viewing segments in a BBDM marketting effort the summary section returns the error:
This section could not be loaded. Could not find server 'ServerName' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Could not use function 'dbo.V_QUERY_RE7_APPEAL' because of binding errors.

The rest of the application appears uneffected.

A linked server must be added through MS SQL Management Studio. Either manually add a new linked server or run the following code:

USE master;
GO
sp_addlinkedserver
 'INFINITY',  /* Server Name - Change this to your server name */
 'SQL Server'; /* Server Type - Don't change this if it's a SQL DB */
GO

 

Environment

 2.93

Was this article helpful?