Backup Exec 2010 (Trial) - Microsoft SQL Server instance is not visible/available in selection list
I have a MS SQL Server 2008 instance running on a remote server with remote agent installed. The server is perfectly accessible from the network as I have other network services using it and working. My problem started with this message after performing a full backup of the server:
V-79-40960-37914 - Database DATABASENAME is configured to maintain transaction logs. Transaction log backups are not being performed. This will result in the log growing to fill all available disk space. Regular log backups should be scheduled or the database should be changed to the simple recovery mode.
Configure a log backup of the database(s) in question
Fine by me, I can create a log backup job in Backup Exec. Problem is, however the SQL Server instance is not visible in the backup selection list. The server is protected by a full server backup so my only interest for this job is to select the SQL Server instance and perform a "Backup log" job.
BE connects to the Remote Agent as local administrator and has no problem backing up other files on the server.
The SQL Server instance on the backup server is selectable and OK.
And this is the problem: On the remote server the SQL Instance isn't found, so I cannot create a pure "Backup log" job.