SolarWinds | Serv-U
Contact Support: 866-530-8040 | Contact Sales: 855-498-4154 or email | Show Flags | Login
Serv-U FTP Server Home Page
The Best for Less
Secure file transfer & share files
from anywhere - affordably

FREE for 14 Days
Full featured trial with secure
FTP, file sharing & web transfer


SQL Server Restarted/Failed, Serv-U ODBC Users Do Not Work  -  KB Article #2032

Related Articles --

Serv-U's ODBC database support allows administrators to configure their Serv-U installation to authenticate users against a SQL database such as Microsoft SQL Server, Oracle, MySQL, or PostgreSQL. In the case that the SQL server goes offline, users and groups configured in the database will not be accessible for the time that the SQL server is offline.

When the SQL server goes offline, Serv-U will detect the failure via ODBC and begin a 5 minute countdown. After 5 minutes, Serv-U will try to re-establish the ODBC connection - if the connection succeeds, ODBC users will be able to authenticate again. If the connection fails, Serv-U will wait another 5 minutes and try again.

This method prevents Serv-U from overwhelming Windows or the SQL database with excessive reconnect attempts, and still ensures that after the SQL failure Serv-U will be able to reconnect to the server. This process can be accelerated by manually stopping and starting the Serv-U Service.