When a client tries to connect SQL Server with alias, the SQL Server will check whether the client is a 32-bit or a 64-bit program. If the client is a 32-bit program, it will look up 32-bit alias list and find the corresponding connection settings. Otherwise, it will get the settings from 64-bit alias list. Therefore, the alias interpretation is done by the SQL Server.
The PortalProtect setup program cannot be configured to detect or read 64-bit alias. After installation on 64-bit machine, the PP_Master service is a 64-bit program and will use the 64-bit alias to connect to the SQL Server.
If you want to install PortalProtect with SQL alias, you need to configure both 32-bit and 64-bit alias. It is a limitation of the current PortalProtect installation framework. Please add both 32-bit and 64-bit alias to install PortalProtect:
- To configure 64-bit alias, use C:\Windows\System32\cliconfg.exe
- To configure 32-bit alias, use C:\Windows\SysWOW64\cliconfg.exe