Mounting database to different web application is also not working

sns 9,236 Reputation points
2023-03-19T17:13:30.24+00:00

We want to restore the bunch of sub sites so we taken DB restore and while trying to mount it is giving to different web app itself giving following error.

I tried to new id & with db server name but still the issue persists

User's image

SQL server is same for backup and where it is restored.

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,342 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emily Du-MSFT 46,166 Reputation points Microsoft Vendor
    2023-03-20T08:25:18.07+00:00

    1.Check permissions for the SharePoint farm account which you are using to run PowerShell. Make sure the SharePoint farm account is granted with “dbcreator” and “Security_Admin” server roles. And it must have db_owner permission for the content database.

    2.Check the IE Enhanced Security Configuration and Firewall are disabled in the SQL Server and SharePoint Server.


    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.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.