Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.