Maintaining SQL Server Login and Passwords

During the creation of a SIOS Protection Suite SQL resource, the user must enter a SQL administrative username and password for that instance of Microsoft SQLServer. Should the password of this username change at some point in the future, the SQL resource must be updated on all systems in the cluster with this new password. Failure to do so will prevent SIOS Protection Suite from fully monitoring the status of SQL Server on these systems. A warning message will be logged in the Application Event Log, but the SQL resource will not fail as a result of this.

The SQL administrative username and password associated with the SIOS Protection Suite SQL resource can be changed using the SQL Server Configuration tab in the LifeKeeper GUI. To administer a protected SQL Server resource from the LifeKeeper GUI, right-click on the SQL Server resource (on the right hand side of the LifeKeeper GUI) and select properties, then select the SQL Server Configuration tab. Click the Admin Actions button and select Manage User on the SQL Server Configuration page to view or change information about your SQL resource.