...
For Windows 10 type of machines, to locate the computer name of your system:
Open Control Panel. Click System and Security → System.
On the View basic information, see the Full computer name under the Computer name, domain, and workgroup settings section. Visit Windows Support to check the computer name for other types of Windows versions.
From the Windows desktop, select Start→ Microsoft SQL Server Tools 18→ Microsoft SQL Server Management Studio 18.
The Microsoft SQL Server Management Studio opens.Log in to SQL Server using your credentials.
Expand the Databases folder to display the Velocity database in the Object Explorer navigation pane.
Expand the Velocity database to display the Tables branch.
Make the changes specified in the following table by right-clicking each database table and selecting Edit Top 200 Rows from the pop-up menu. (After each change, click outside the edited row for the changes to take effect.)
Note: Be extra careful while editing the tables because accidentally editing the tables can corrupt the database.The table describes the modification of the SQL table properties and their value after a Database restoration. A set of table properties such as Server Name, Remote Computer Name, Remote IP, and Remote Server IP and its value are replaced by the destination system name VEL1-LOCAL-SYSTEM or Windows Domain name.
In this table: | Select this column: | Enter this data: |
---|---|---|
MiscProperties | AuthenticationPath |
|
UseDomainAuthentication |
| |
Organizational Unit (OU) (This column exists only if you selected an Organization Unit during the Velocity installation.) | For example: LDAP://OU=ENGINEERING,DC=SECURITY,DC=com | |
Operators | Name | If you are not logging in as Administrator for OperatorID=2, use your Windows user name. (If you are using the Administrator account, skip this step.) |
DirectorySource |
| |
Servers | Server_Name | Name of the Velocity Server (all UPPERCASE). For example, after restoring the database to a new server, the server name can be \\VEL1-LOCAL-SYSTEM. |
ServerExtensions | RemoteComputerName | Name of the Velocity Server (all UPPERCASE). For example, \\VEL1-LOCAL-SYSTEM. |
Registry | AppPath |
|
Registry | ComputerName | Name of the Velocity Server (all UPPERCASE). For example, VEL1-LOCAL-SYSTEM. |
RemoteIP | Name of the Velocity Server (all UPPERCASE). For example, VEL1-LOCAL-SYSTEM | |
RemoteServerIP | Name of the Velocity Server (all UPPERCASE). For example, VEL1-LOCAL-SYSTEM. | |
SDServer | Name of the Velocity Server (all UPPERCASE). For example, VEL1-LOCAL-SYSTEM. | |
ServerName | SQL Server Instance name. For example, VEL1-LOCAL-SYSTEM\WORKGROUP NAME. | |
Workstations | WorkstationName | Name of the Velocity Server for WorkstationID=1 (all UPPERCASE). For example, the workstation name is VEL1-LOCAL-SYSTEM. |
...
Open certmgr with Administrator permissions and go to Local Computer → Personal → Certificates.
Right-click VelocityTLS certificate → All Tasks → Manage Private Keys...
Select the user VelocityServices and click the Remove button.
Re-add the VelocityServices user and grant Full control.