Configure MSSQL Stored Procedure
The configuration of the MSSQL Stored Procedure might vary a little for different versions of MSSQL. The following describes how the configuration is completed in a MSSQL Server 2005 Express environment on a Windows 2003 Server. Open the “Microsoft SQL Server Management Studio” and connect to as “SA” or any other administrator account (possibly also the newly created account).
<Insert Image>
Navigate to the “Stored Procedures” node under the master database.
<Insert Image>
Click on the “New Stored Procedure” from the context menu of the “Stored Procedure” node.
<Insert Image>
Paste the code found in the <installdir>\FastPassCorp\FastPassGateway\bin\ConnectorMSSQL\FPC_Password Reset_ForDatabaseUsers.sql file on the Password Manager Server and click on the “! Execute” button on the toolbar.
<Insert Image>
Expand the “Stored Procedures” node and select the “FPC_ResetPassword” node and select “Execute” on its context menu.
<Insert Image>
Fill in parameters and click “OK” to execute.
<Insert Image>
If successful the result will be shown as this and the configured environment is now ready to be used by the Password Manager solution.