cancel
Showing results for 
Search instead for 
Did you mean: 

Deny new connections

bjanker77
Participant
2,311

Hi.

Is it possible to deny all new connections temporarily in SA12 and/or SA16? This would be great for updating the schema and debugging.

br,

Bjarne Anker Maritech Systems Norway

Accepted Solutions (0)

Answers (2)

Answers (2)

MCMartin
Participant
0 Kudos

See the answer to the question How to limit the remote access to the database server? here on this forum.

VolkerBarth
Contributor
0 Kudos

You can do that via the system procedure sa_server_option when setting the options "ConnsDisabled" or "ConnsDisabledForDB" to YES, i.e. with something like

call sa_server_option('ConnsDisabled', 'YES')


or

call sa_server_option('ConnsDisabledForDB', 'YES')


and reset them to 'NO' afterwards.

Confine that very old FAQ here including sample code:

Sample code: How to get full control over a SQL Anywhere server