Configure MSSQL Stored Procedure

Author: [email protected] 18 views

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.