Summary
You cannot install PortalProtect on Windows 2008 R2. The installation log file records the following even if the user is db_owner:
Unable to connect to the PortalProtect configuration database or user does not have sufficient permission. Refer to the Installation Guide for requirements.
Details
The PortalProtect 2.1 setup is a 32-bit program and it cannot detect 64-bit SQL alias.
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:
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