Troubleshooting SQL Login Problems

Overview of SQL Login

BackupAssist will log into your SQL Server using SQL Authentication. This method of authentication is where you specify a username and password to login.

Setting up BackupAssist

The general procedure for setting up BackupAssist is given in the HTML Help file that comes with BackupAssist. It's also available online:

http://www.backupassist.com/HTMLHelp/Tips_SQL.htm

Known issues

Authentication is known to fail if you have an ODBC data source set up with incorrect login information. This is regardless of whether the BackupAssist settings are correct.

The following information was supplied to us by Paul Parker of Queensland, Australia. Our thanks go to Paul for this information.

This was the error in the log file:

[DBNETLIB]SQL Server does not exist or access denied.

[DBNETLIB]ConnectionOpen? (Connect()).

In addition to the Backup Assist pdf for setting up SQL backup, I had to check the ODBC Data Sources>System DSN options under the account that Backup Assist runs under (in this case it was Administrator). The Cytrack SQL DSN was listed here, I clicked through the configure wizard for this DSN and found that the authentication wasn’t set correctly. I entered the sa account details and clicked through the wizard to the end and tested the data source, this passed. I then ran a test backup to see whether it had fixed the problem and it appears to have done the trick.

It was a funny problem but with a relatively easy fix in the end.