Troubleshooting GFI Archiver SQL Server Connectivity Issues

Information

To resolve connectivity issues between GFI Archiver and the SQL server, follow these steps:

1. Verify SQL Server Registration:
   • Open Microsoft SQL Management Studio.
   • Right-click on the SQL Server node and select 'New Query'.
   • Enter the command: SELECT @@servername and execute it.
   • If the result is NULL, register the SQL server name:

     Exec sp_dropserver 'servername'
     Exec sp_addserver @servername='GFI-Archiver.pzugroup.pzu.local' @local='LOCAL'

   • Replace 'servername' with your actual server name.
   • Restart the Microsoft SQL Server service.
2. Check SQL Server Configuration:
   • Ensure named pipes and TCP/IP protocols are enabled in SQL Server Configuration Manager.
   • Verify the SQL server instance name is correctly configured in GFI Archiver.
3. Verify SQL Server Permissions:
   • Ensure the SQL login used by GFI Archiver has elevated permissions, similar to the System Administrator (SA) account.
   • Confirm the account can create/modify databases, execute queries, and perform schema updates.
4. Exclude GFI Directories from Antivirus Scanning:
   • Configure antivirus software to exclude GFI directories from real-time scanning.
5. Check Network and Disk Health:
   • Perform disk and database integrity checks.
   • Ensure no network issues affect SQL server connectivity.
6. Update Credentials in Archiver Store Wizard:
   • If the above steps do not resolve the issue, update the credentials in the Archiver Store Wizard to ensure successful connection to the SQL server.