I can't connect VirtualIP pacemaker SQL server cluster by user domain windows authentication

Question

I can't connect VirtualIP pacemaker SQL server cluster by user domain windows authentication

Nopawich Lertjarurnpongsah 0

I can't connect VirtualIP pacemaker SQL server cluster by user domain windows authentication error 18452

Now i can do :

Connect VirtualIP pacemaker SQL server cluster by Local admin user ex. sa account
Connect Primary node by user domain windows authentication and Local admin user

I install SQLServer2022 on RHEL8.

I need to suggestion some config for SSMS can connect VirtualIP Resource pacemaker by user domain windows authentication.

Thank you.

ps. sorry for the bad english language

Seeya Xi-MSFT 16,676 Reputation points

2023-03-21T07:07:26.25+00:00

Hi @Nopawich Lertjarurnpongsah,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,

Seeya
Seeya Xi-MSFT 16,676 Reputation points

2023-03-22T06:47:11.3933333+00:00

Hi @Nopawich Lertjarurnpongsah,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,

Seeya

1 answer

Your answer

Seeya Xi-MSFT 16,676 Reputation points

2023-03-21T07:07:26.25+00:00

Hi @Nopawich Lertjarurnpongsah,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,

Seeya
Seeya Xi-MSFT 16,676 Reputation points

2023-03-22T06:47:11.3933333+00:00

Hi @Nopawich Lertjarurnpongsah,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,

Seeya

Answer 1

Seeya Xi-MSFT 16,676

Hi @Nopawich Lertjarurnpongsah,

Here are some steps you can follow:

Ensure that the SQL Server instance is configured to accept Windows authentication. You can check this by connecting to the SQL Server instance using SQL Server Management Studio (SSMS) and looking at the server properties.

User's image

If the SQL Server instance is running on a cluster, ensure that the necessary resources (such as network name, IP address, and SQL Server instance) have been properly configured in the cluster and are currently online.

Ensure that the SQL Server instance is configured to allow remote connections. You can check this by opening the SQL Server Configuration Manager and verifying that the SQL Server Browser service is running and that TCP/IP is enabled.

User's image

Best regards,

Seeya

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Nopawich Lertjarurnpongsah 0 Reputation points

2023-04-04T10:34:24.7166667+00:00

thank you for your help but sql server config manager not have in RHEL8

i can resolve problem by i add DNS name for my ip
and now i can connect for all scenario
Nopawich Lertjarurnpongsah 0 Reputation points

2023-04-04T10:35:23.5266667+00:00

and i add SPN in my AD Server for clustername

Share via

I can't connect VirtualIP pacemaker SQL server cluster by user domain windows authentication

1 answer

Your answer