MS SQL

This chapter contains an example of a basic Wheel Fudo PAM configuration, to monitor MS SQL connections to a remote MS SQL database server.

In this scenario, the user connects to a MS SQL database using individual login and password using SQL Server Management Studio. When establishing the connection with the remote server, Wheel Fudo PAM substitutes the login and the password with the previously defined values: fudo/password (authorization modes are described in the User authorization modes section).

Prerequisites

The following description assumes that the system has been already initiated. For more information on the initiation procedure refer to the System initiation topic.

Note

Make sure that the SQL Server has the SQL Server and Windows Authentication mode enabled.

Configuration

Adding a server

Server is a definition of the IT infrastructure resource, which can be accessed over one of the specified protocols.

1. Select Management > Servers.
2. Click Add.

3. Provide essential configuration parameters:

Parameter	Value
General
Name	mssql_server
Blocked
Protocol	MS SQL (TDS)
Description
Permissions
Granted users
Destination host
Address	10.0.150.154
Port	1433
Bind address	Any

4. Click Save.

Adding a user

User defines a subject entitled to connect to servers within monitored IT infrastructure. Detailed object definition (i.e. unique login, full name, email address etc.) enables precise accountability of user actions when login and password are substituted with a shared account login credentials.

1. Select Management > Users.
2. Click Add.

3. Provide essential user information:

Parameter	Value
Login	john_smith
Blocked
Account validity	Indefinite
Role	user
Preferred language	English
Full name	John Smith
Email	john@smith.com
Organization
Phone
AD Domain
LDAP Base
Permissions
Granted users
Connections
Connections
Authentication
Type	Password
Password	john
Repeat password	john

4. Click Save.

Adding a listener

Listener determines server connection mode (proxy, gateway, transparent, bastion) as well as its specifics.

1. Select Management > Listeners.
2. Click Add.

3. Provide essential configuration parameters:

Parameter	Value
General
Name	MSSQL_proxy
Blocked
Protocol	MS SQL (TDS)
Permissions
Granted users
Connection
Mode	proxy
Local address	10.0.150.150
Port	1433

4. Click Save.

Adding an account

Account defines the privileged account existing on the monitored server. It specifies the actual login credentials, user authentication mode: anonymous (without user authentication), regular (with login credentials substitution) or forward (with login and password forwarding); password changing policy as well as the password changer itself.

1. Select Management > Accounts.
2. Click Add.

3. Provide essential configuration parameters:

Parameter	Value
General
Name	admin_mssql_server
Blocked
Type	regular
Session recording	all
OCR sessions
Delete session data after	61 days
Permissions
Granted users
Server
Server	mysql_server
Credentials
Domain
Login	fudo
Replace secret with	with password
Password	password
Repeat password	password
Password change policy	Static, without restrictions
Password changer
Password changer	None
Privileged user
Privileged user password

4. Click Save.

Defining a safe

Safe directly regulates user access to monitored servers. It specifies available protocols’ features, policies and other details concerning users and servers relations.

1. Select Management > Safes.
2. Click Add.

3. Provide essential configuration parameters:

Parameter	Value
General
Name	mssql_safe
Blocked
Login reason
Notifications
Policies
Users	john_smith
Protocol functionality
RDP
SSH
VNC
Accounts
admin_mssql_server	MSSQL_proxy

4. Click Save.

Establishing connection with a MS SQL database

1. Start SQL Server Management Studio.
2. Enter previously configured proxy address (10.0.150.150).
3. From the Authentication drop-down list, select SQL Server Authentication.
4. Enter user login and password.
5. Click Connect.

Viewing user session

1. Open a web browser and go to the Wheel Fudo PAM administration page.
2. Enter user login and password to log in to Wheel Fudo PAM administration panel.

3. Select Management > Sessions.
4. Find John Smith’s session and click i.

Related topics:

• Quick start - MySQL connection configuration
• Quick start - SSH connection configuration
• Quick start - RDP connection configuration
• Quick start - HTTP connection configuration
• Quick start - Telnet connection configuration
• Requirements
• Data model
• Configuration