Troubleshooting › Sybase Data Collection Fails Following Restart

Sybase Data Collection Fails Following Restart

Symptom:

After I restart a registered Sybase server, data collection on the server fails with the following errors:

SBSLL007 Failed to execute SQL Statement
SBSLL0024: Data collection fails due to insufficient privileges of the user

Solution:

Do the following:

1. Add the following lines to the Sybase server startup script:

   use tempdb
   go
   sp_dropuser <BSRMUSER>
   sp_addalias <BSRMUSER>, dbo
   go
   

2. Save and close the startup script.

   The Sybase server is now configured for successful data collection.