Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
How to disable a remote server setup (Transact-SQL)

How to disable a remote server setup (Transact-SQL)

SQL Server 2000

How to disable a remote server setup (Transact-SQL)

To disable a remote server setup

  1. Run the following code on the second server running Microsoft® SQL Server™.
    EXEC sp_remoteoption ServerName1,sa, sa, trusted, false
    EXEC sp_dropremotelogin ServerName1, sa, sa
    RECONFIGURE
    GO
    
    EXEC sp_configure 'remote access', 0
    EXEC sp_dropserver ServerName1
    EXEC sp_dropserver ServerName2
    RECONFIGURE
    GO
    
  2. Stop and restart the second SQL Server.

  3. Run the following code on the first SQL Server:
    EXEC sp_configure 'remote access', 0
    EXEC sp_dropserver ServerName2
    EXEC sp_dropserver ServerName1
    RECONFIGURE
    GO
    
  4. Stop and restart the first SQL Server.

See Also

sp_configure

sp_remoteoption

sp_dropremotelogin

RECONFIGURE

sp_dropserver

Show:
© 2015 Microsoft