MSSQL authentication stuck

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

MSSQL authentication stuck

L3 Networker

Hi,

I set up a MSSQL Server login object with the specifica:

Database

Address

Port

Username

 

I am using the pre-definde platform "PSM-SQLServerMgmtStudio".

 

When I am connecting with the lgoin object, the authentication is stuck at the credentials prompt (see screenshot attached).

 

The hostname is not getting forwarded. When I manually fill it in, there is an Authentication error (see attached screenshot).

 

When using the "SQL Server Authentication" and I fill in the hostname and credentials manually, the conncetion can be established.

 

Any suggestions?

Thanks in advance!0682J0000064THrQAM.jpg0682J0000064THmQAM.jpg0682J0000064THhQAM.jpg

4 REPLIES 4

L4 Transporter

Hi @Daniel Wuerz​ ,

 

I've also had that issue once and the issue was that the password was incorrect. Can you try to do this action manual on the PSM server. So log on to the PSM and open the SQL server 2012 application.

 

And then give the values that CyberArk normally fills in. Username, password,..

If this authentication gives the same error you know the error has nothing to do with CyberArk and probably with the credentials.

 

Kind regards,

Jelle

Hi Jelle,

thanks for your reply! The issue is not caused by a wrong password, because the authentication is successfully, when I prompt the credentials manually.

 

Best regards

Mad

L4 Transporter

@Daniel Wuerz​ is this a Windows auth or SQL auth?

If Windows auth, can you confirm if the AD account that requires authentication to the database is provisioned.? Did you try passing master in database file category?

What is the database auth set as, Windows/SQL/MIxed?

L2 Linker

@Daniel Wuerz​ We are also facing the same issue.

We need to ,manually select the authentication as SQL Server Authentication and enter the credentials.

Please let us know if you have a fix for the issue.

  • 432 Views
  • 4 replies
  • 0 Likes
Like what you see?

Show your appreciation!

Click Like if a post is helpful to you or if you just want to show your support.

Click Accept as Solution to acknowledge that the answer to your question has been provided.

The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!

These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!

The LIVEcommunity thanks you for your participation!