Login failed for farm account when creating a SP2019 farm

prabhat Tunuguntla 1 Reputation point
2022-05-31T05:08:28.353+00:00

Hi All,

I have a farm it has 2 application servers, 2 Web front end servers, 2 distributed cache servers, 2 search servers and 2 database servers.

I have successfully configured, failover cluster and high availability in the database servers.

While configuring SharePoint 2019 with the configuration wizard i have provided listener server name to create the Database, SharePoint configuration wizard is failing to create the Sharepoint_config database.

I am getting below error in the logs "Login failed for user 'xxx\farm'.
System.Data.SqlClient.SqlException (0x80131904): Cannot open database "SharePoint_Config" requested by the login. The login failed.

xxx\farm accout has sys admin,security admin, server admin and DB Creator roles in both the database servers. Still i am not able to create the database.

In the event viewer i am getting below error

SQL Database 'SharePoint_Config' on SQL Server instance 'xxx-xx-SPHL01'(listener name) not found. Additional error information from SQL Server is included below.

Cannot open database "SharePoint_Config" requested by the login. The login failed.
Login failed for user 'xxx\farm'.

Windows Server 2019
Windows Server 2019
A Microsoft server operating system that supports enterprise-level management updated to data storage.
3,453 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,113 questions
Windows Server Clustering
Windows Server Clustering
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Clustering: The grouping of multiple servers in a way that allows them to appear to be a single unit to client computers on a network. Clustering is a means of increasing network capacity, providing live backup in case one of the servers fails, and improving data security.
957 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,798 questions
Windows Server Infrastructure
Windows Server Infrastructure
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Infrastructure: A Microsoft solution area focused on providing organizations with a cloud solution that supports their real-world needs and meets evolving regulatory requirements.
513 questions

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Xuyan Ding - MSFT 7,561 Reputation points
    2022-06-01T09:28:27.12+00:00

    Hi @prabhat Tunuguntla ,

    1.This may be a network communication problem, your application cannot connect to the database engine. Check your firewall for any blocked settings. You could try turning off the Microsoft Windows Firewall, restarting, and see if that works. Of course, there may be many such cases. For details, you could start with SQL for detailed investigation.

    2.If the SharePoint_Config database is missing, you could refer to this article: Regarding the SharePoint_Config database is missing.

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

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  2. Xuyan Ding - MSFT 7,561 Reputation points
    2022-06-02T08:02:04.87+00:00

    Hi @prabhat Tunuguntla ,

    1.I see that you provided the listener server name to create the database and then cannot find the "SharePoint_Config" on the SQL Server instance "xxx-xx-SPHL01".
    Because the "SharePoint_Config" must be on the same SQL Server instance as the Central Administration database ( SharePoint_AdminContent_GUID ), you could check to see if the same instance is used for both databases.

    2.The SharePoint configuration wizard failed to create the configuration database. It is also possible that the maximum degree of parallelism has not been set. Have you set the "max degree of parallelism" to 1 in the SQL Server Instance settings? If not, you could try it.

    The following third-party article hopes to help you: SharePoint 2019: SharePoint Configuration Wizard failed to create configuration database
    Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

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

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  3. Limitless Technology 39,351 Reputation points
    2022-06-06T08:01:24.697+00:00

    Hello

    Thank you for your question and reaching out. I can understand you are having issues related to connecting SP farm

    1.Make sure the application pools and services are running with appropriate accounts. And check if there is a local or network firewall or anti-virus software blocking the request.
    2. Please try to connect to Database using SQL Management studio and see if you are able to connect it.
    3. Please try to connect using actual SQL instance name and not with any Alias name.

    --If the reply is helpful, please Upvote and Accept as answer--

    0 comments
  4. prabhat Tunuguntla 1 Reputation point
    2022-06-30T05:52:59.983+00:00

    Hi Resolved the issue, Network team has disabled the floating IP feature in Azure server. Our issue was resolved after enabling this feature. We have faced another issue Network is loading very slow and sometimes its connecting and we are not able to connect to login to the listener from the secondary node, also its failing to create a SharePoint_Config database while setting up the server. We have ran the Azure powershell script to update Cluster and Listener Ips then Sharepoint started to connect fast and we are able to login to the listener from both the nodes.

  5. Xuyan Ding - MSFT 7,561 Reputation points
    2022-07-01T02:02:37.923+00:00

    Hi @prabhat Tunuguntla ,
    I'm glad to hear you solve the problem ,if you have any issue about SharePoint, you are welcome to raise a ticket in this forum.

    By the way, since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others.". and according to the scenario introduced here: Answering your own questions on Microsoft Q&A, I would make a brief summary of this thread:

    Solution:
    By prabhatTunuguntla-4191:
    Turn on the Floating IP feature in Azure Servers.

    Current status:
    Issue was resolved after enabling the feature.

    You could click the "Accept Answer" button for this summary to close this thread, and this can make it easier for other community member's to see the useful information when reading this thread. Thanks for your understanding!

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

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments