Mounting database to different web application is also not working

sns 8,866 Reputation points

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.
1,965 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emily Du-MSFT 34,106 Reputation points Microsoft Vendor

    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.