• Open SQL Server Configuration Manager

If you are struggling to find SQL Server Configuration Manager then you can use the 'Run' Command to open it. Open the Start Menu and type 'Run'. In the Run command window, you can type 'SQLServerManager<version>.msc' and hit Enter. Replace <version> to match your required SQL version seen here: SQL Server 2019 SQLServerManager15.msc  SQL Server 2017 SQLServerManager14.msc  SQL Server 2016 SQLServerManager13.msc  SQL Server 2014 SQLServerManager12.msc SQL Server 2012 SQLServerManager11.msc

• Click SQL Server Services, ensure that the SQL Server service and SQL Browser service for your used server are Running. If they are not running, right-click and click Start

• Open SQL Server Network Configuration and choose your used server.
  • Ensure that TCP/IP is enabled

• Right-click on 'TCP/IP' and choose 'Properties'
• Navigate to 'IP Addresses'

• Scroll to the bottom and take note of the Port number(s) used in IPAll

• Launch SQL Server Management Studio

• Define or choose your required server/instance and log in

• In the Object Explorer, right-click on 'Databases' and choose 'New Database...'

• Enter the name of your desired database and click 'OK 
• (Database name have to be in lowercase and with no space )

• You should see your database now available in the object explorer

• In the Object Explorer, right-click on the server and choose 'Properties'

• Navigate to Security and ensure that 'SQL Server and Windows Authentication Mode' is selected. Click on OK.

• In the Object Explorer, expand the 'Security' branch, right-click 'Security' and choose 'New Login..'.

• Define a login name and a password
• Disable password policy

• Navigate to 'Security', map user to your database and assign the 'db_owner' role.

• Click 'OK'. You should see your user inside of the logins branch

• Click on the 'Open File' button in the toolbar.
• Select the SQL script 'SQLServer_Ind--.sql' applicable to your version

When adding the tables to your database, you must use the correct 'Ind' version to ensure that the schema version of the database is compatible with the verson of CVI Net Web you intend to use. See here for information about database version compatibility in CVI Net Web

• After selecting the correct SQL file it should be open in a query like seen here

• Ensure the target is set to your desired database

• Ensure your cursor is before line 1 of the query and click the 'Parse' button on the toolbar or press Ctrl+F5 to validate the query
• The Results pane should show "Command(s) completed successfully."
• Click the 'Execute' button on the toolbar or press F5 to run the query
• The Results pane should show multiple results all stating "1 row(s) affected."

• If you have no errors in this window then your tables should have been created successfully
• If you see any errors in this window - - then screenshot them and contact support.

• After creating your tables, you can check they have successfully been created by right-clicking on your database inside of the Object Explorer, clicking 'Refresh' and expanding to see your tables.

Open ODBC data sources, you can do this by typing ODBC into the Start Menu or finding it directly on the C drive. The file location will depend on whether your machine is using and 32 or 64 bit processor.

• 32 bit = C:\Windows\System32\odbcad32.exe
• 64 bit = C:\Windows\SysWOW64\odbcad32.exe

• In the 'System Data Sources' tab, click on Add

• Select the SQL Server Data Source

• Name the Data Source "cvinet_sqlserver"
• Choose the SQL Server/Instance where you have created your database
• Click Next

• Select 'SQL Server Authentication'
• Define the username and password that you set when creating your CVI Net Web database
• Click Next

• If your credential supplied were correct then you will see the below screen, otherwise you will see error messages reading that the login could not be achieved.

In the event of seeing error message regarding login, please consult the server administrator

• On the below menu, define the default database for the data source as your CVI Net Web database
• Click Next

• Click Finish
• You will see that a new windows appears asking to test the data source, click ' Test the Data Source...'

If all is configured correctly in your SQL Server instance to allow for remote connection then you should see that the test succeeds like below

In the event of seeing error message regarding login, please consult the server administrator

• Launch MySQL Workbench

• Click on your desired instance and log in

• After successfully logging into the instance, click 'Database' at the top of the window and then select 'Manage Connections'.

• With the 'Manage Server Connections' window open, click on the 'SSL' tab. Ensure that the property 'Use SSL' is set to No.

• Click on 'Test Connection' and verify that you can successfully connect to the server instance and that SSL is not enabled. You should the following dialog message.

• Click on the 'Create Schema' icon in the toolbar
• Define a name for your schema and then click 'Apply'.

• With the 'Apply SQL Script to Database' window open, click 'Apply'

• Click 'Finish'.

If you look at your Navigator menu, you should see your schema has been created and is now available in your instance.

• In the navigator menu, select 'Users and Privileges'

• Select 'Add Account'
• Define your account's login details

• Go to 'Schema Privileges' tab and click 'Add Entry...'

• With the 'New Schema Privilege Definition' window open, click 'Selected Schema', your CVI Net Web database and then click on 'OK'.

• Click 'Select "ALL"' to give all rights to your dedicated user

• Click 'Apply'

• In the navigator menu, double-click your database inside the Schemas sub-menu

• Click 'File' at the top of the window and then choose 'Open SQL Script'

• Select the SQL script 'MySQL_Ind--.sql' applicable to your version

When adding the tables to your database, you must use the correct 'Ind' version to ensure that the schema version of the database is compatible with the verson of CVI Net Web you intend to use. See here for information about database version compatibility in CVI Net Web

• After selecting the correct SQL file it should be open in a query like seen here

• Click on the 'Execute Query' icon in the toolbar
• Check the output window to check all tables were created correctly

• If you have no errors in this window then your table should have been created successfully
• If you see any errors in this window- - then screenshot them and contact support.

• After creating your tables, you can check them by right-clicking on your database inside of the Schemas submenu and expanding the 'Tables' branch

• You're database should now be successfully set-up to be used by the CVI Net Web service.