INFORMATICS

If you need to change your preferred network connection settings in MS SQL or add its alias you can do it in several ways.
This can be done from the "SQL Server Configuration Manager" but it requires installation on each computer and making configuration changes
The other way is to use the regmon utility to perform configuration and transfer registry changes to the other client stations.
Another way to do this is to use the cliconfg.exe utility built into the windows.
However, keep in mind that this tool should be configured for 32 and 64 bit applications otherwise you may have problems connecting to an MS SQL server.
You can also check whether the application is a 32 or 64 bit application and make the appropriate configuration.
When changing only one application, the configuration is entered into the corresponding registry key.
Locate the file cliconfg.exe for Windows XP
64-bit (native): HKLM \ SOFTWARE \ Microsoft \ MSSQLServer \ Client \ SuperSocketNetLib
32-bit (WOW): HKLM \ SOFTWARE \ WOW6432Node \ Microsoft \ MSSQLServer \ Client \ SuperSocketNetLib

Starting the cliconfg.exe application from a 64 bit system with START will start the 32bit version of cliconfg.exe which does not allow you to configure the connection properly.
To run a 64 bit version of cliconfg.exe, go to the folder and run the appropriate program - C: \ Windows \ SysWOW64 \ cliconfg.exe.

How to run cliconfg.exe in the appropriate architecture:
32 bit system
1. Start "C: \ windows \ system32 \ cliconfg.exe"
64 bit system
2. Start "C: \ windows \ syswow64 \ cliconfg.exe"