SQL 2016: Configuring SQL Express


These steps should be done after installing SQL Express as described in the article: Installing SQL Express 2016

This is how to create a new database and add users.

  1. SQL will need to be configured to work in a network environment. To do this, start the SQL Server Configuration Manager. Go to All Programs > Microsoft SQL Server 2016 | Configuration Tools | SQL Server Configuration Manager

  1. In the Configuration Manager, click on SQL Server Network Configuration, Expand it and open up Protocols for SQLEXPRESS. On the right-hand side of the screen, enable TCP/IP.

  1. To finish the changes, the SQL Service needs to be restarted. To do this click on SQL Server Services and in the right hand screen right click on SQL Server(SQLEXPRESS) and click Restart.

  1. Install the SQL Server Management Studio from here: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
    1. Once again, be sure to follow the steps provided here before installing: https://microvellum.zendesk.com/hc/en-us/articles/115000167563-Preparing-Your-Computer-for-Installation-and-Updates-of-Microvellum-Products
    2. Unblock the file as described in step 2 by right-clicking on it and going to Properties
    3. Run this file as an administrator
    4. This installation requires almost no interaction other than clicking Install.
  1. Now it is time to start SQL Express. Click on All Programs > Microsoft SQL Server 2016 > SQL Server Management Studio.

  1. At the opening screen, the server name should come in with the default server name -- Computer name\Instance name -- this name will be the same that will be used later when setting up the data access in Microvellum. Take note!
  2. Depending on your access, you can use the SA account or use your Windows login to connect.

  1. Once the Management Studio opens up completely, right click on the Databases and click on New Database. In the New Database Screen

  1. Give it a name such as Microvellum45_0 (or whichever library version you are using) and click OK.

  1. After creating the database, a login will need to be created for each user who will be connecting to SQL – It is not recommended to use a group profile, but instead individual accounts. To do this, expand Security and right click on the Logins folder and then select "New Login..."
  2. There are two different types of logins you can make -- Windows authentication and SQL Server authentication.
    1. If you are in a domain – it is best to do make a login using Windows authentication mode
    2. If you are in a Peer- to Peer network – a user in SQL Server authentication mode
    3. The best option is to make a user in Windows mode. To do this click the Search… button
    4. You will need to know which method for the data access portion of Microvellum. Take note!
    5. In the Select User or Group window choose the location button and then select "Entire Directory", or your domain server name then hit "OK"
    6. You can now search for users on the network to have access to the SQL server data. Type in the available field the username or the person's name you are trying to add and select the "Check Names" button. Once it has underlined itself as in the picture, click "OK".

12. If you need to make a user in SQL authentication mode, click the SQL radio button type in the desired name and password. If it says the password is not complex enough, then either uncheck the box Enforce password policy or use a more complex password.

13. Now the user needs to be mapped to the databases that they will have rights to use. To do this, click on "User Mapping". In the database column, select the database you are having the user access and put a checkmark in the map field. Then check the box db_owner in the Database role membership area. When you are finished, click "OK"

 Next You will need to configure Microvellum to use the SQL Server database. See the article: SQL Server: Configuring Microvellum and Importing Data into the Server

0 out of 0 found this helpful



Please sign in to leave a comment.