Three SQLBrowser Event Viewer messages generated on a server running Backup Exec

james_axton
james_axton used Ask the Experts™
on
I'm seeing three errors in the Application event logs of a Backup Exec server, all with the source of 'SQLBrowser'.  The OS is Windows Server 2003 and the Backup Exec version is 12.0.  

The events are back to back with oddly sequential Event Ids: 1, 2, and 3:

Event 1, Source: SQLBrowser - The SQL Configuration for SQL is inaccessible or invalid
Event 2, Source: SQLBrowser - The configuration of the SQL instance MSSQLServer is not valid
Event 3, Source: SQLBrowser - The configuration of the AdminConnection\TCP protocol in the SQL instance BKUPEXEC is not valid

Can anyone help me understand these three errors and offer ways to correct them?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Server Administrator
Commented:
This really seems nothing to worry about per BE.
http://seer.entsupport.symantec.com/docs/283949.htm
 

Author

Commented:
I saw that, but it only addresses one of the three messages.
Rodney BarnhardtServer Administrator

Commented:
I looked and there could be various reason. Here is some information:
One had two different version of SQL on the server and uninstalled the other version.
Here was another solution:
http://community.spiceworks.com/windows_event/show/359-sqlbrowser-3
 
This message appears because the TCP/IP Protocol for the instance is disabled. If desired, you can enable the TCP/IP Protocol for the instance and then configure the IP addresses you want the instance to listen on.
You can try changing the following registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib\AdminConnection\Tcp\TcpDynamicPorts
The default value is 0 change it to 1434. Restart the SQL service and the error from the SQL Browser stop being recorded at every startup.
http://www.sqlcoffee.com/Troubleshooting008.htm
 
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Rodney BarnhardtServer Administrator

Commented:
This MSDN has more information, and also mentions #2 possible being caused by SQL 2000 being on the same box as 2005.
 http://blogs.msdn.com/sqlserverfaq/archive/2009/09/18/sql-browser-service-is-not-running-on-server.aspx

Author

Commented:
rbarnhardt, if I missed multiple installations of SQL Server I'm going to be embarrassed.  I'll check tomorrow morning and report back.  Thanks!

Author

Commented:
This gets slightly complicated.  Under Installed Applications there is only one instance of SQL Server, version 2005.  I was also able to verify that there has only been one SQL Server installation on this server - again, version 2005.    However, there are SQL Server files sitting on another partition that belonged to SQL Server 2000.  This is not an "official" installation, mind you, but rather a back up of sorts that someone made using this spare partition (it's not the C drive, where SQL Server 2005 is).  Do you think those files might be causing the issue?  I personally don't, but I'm also not very well versed in this area.  Do you still think it's safe to ignore these messages?  
Rodney BarnhardtServer Administrator

Commented:
Here is an idea. If you are backing up the other drive, exclude the SQL 2000 files and folders if the are not needed. This may rid your error messages. The errors that you gave do not seem to specify a drive letter, so unless it is showing that in more detail that you did not include AND you are backing up that other partition, then they could be related.

Author

Commented:
I got rid of Event Id 3 by changing the TCPDynamicPorts key from 0 to 1433.  Events 1 and 2 are still present.  I'm inclined at this point to just ignore the messages.  They are only happening when the server is rebooted, and the SQLBrowser service is starting okay.  Here are a few more notes:

- TCP/IP for the BKUPEXEC instance is enabled
- Only one instance of SQL Server is installed
- The SQL server has been patched to SP2
- The only SQL-related files that are being backed up by Backup Exec are SQL Server 2005 databases located on a separate SQL Server 2005 server.  

If this backup server is otherwise healthy, the SQLBrowser service is starting, and backups are being marked as "Complete", do you think there's any reason for concern over events 1 and 2?  Internet searches reveal many frustrated requests for assistance with this very issue, but relatively few successful fixes.
Rodney BarnhardtServer Administrator

Commented:
No. I think it is fine. I was just throwing out the suggestion to try to narrow down the problem. Anything I read seemed to indicate that these messages were no real issue.

Author

Commented:
Thanks for staying with it rbarnhardt!  It's very much appreciated!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial