How to Create a SQL Server User for vNode Integration

Guide to Create an Administrator User in SQL Server (Vester) + Enable Mixed Authentication Mode

What is mixed authentication?

SQL Server supports two authentication modes:

• Windows Authentication: Uses credentials from the Windows operating system.

• SQL Server Authentication: Allows the creation of users managed directly by SQL Server.

To connect from external systems like vNode, SQL Server must be configured in Mixed Authentication Mode.

Part 1: Enable Mixed Authentication Mode in SQL Server

Step 1: Open SSMS and connect as administrator

1. Launch SQL Server Management Studio (SSMS).

2. Connect to your SQL Server instance using Windows Authentication with an account that has administrative privileges.

Step 2: Change authentication mode

1. In the Object Explorer, right-click on the server name and select Properties.
   
   
   

2. Go to the Security tab.

3. Select the option:
   SQL Server and Windows Authentication mode.
   
   
   

4. Click OK to save the changes.

Step 3: Restart the SQL Server service

To apply the changes:

1. In the Object Explorer, right-click the server name and select Restart.
   Alternatively, open “SQL Server Configuration Manager” and restart the SQL Server service from there.

Restarting the service is mandatory after switching the authentication mode.

Part 2: Create the user Vester with administrator privileges

Step 4: Create a new login

1. In the Object Explorer, expand the Security folder.

2. Right-click on Logins and select New Login...
   
   
   

In the login creation window:

• Login name: enter Vester.

• Select SQL Server authentication.

• Enter and confirm a secure password.

• (Optional) Uncheck Enforce password policy if you prefer to disable expiration or complexity requirements.
  
  
  

Step 5: Assign administrator permissions

1. In the left menu of the same window, go to the Server Roles section.

2. Check the box for sysadmin.

This grants the Vester user full administrative access to the SQL Server instance.

3. Click OK to create the login.

Final Step: Test the connection

1. Log out of your current SSMS session.

2. Open SSMS again and connect using:
   
   

• Login: Vester

• Authentication: SQL Server Authentication

• Password: the password you configured

If the connection is successful, the Vester user is ready to use with full administrative privileges.

Recommendation for vNode Integration

The Vester user can be used in vNode to connect to SQL Server:

• As a full administrator (recommended for testing or development environments)

• Or with restricted access to a specific database in production environments

Created by JF