Once an SQL Server Database Engine has been Installed and Configured as desired and a user account has been created CONTROLS Pro studio can perform the remaining setup steps on the database engine.

The easiest way is to create a user that is "SysAdmin" that the program can use to create the database and all required subobjects with. This user will also be the on-going account used by the system for performing transactions in the database.

Can I use "sa"?

Yes, you can. the default SQL Server "sa" account has full access to the system.

Should I use "sa"?

No. This is bad practise and discouraged in the IT community. All user accounts should be specific in purpose so that proper tracking and control is easier for IT groups.

Additionally "SysAdmin" priviledges can be removed and swaped for "dbo" priviledges specific to the newly created database, after installation is completed (but cannot be done if "sa" is used).


Create a User with "SysAdmin" access.

Open SQL Server Management Studio (start menu shown below)

Connect to the Instance of SQL.

This can be on the same machine or a different machine as long as credentials with administrator access are used (either a windows account with admin access on the SQL machine, or the initially configured "sa" account and password manually entered)

Connect.

The Format for "Server" is one of the following

  • ServerName                             {Used when default instance on default port}
  • ServerName\InstanceName       {Used with Instance Install}
  • ServerName,Port                      {Used as alternate to Instance Name when port is static}
  • IP                              {IP can be used instead of Server Name in all above cases}


Expand the "Object Explorer of the Connected Server until the "Logins" Node is located.

Right Click the node as below and select "New Login"

The "General" Page is selected by default. Enter information as indicated below.
(Enter any desireable user name which accurately describes the purpose of the account and remember the password entered. The program will ask for this information later)

Switch to the "Server Roles" Page and Check the "SysAdmin" role.
(This indicates the account can administer the SQL server fully for program configuration)

Other Pages do not need changing, clicking OK creates the user.