Configure MSSQL Stored Procedure

Estimated reading: 1 minute 259 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.

Share this Doc

Configure MSSQL Stored Procedure

Or copy link

CONTENTS