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?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.