| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
View or Configure Remote Server Connection Options (SQL Server) |
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. |
rwestMSFT |
randolphwest |
12/02/2024 |
sql |
configuration |
how-to |
|
[!INCLUDE SQL Server]
This article describes how to view or configure remote server connection options at the server level in [!INCLUDEssnoversion] by using [!INCLUDEssManStudioFull] or [!INCLUDEtsql].
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 [!INCLUDEssDE].
-
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
EXEC sp_helpserver ; -
Connect to the [!INCLUDEssDE].
-
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 [!INCLUDEssNoVersion],
SEATTLE3, to be collation compatible with the local instance of [!INCLUDEssNoVersion].
USE master;
EXEC sp_serveroption 'SEATTLE3', 'collation compatible', 'true'; The remote server must be stopped and restarted before the setting can take effect.