MSSQL Server Integration

Estimated reading: 2 minutes 736 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

As briefly described before, the MyPass Connector for MSSQL connects to the

Testing

On request basis MyPass Support delivers testing tools for the MyPass Connectors

Production

The MyPass Connector for MSSQL is tested against MSSQL versions from 2005

MSSQL Server Integration

MSSQL Server Integration

CONTENTS