Caring for the ScrewDrivers Database
Learn to operate the SQL database behind your ScrewDrivers Pro/Enterprise deployment: inspect it, back it up on a schedule, verify you can restore it, and keep an eye on its health as usage grows.
Learn to operate the SQL database behind your ScrewDrivers Pro/Enterprise deployment: inspect it, back it up on a schedule, verify you can restore it, and keep an eye on its health as usage grows.
How ScrewDrivers v7 components authenticate to the SQL Server database, how to choose between Windows, SQL, and Static Windows authentication, and how to change credentials after installation without reinstalling.
This page shows how to create a db_executor role and assign it to users in instances where db_datareader and db_datawriter is not enough permissions to run stored procedures
How to prepare Microsoft SQL Server for a ScrewDrivers Pro/Enterprise deployment: choosing an edition, installing SQL Express, authentication and permissions, ports, named instances, and database server aliases.
Tricerat ScrewDrivers supports SQL Server Always On availability groups through ODBC Driver 17 for SQL Server, the default driver in version 6.10.0 and later and in all v7 releases.