Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

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

    • Updated:
    • 14 Apr 2016
    • 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
Public

To resolve this issue:

  1. 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".

  2. 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

Premium
Internal
Rating:
Category:
Install; Purchase
Solution Id:
1055166
Feedback
Did this article help you?

Thank you for your feedback!

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support


To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.


Need More Help?

Create a technical support case if you need further support.