...
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.Login 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.To add or edit the data in the SQL table properties, we have considered a scenario with examples that use a sequence of system names, such as vel1.server.system, vel1.local.system, vel1.remote.system etc., based on the entered dataset of table properties and its value that are replaced by the system name VEL1-LOCAL-SYSTEM in the place of its properties such as Server name, Remote Computer Name, Remote IP, and Remote Server IP.
In this table: | Select this column: | Enter this data: |
---|---|---|
MiscProperties | AuthenticationPath |
|
MiscProperties | UseDomainAuthentication |
|
MiscProperties | 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.) |
Operators | 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.server.system \\VEL1-LOCAL-SYSTEM. |
ServerExtensions | RemoteComputerName | Name of the Velocity Server (all UPPERCASE). For example, after restoring the database to a new server, the server name can be vel1.remote.system \\VEL1-LOCAL-SYSTEM. |
Registry | AppPath |
|
Registry | ComputerName | Name of the Velocity Server (all UPPERCASE). For example, after restoring the database to a new server, the server name can be vel1.newserver.system. VEL1-LOCAL-SYSTEM |
Registry | RemoteIP | Name of the Velocity Server (all UPPERCASE). For example, after restoring the database to a new server, the server name can be vel1.remoteIP.system. VEL1-LOCAL-SYSTEM |
Registry | RemoteServerIP | Name of the Velocity Server (all UPPERCASE). For example, after restoring the database to a new server, the server name can be vel1.remoteserverIP.system. VEL1-LOCAL-SYSTEM |
Registry | SDServer | Name of the Velocity Server (all UPPERCASE). For example, after restoring the database to a new server, the server name can be vel1.sdserver.system. |
Registry | ServerName | SQL Server Instance name. |
Workstations | WorkstationName | Name of the Velocity Server for WorkstationID=1 (all UPPERCASE) |
...