I have taken the backup of my existing content db and restored it in a new SPFarm. Both farms are in sync. The same versions have been installed. SP1 & APRIL 2017 CU. (I have verified this).
Now, I have attached the restored contentdb to my new SP farm's SQL instance. and I went to Central Admin and gave details for creating a new web appln in this new farm. I gave the name of the restored content db in the textbox provided for content database name, while creating this new web appln.
Web appln got created, but when I navigated to the home page, and other custom pages, it shows many errors.
I went to event viewer, and got this error:
Log Name: Application Source: Microsoft-SharePoint Products-SharePoint Foundation Date: 6/22/2017 3:31:01 AM Event ID: 3760 Task Category: Database Level: Critical Keywords:
User: mydomain\muser1 Computer: srvr0001 Description: SQL Database 'WSS_Content_5414d7a493df4501b721142d5eff8807' on SQL Server instance 'srvr001\MSSQLSERVER_NPD' not found. Additional error information from SQL Server is included below.
Cannot open database "WSS_Content_5414d7a493df4501b721142d5eff8807" requested by the login. The login failed. Login failed for user 'domain1\muser1'. Event Xml: 3760 15 1 3 0 0x4000000000000000 222978 Application srvr001domaincomputer1 WSS_Content_5414d7a493df4501b721142d5eff8807 srvr001\MSSQLSERVER_NPD Cannot open database "WSS_Content_5414d7a493df4501b721142d5eff8807" requested by the login. The login failed.
Login failed for user 'domain1\muser1'.
I have verified that the user is having full privileges on both web appln, and SQL server end.