During the SQL Server install process, you will be asked which Authentication Mode to use. We highly recommend using Mixed Mode (which allows both SQL Server and Windows authentication).

Changing SQL Server to enable Mixed Mode Authentication

If you have already installed SQL Server with Mixed Mode Authentication skip this section and go to Automatic Database Setup

If you need to set the Authentication Mode in the future because you missed this step during installation, you can do this through the SQL Server Management Studio utility:

1. Right-click on your server in the Object Explorer and choose Properties.
2. Select the Security section.
3. Under Server Authentication choose "SQL Server and Windows Authentication Mode"
4. Click OK to save the setting change.

You can create the database using QC-CALC Real-Time.

1. Within the application choose Tools > Options > Data Storage. The following screen will appear.

2. Select from the Data Storage Type dropdown (#1) the MS SQL Server selection

3. Click on the Create Database button (#2) and follow the steps in the next image.

4. Enter the server name and SQL instance (if necessary). If you are running SQL Express, this instance is “\SQLExpress” by default.

5. Enter the name you would like for your database. By default, we suggest “qc_calc”.

6. Enter “sa” as the System Administrator ID and the password you specified when installing SQL Server (see SQL Server Setup Guide section on page 1).

Note: If you are getting this information from your IT department, please make sure you get an USER ID and PASSWORD with System Administrator privileges. The ID will be used once to create the QC Calc database, add logins to the server, and add a user to the database.

NOTE (for IT Professionals): The sa user account is only needed for the initial database creation and will not be used going forward. A separate user account called “qccadmin” is created database creation process. This account is given db_datareader, db_datawriter, and db_owner access to this database only. When the database creation is completed, you’ll be presented a message that will inform you with the user name: qccadmin, and the default password: NimdaccQ12 that will be used going forward to connect all copies of any of the Prolink software to the QC Calc database.

This section will help you create a database manually by adding the tables and user permissions. These steps will create the tables of your database, and you will be ready to begin using all Prolink software’s once you have finished. You must use Microsoft’s SQL Server Management Studio to use the database creation method.

1. You will see the following screen when SQL Server Management Studio opens. Click Connect to connect to the SQL Server using Windows Authentication for now.

2. Right-click on Databases on the left-hand column and select New Database.

3. Give your database a name. For this example, we will call our database qc_calc_2 since the standard qc_calc name was used during the Create Database operation. Click OK.

4. Again from the column on the left side, expand Security section

5. Right-click on Logins and select New Login.

6. Create a Login name. For this example, we’ll be using qccadmin

7. Make sure that SQL Server Authentication is selected and then create and confirm a Password. Make sure that the Enforce password policy option is unchecked.

8. Select the database you just created as your Default database. In this example, it would be qc_calc_2. Click OK.

9. Expand Databases on the left-hand side, and then expand your default database. Within that, expand Security.

10. Right-click on Users and select New User.

11. On the General page, set your User Name and Login Name to match the one you just created.

12. On the Membership page, under Database Role Members check db_datareader, db_datawriter, and db_owner. Click OK.

13. On the main Microsoft SQL Server Management Studio window, click New Query.

14. From QC-CALC Real-Time, choose the Tools > Options > Data Storage menu and select from the Data Storage Type dropdown, the MS SQL Server selection

15. Then click the Get Script Only button.

16. Click in the area at the bottom of the screen, click the CTRL+Home keys to go to the very top of that area, then click the CTRL+Shift+End keys to highlight the entire script. Right-click the highlighted text and choose Copy to get the script into the clipboard.

17. Next, return to the Microsoft SQL Server Management Studio window and paste your clipboard into your new query window.

18. Ensure the database you created (qc_calc_2 in our example) is shown in the upper left of the screen and click Execute.

To allow remote access to your SQL server:

1. Open SQL Server Configuration Manager
2. Expand the SQL Server Network Configuration section
3. Select Protocols for SQLEXPRESS (or MSSQLSERVER if you’re using the full version of MS SQL Server)
4. Right-click on TCP/IP and select Enable
5. Right-click on Named Pipes and select Disable

6. Right-click TCP/IP and choose Properties. Select the IP Addresses tab.

7. Scroll down to the very bottom. Enter “1433” for the TCP Port under the “IPAll“ section.

8. Restart the SQLEXPRESS service (or MSSQLSERVER service for the full version of SQL Server)

When you set up a new connection to a database in QC Calc SPC for the first time, you’ll be asked to create a local user (“Local User ID” in the picture below). This is a local user for the QC Calc SPC application specifically. It’s distinct from the user that connects to the database (“User ID” in the picture below). You can also sign into QC Calc SPC with your Windows Single-Sign On user.

Your local QC Calc SPC user account keeps your work separate from other users in the system and prevents another user from inadvertently changing your reports or filters.

Please note that if you attempt to sign in with a local user account that already exists and has a different password, you will be challenged for the correct password. The user account will not be added if there is an existing one with the same name.

You can change the local user signed into QC Calc SPC anytime by going to File > Change Current Login.