Error : Sharepoint agent's PowerShell script errors while connecting to SharePoint DB.

Products

• CA Single Sign On Agents (SiteMinder)

Issue/Introduction

SharePoint agent's Powershell script errors as " The specified network password is not correct", while connecting to SharePoint database using windows authentication for importing the SharePoint agents certificates into SharePoint DB.

Please refer the below screenshot for errors.

Environment

Release : 12.52 SP1 SharePoint agent

Cause

While executing the SharePoint script was unable to access the SharePoint database to update the certificate details.

This is because the script was executing to connect to MS SQML DB via local login credentials and these credentials are no allowed at MS SQL database and hence fails to update the certificate details.

Resolution

Add the local login credentials for the SharePoint database with admin privilege's  for connecting to SharePoint DB via windows credentials using the local admin user to import the SharePoint certificate details via this PowerShell script.