MS SQL Server for AVIX
This book intends to document how a successful MS SQL Server "setup" is achieved. I.e. necessary configuration of the SQL Server instance, as well as the creation of a DB instance that is to be used for AVIX purposes.
AVIX 5.1 has been verified to work with:
- MS SQL Server 15.0.2110 - SQL Server 2019
* See MS SQL Server Server Versions list on https://www.sqlserverversions.com/
* To find the RTM (build version), you can use MS SQL Server Management Studio: right-click on the SQL Server instance in "Object Explorer" and see "Properties".
Online references
Detect server version https://www.sqlserverversions.com/ Helps you to detect the release versio...
SQL Server setup
SQL Server port 1433 is a default port. Below, it is assumed that 1433 is used, but that may of ...
Create new user (if using "SQL Server authentication")
If using SQL Server authentication - as opposed to WIndows (integrated) authentication - you will...
Create new DB
Right-click on the “Databases” node, and select “New database...”