SQL Server Database Configuration
ScrewDrivers uses Microsoft SQL Server to store configuration data, printer assignments, user information, and reporting data. Whether you're installing SQL Express for a small deployment or connecting to an enterprise SQL Server cluster, these guides will help you configure the database correctly.
Initial Database Setup
If you don't already have SQL Server in your environment, you can use the free SQL Express edition. This guide walks you through installing and configuring SQL Express with the minimum settings needed for ScrewDrivers:
- SQL Express Installation and Configuration for Simplify Suite - Complete SQL Express installation walkthrough
Authentication and Credentials
ScrewDrivers supports multiple authentication methods for connecting to SQL Server. Choose the approach that matches your organization's security policies:
- Database Credentials and Authentication Modes - SQL authentication vs. Windows authentication
- Changing SQL access data after your install - Updating credentials post-installation
Advanced Connection Scenarios
For more complex database environments, these guides cover specialized connection configurations:
- Tricerat Support for Microsoft SQL Server Ports, Instances, and Database Server Aliases - Non-standard ports and named instances
- Connecting to a Different Database Version from Simplify Console - Managing multiple database versions
- SQL Always On Compatibility - High-availability configurations