Problem:
Velocity installation in Client machine fails due to SQL login privileges
In Install Options for Client, select the Velocity Server location and the SQL Server location and click Next.
An error message like the below one shows:
Solution
Start SQL Server Browser service on the Velocity Data Server. This allows locating the Velocity Client installations on SQL Server.
Note: Based on your MS SQL Server 2019, 2017, 2016, 2014, 2012 versions, you must enable the service start mode in SQL Server Browser Properties.
Enable the SQL Server network protocols, Named Pipes, and TCP/IP for SQL in the SQL Server Configuration Manager as shown below.
Restart the SQL server service after clicking OK/Apply.
Turn ON network sharing. Refer https://www.webnots.com/guide-to-windows-10-network-and-sharing-center/ for more details.
Note: Make sure you can ping and get a response from the SQL server and check your firewall settings. Consult your IT department for policies. Refer https://www.sqlshack.com/how-to-connect-to-a-remote-sql-server/ for more details.
Enable SQL Server to allow remote connections to the server that you connect and click OK as shown below.
Problem:
Server machine discovery fails during Velocity installation in the Client machine
Solution:
The solution described here is only applicable in Windows 10 versions 1709, 1803 and 1809. The latest build versions starting from 1909 don’t need a fix.
Goto Control Panel-> Network and Internet-> Network and Sharing Center in Windows 10.
Click Change advanced sharing settings.
<<<Need to document further steps >>>