Share via

Failed to connect to the existing server farm located at the specified database server and the name.The database name is not a valid

Umamaheswari Suresh Babu 1 Reputation point
2021-02-17T03:29:36.44+00:00

Am getting error like "failed to connect to the existing server farm located at the specified database server and the name.The database name is not a valid.".But i do have full access for SQL where i can ping,telnet.And the important thing all my applications are not working and also Sharepoint Central AAdmin also stopped working.Kindly help on this.Plz..Thanks in advance

SharePoint Server Development
SharePoint Server Development
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Development: The process of researching, productizing, and refining new or existing technologies.
1,577 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ChelseaWu-MSFT 6,316 Reputation points
    2021-02-17T06:46:36.553+00:00

    Hi @Umamaheswari Suresh Babu , thanks for posting in the Q&A forum.

    Please confirm: Do you run into this error while running SharePoint Configuration Wizard?
    If yes, is this the first time you run Configuration Wizard (during SharePoint installation), or are you trying to add server to the farm?

    Please follow these steps for basic troubleshooting:

    1. Make sure you login as farm account to run the SharePoint Configuration Wizard.
    2. Make sure you have added the farm service account in all WPG groups, also sysadmin, dbcreator and securityadmin rights, db_owner for all SharePoint databases via SQL Server Management Studio.
      Double check if you have assigned all required permissions following this document: Account permissions and security settings in SharePoint 2013.
    3. Make sure you have enabled TCP/IP protocol on SQL Server via SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for MSSQLSERVER.
      You can refer to the article here for detailed troubleshooting steps: SharePoint Troubleshooting: Cannot connect to database master at SQL Server.
    4. Make sure the incoming connections are not blocked by Windows Firewall. Turn off Firewall on all servers if necessary.

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    **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. ravi 1 Reputation point
    2021-06-28T19:42:50.193+00:00

    The issue got fixed after we install the upgrades KB 5001946 & KB 5001922

    0 comments