"Invalid connection string attribute" appears in the installation log even if the connection string is valid

- Updated:
- 30 Dec 2019
- Product/Version:
- PortalProtect 2.1
- Platform:
- Windows 2000 Server
- Windows 2003 Standard Server Edition

Summary

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.

Details

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: dsn

For 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

Alias