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

Product / Version includes:

Last updated: 2021/08/28

Solution ID: KA-0001264

Category: Install , Purchase

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.

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

Was this article helpful?

Featured

Automation Center

Education Portal

Online Help Center

Service Status

TrendConnect

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

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

Product / Version includes:

Summary