MSSQL Server Integration

Author: [email protected] 73 views
Welcome to the MSSQL Server Integration Guide

The MyPass Connector for MSSQL is used by the Mypass Password Manager Sync Server to reset passwords for internal database users on MSSQL systems. The connector is installed along with the MyPass Password Manager Server installation but licensed individually and on per user basis.

Password Manager supports easy integration into multiple MSSQL systems from a single implementation. The configuration is done from the Password Manager Administration Client implemented as part of the Password Manager Backend Server. The communication to the MSSQL is done from the Password Manager Gateway Server. The integration is implemented using TCP communication and this can optionally be implemented to use encryption. Technically it connects to the database and executes a stored procedure with the actual logic to reset the password of the MSSQL user. The stored procedure has to be installed before the connector will work. Password Manager requires the following parameters to be configured in the Administration Client to be able to access a MSSQL server.

Parameter Description
Hostname
A fully qualified hostname, a hostname or an IP address
Port
The Port that the server is listening on for the specified instance
Database
The Database in which the Stored Procedure is implemented
Stored Procedure
The name of the Stored Procedure to be called
Account
The name for the account with privileges to execute “alter login...” commands
Password
The password for the account specified
Encryption
Boolean value which decides whether or not encryption shall be used. Encryption requires extra configuration on the server. See www.microsoft.com for details

The various parameters are not actually used by the Connector but are just used to construct a valid formatted MSSQL Connection String and the Administration Client interface allows the administrator to customize the Connection String beyond the rules of the listed parameters. All parameters are stored in the Password Manager Data Storage (ADAM) and sensitive information like account; password and the Connection String are stored with strong encryption.

Configuration
Configuration

As briefly described before, the MyPass Connector for

Testing
Testing

On request basis MyPass Support delivers testing tools

Production
Production

The MyPass Connector for MSSQL is tested against