Microsoft SQL Server Express Edition Configure Microsoft SQL Server Express for Multiuser Environments

Summary

Go into SQL Configuration Manager which installs as part of SQL Express and enable TCP/IP for the SQL Express instance. The server needs to be trusted on the domain if you are going to use Windows Integrated security.

Note: SQL Configuration Manager is different from Microsoft SQL Server Management Studio (SSMS). You can launch it by running: SQLServerManager15.msc, where 15 is the version number (for SQL Server 2019).
For more information, visit Microsoft's webpage SQL Server Configuration Mananger.

Detailed Steps

  1. Open the 'Run' dialog box by clicking the [Windows Logo Key] + [R] key.
    Type the following: SQLServerManager15.msc and click [OK]. Windows Run Dialog

  2. In the left section, select 'SQL Server Network Configuration' and click 'Protocols for SENT4EXPRESS'.
    Double-click on the 'TCP/IP'. SQL Server Network Configuration TCP

  3. Set 'Enabled' to 'Yes' and click [OK]. TCP/IP Enabled

  4. Switch to the 'IP Addresses' tab. In the IPAll section, copy and paste the value from TCP Dynamic Ports to TCP Port and click [OK].
    Note: The port number may differ from the port in the below screenshot. If the Dynamic Port is 0, delete the value and enter a 5-digit number for the TCP Port. Make a note of the port number. TCP Port

  5. The following message will appear, click [OK]. TCP Warning Message

  6. The service can be restarted by selecting the first item in the left section called 'SQL Server Services'.
    In the right panel, right-click the service that was changed, and select [Restart]. SQL Server Services Restart

  7. Open the Windows Defender Firewall, select 'Advanced Setting' > [Inbound Rules] and click [New Rule...]. Windows Defender Firewall

  8. Select Port as the Rule Type and select [Next]. New Inbound Rule Wizard

  9. Select 'Specific Local Ports' and enter the TCP port number you previously noted. Click [Next]. New Inbound Rule Wizard TCP Port Number

  10. Select 'Allow the Connection' and click [Next]. New Inbound Rule Wizard Allow Connection

  11. Select 'Domain' and 'Private' that the rule applies to and click [Next]. New Inbound Rule Wizard Apply Rule

  12. Name the rule and click [Finish]. New Inbound Rule Wizard Rule Name

Opening the Database from Sentinel Visualizer

From Sentinel Visualizer, open a database from the computer configured in the previous steps. The example below is from Sentinel Visualizer version 9 but can also apply to earlier versions.

  1. From Sentinel Visualizer, select the [File] tab on the menu toolbar and click [Open Database]. Open Database

  2. For the Server Name, enter the computer name and port that you configured above.
    In this example, “mycomputername,49894”, where "mycomputername" is the name of the computer that you configured above. Make sure you use a comma to separate the name and port, not a colon. Open Database

  3. If the user receives a message similar to the image below, select [Yes]. Login Fail

  4. Enter the SQL Server login credentials.
    • SQL Server login: sa
    • Password: S3ntinElL0gin:7@FMS
    SQL Server Login

  5. Select the database to open. When prompted, enter the login credentials.
    • Sentinel Visualizer User name: admin
    • Password: password
    Database Login

Microsoft Certified Partner

Microsoft Partner Netework

Partners Welcome

Do you provide services to government and commercial customers seeking analytic solutions?
Contact us

In-Q-Tel Portfolio Company

InQTel Portfolio Company
Learn more

Discover

Sentinel Visualizer Comparison to IBM's i2 Analyst's Notebook