Skip to main content

Create new user (if using "SQL Server authentication")

If using SQL Server authentication - as opposed to WIndows (integrated) authentication - you will define users or "logins" in SQL Server Management Studio. The login name and password will have to be noted (they need to be entered in the configuration file "repositories.xml" in the AVIX server). 

To create a new user –  named "avixserver" - perform steps outlined below using MS SQL Server Management Studio. 

Right-click on "Security/Logins", select "New Login...".  On the "General" pane, fill in the details. (You may have to uncheck ‘Enforce password policy’ when creating the new user, depending on the password.)

image.png


On the "Server Roles" pane, add sysadmin role: 


image.png



Back to top