| title | View or Configure Remote Server Connection Options (SQL Server) | |||
|---|---|---|---|---|
| description | Learn how to view or configure remote server connection options at the server level. You can use SQL Server Management Studio or Transact-SQL for this purpose. | |||
| author | rwestMSFT | |||
| ms.author | randolphwest | |||
| ms.date | 08/26/2025 | |||
| ms.service | sql | |||
| ms.subservice | configuration | |||
| ms.topic | how-to | |||
| helpviewer_keywords |
|
[!INCLUDE SQL Server]
This article describes how to view or configure remote server connection options at the server level in [!INCLUDE ssnoversion] by using [!INCLUDE ssManStudioFull] or [!INCLUDE tsql].
Important
[!INCLUDE ssNoteDepFutureAvoid]
Executing sp_serveroption requires ALTER ANY LINKED SERVER permission on the server.
-
In Object Explorer, right-click a server, and then select Properties.
-
In the SQL Server Properties - <server_name> dialog box, select Connections.
-
On the Connections page, review the Remote server connections settings, and modify them if necessary.
-
Repeat steps 1 through 3 on the other server of the remote server pair.
-
Connect to the [!INCLUDE ssDE].
-
From the Standard bar, select New Query.
-
Copy and paste the following example into the query window and select Execute. This example uses sp_helpserver to return information about all remote servers.
USE master;
GO
EXECUTE sp_helpserver;-
Connect to the [!INCLUDE ssDE].
-
From the Standard bar, select New Query.
-
Copy and paste the following example into the query window and select Execute. This example shows how to use sp_serveroption to configure a remote server. The example configures a remote server corresponding to another instance of [!INCLUDE ssNoVersion],
SEATTLE3, to be collation compatible with the local instance of [!INCLUDE ssNoVersion].
USE master;
EXECUTE sp_serveroption 'SEATTLE3', 'collation compatible', 'true';The remote server must be stopped and restarted before the setting can take effect.