'Unknown Error' trying to add new SM service in Windows 2007 Server
Hint Ref: 020907080001
Hint Date: 08/07/2009
Whilst trying to set up a new Space Manager database service on a Windows 2007 server, the user got the error message 'Unknown Error' when they clicked the 'Finish' button in Sybase Central.
The User was logged on as a user with Administrator rights and it still failed to work when logged on as the actual 'Administrator'.
However the database could be started manually from within Sybase Central.
The solution was to right-click on the Sybase Central icon on the desktop and select 'Run as Administrator'
This allowed the service to be created successfully.
(Please Note: This Procedure can be destructive and should only be used by Advanced Users. RADical Systems (UK) Limited or its Partners cannot be held responsible, in anyway, for any consequence of using this or any other Database Function, Procedure or SQL command. Responsibility resides solely with the user.
IT IS HIGHLY RECOMMENDED THAT A FULL AND VALID SPACE MANAGER DATABASE BACKUP IS TAKEN AND VERIFIED AS VALID BEFORE MAKING ANY CHANGES TO THE DATABASE.)