Configuration parameters for remote logins  Controlling the number of active user connections

Chapter 15: Managing Remote Servers

Allowing remote access

To allow remote access to or from a server, including Backup Server, set allow remote access to 1:

sp_configure "allow remote access", 1

To disallow remote access at any time, set allow remote access to 0:

sp_configure "allow remote access", 0

Only a System Security Officer can set the allow remote access parameter.

NoteYou cannot perform database or transaction log dumps while the allow remote access parameter is set to 0.





Copyright © 2005. Sybase Inc. All rights reserved. Controlling the number of active user connections

View this book as PDF