Configuration methods

You can configure a linked server using the following methods:

• SQL Server Management Studio (SSMS) New Linked Server Wizard

• Transact-SQL (T-SQL) script

Once the linked server is created, you cannot modify its parameters using the wizard in SSMS. You can recreate a linked server using a T-SQL script. You can modify the security settings and server options using either configuration method.

For more details about linked servers, see the Microsoft article Create Linked Servers SQL Server Database Engine.