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).

../../_images/quickstart_overview_mssql.png

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.

../../_images/server_auth_mode.png

Configuration

../../_images/data_modeling1.png

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.
  1. Provide essential configuration parameters:
Parameter Value
General  
Name mssql_server
Blocked fail
Protocol MS SQL (TDS)
Description fail
   
Permissions  
Granted users fail
   
Destination host  
Address 10.0.150.154
Port 1433
Bind address Any
  1. 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.
  1. Provide essential user information:
Parameter Value
Login john_smith
Blocked fail
Account validity Indefinite
Role user
Preferred language English
Full name John Smith
Email john@smith.com
Organization fail
Phone fail
AD Domain fail
LDAP Base fail
Permissions  
Granted users fail
Connections  
Connections fail
Authentication  
Type Password
Password john
Repeat password john
  1. 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.
  1. Provide essential configuration parameters:
Parameter Value
General  
Name MSSQL_proxy
Blocked fail
Protocol MS SQL (TDS)
   
Permissions  
Granted users fail
   
Connection  
Mode proxy
Local address 10.0.150.150
Port 1433
  1. 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.
  1. Provide essential configuration parameters:
Parameter Value
General  
Name admin_mssql_server
Blocked fail
Type regular
Session recording all
OCR sessions fail
Delete session data after 61 days
   
Permissions  
Granted users fail
   
Server  
Server mysql_server
   
Credentials  
Domain fail
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 fail
Privileged user password fail
  1. 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.
  1. Provide essential configuration parameters:
Parameter Value
General  
Name mssql_safe
Blocked fail
Login reason fail
Notifications fail
Policies fail
Users john_smith
   
Protocol functionality  
RDP fail
SSH fail
VNC fail
   
Accounts  
admin_mssql_server MSSQL_proxy
  1. 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.
../../_images/sql_management_studio.png ../../_images/mssql_connected.png

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.
  1. Select Management > Sessions.
  2. Find John Smith’s session and click i.
../../_images/mssql_ongoing.png ../../_images/player_mssql_session.png

Related topics: