---

•  

  • Versions: 2012/2014/2016
    
    

  • JDBC Driver Version: 4.2

---

• Check whether your version of Microsoft SQL Server is supported

• Download the JDBC and have this available on the Application node where Zephyr will be installed

• If you are upgrading from Zephyr 4.8, a MySQL Database will already be present. For migrating from MySQL to Microsoft SQL Server, please review the database migration process

• Have the Zephyr installer ready

• Although use of SQL Server Management Studio is not mandatory, it is recommended in order to complete the below setup tasks.

  • Microsoft SQL Server 2016 Express has been used to illustrate the setup process

• Have a fresh installation of Microsoft SQL Server ready

---

The following steps will need to be followed:

• Step 1: Create a user account with the relevant permissions
  
  

• Step 2: Set permissions for remote access

• Step 3: Turn on the SQL Server Browser Service
  
  

• Step 4: Configure Firewall to allow network traffic

• Step 5: Setting up Authentication

• Step 6: Install Zephyr and Connect to the Database

• Step 7: Setting up Memory

• Step 8: Knowing where the Logs reside
  
  

• Step 9: Configuring additional nodes
  
  

In Object Explorer, expand the folder of the server instance in which you want to create the new login.

Right-click the Logins folder under Security. Click on New Login….

In the Login – New dialog box, on the General page, enter the name of a user in the Login name box.

To create a login that is saved on a SQL Server database, select SQL Server authentication. In the Password box, enter a password for the new user. Enter that password again into the Confirm password box.

From the Default database list, select a default database for the login. Master is the default for this option.

From the Default language list, select a default language for the login.

Click OK.

View the newly created Login by expanding Logins under the Security folder.

Next, we need to set the permissions for this Login. Right click on the user and select Properties.

In Properties window, grant the permissions for the user to Alter any database.

The Effective tab will show the minimum permissions that must be provided.

This process has created a new Login user with the correct permissions.

In this step we will enable remote connections on the instance of SQL Server that you want to connect to from a remote computer.

Staying within SQL Server Management Studio, right-click on the server name in the left pane and select Properties.

Select Connections in the left pane and make sure that checkbox Allow remote connections to this server is selected.

Next, we will need to Enable the TCP/IP Protocol. For this, Open SQL Server Configuration Manager, Expand SQL Server Network Configuration and click on Protocols for SQLEXPRESS. Check the Status to ensure that the TCP/IP protocol is enabled. if it is disabled right-click on TCP/IP and select the Enable option.

From the same pop-up options, click on Properties.

In the Protocol tab, make sure that Listen All has a value of Yes. 

Now, navigate to the IP Addresses tab and scroll-down to the APAll section, and enter the port 1433 for TCP Port.

Finally, SQL Server service can be restarted.

Start, Stop, Pause, Resume, Restart the Database Engine, SQL Server Agent, or SQL Server Browser Service

To learn how to Start, Stop, Pause, Resume, Restart the Database Engine, SQL Server Agent, or SQL Server Browser Service, follow the information here: https://msdn.microsoft.com/en-GB/library/hh403394.aspx