This small article shows you the MSSQL Server 2017 installation required when installing vRealize Automation 7.6.
Prerequisites for MSSQL Server 2017 Installation
- Download Microsoft SQL Server 2017 from the Microsoft site.
- Configure hostname and IP.
- Disable the firewall.
- Attach to the AD domain.
Let’s start MSSQL Server 2017 installation. Click on the first option. “New SQL server stand-alone installation or add features to an existing installation“
Accept the terms of the license agreement.
Click on next.
When the verification operation is complete, click on next.
Select “Database Engine Services + SQL Server Repliaction + SQL Client Connectivity SDK“.
Select “Default instance” click on next.
Set everything to Automatic as shown.
Select “Mixed Mode” then choose the password and click on “Add Current User“.
In this step, the installation is started.
When the installation is compelte, click on close.
Before you finish, check the SQL Server network configuration so that it can respond to queries over the network. To do this, in the Application List, open the SQL Server 2017 Configuration Manager.
In SQL Server Network Configuration => Protocols for MSSQLSERVER verify that TCP/IP is enabled. If disabled, right click to enabled.
Then, be sure to restart the SQL Server service if changes have been made.
Once the installation is complete, it is necessary to activate the Distributed Transaction Coordinator (DTC) service. For this, In the Windows search bar, find and launch comexp.msc. Go to Component Services => Computers => My Computer => Distributed Transaction Coordinator => Local DTC. Right click properties.
Activate the features of the Security tab as in the image below.
Hopefully this post has been informative for you. If you have a question, opinion or request about the article, you can contact us from the comments below or my e-mail address. If you think this post is informative to others, be social and share it on social media! Thank you for reading !!