Microsoft SQL Server Service Account — Setup Guide

Overview Use this guide to create and configure a Microsoft SQL Server service account in MinuteView Console. This service account enables:

• SQL automation tasks — Execute queries and operations against SQL Server databases from MinuteView automation workflows
• Data integration — Read and write data to SQL Server as part of workflow processing

This service account uses SQL Server authentication (username and password) to connect to a SQL Server instance.

---

Network Requirements

The MinuteView server connects directly to the SQL Server instance. Because SQL Server is typically deployed on-premises or within the same network, no internet access is usually required.

Required Network Access

Target	Port	Purpose
Your SQL Server instance	1433 (default) or named instance port	Database queries and operations

On-Premises Deployments

Ensure the MinuteView server can reach the SQL Server instance on the configured port. For named instances, the SQL Server Browser service must be running and UDP port 1434 must be accessible, or use a specific port number in the instance name.

---

1) Prerequisites

SQL Server User Account

Create or identify a SQL Server login for MinuteView to use:

• The account should have appropriate permissions on the databases MinuteView workflows will access
• Use the principle of least privilege — only grant the permissions actually needed
• Consider creating a dedicated SQL login rather than using sa

---

2) Create Service Account in MinuteView Console

1. Navigate to Console → Service Accounts
2. Click New to create a new service account
3. Configure the following settings:

Configuration Fields

Field	Description	Example
Name	A descriptive name for this service account	SQL-Production
Service Account Type	Select Microsoft SQL Server from the dropdown
Instance Name	The SQL Server instance name	DBSERVER\SQLEXPRESS
Username	The SQL Server login username	mv-service
Password	The password for the SQL login	(sensitive — stored securely)

4. Click Save to create the service account

---

3) Troubleshooting

Connection error / Cannot reach SQL Server

• Verify the instance name is correct (format: SERVER\INSTANCE or just SERVER for default instances)
• Check that SQL Server is running and accepting TCP/IP connections
• Ensure firewall rules allow the MinuteView server to reach the SQL Server port
• For named instances, verify the SQL Server Browser service is running

Authentication failed

• Verify the username and password are correct
• Confirm SQL Server Authentication mode is enabled (not just Windows Authentication)
• Check the login is not disabled or locked out

Permission denied on queries

• Verify the SQL login has the necessary permissions on the target database(s)
• Check that the user is mapped to the correct database with appropriate roles