Mounting database to different web application is also not working

sns 9,246 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.

Microsoft 365 and Office | SharePoint Server | For business
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emily Du-MSFT 51,836 Reputation points Microsoft External Staff
    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.