In a 64-bit environment, the PortalProtect installation fails to connect to the SharePoint database when the database alias is configured for SharePoint. The following appears in the installation log even if the connection string is valid:
Installation Debug Logs: "${SystemDrive}:\temp\PP_${SERVERNAME}_ISWI.txt" [09/29/09-08:00:04][Install] connect string=Provider=SQLOLEDB;Data Source=MOSS;Initial Catalog=mossfarm1_farm_config;Integrated Security=True;Enlist=False;Integrated Security=SSPI [09/29/09-08:00:04][Install] com error:Invalid connection string attribute [09/29/09-08:00:04][Install] Logon error,code=6.
To resolve this issue:
- Look for the alias in SharePoint DSN.
Always back up the whole registry before making any modifications. Incorrect changes to the registry can cause serious system problems.
Path: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\12.0\Secure\ConfigDB
Key: dsnFor example, "dsn"="Data Source=MOSS;Initial Catalog=mossfarm1_farm_config;Integrated Security=True;Enlist=False". The alias name is "MOSS".
- Configure the alias in both 32-bit and 64-bit SQL Server Client Network Utilities by launching the following:
- C:\Windows\SysWOW64\cliconfg.exe
- C:\Windows\cliconfg.exe