DNS name does not exist error

Question

(SP Server 2019, On-Prim)

I have 3 Virtual machines being utilized. DC01-SPDEV (hosts the DNS manager within), SP2019-SPDEV (Dev environment where initial site collection was created) and SRV-SHAREPOINT (E) (Prod environment).

I first created a web application and site collection within SP2019-SPDEV via central administration. Next, I proceeded to add the web application and IP address 192.168.1.10 within IIS Manager and also within the DNS manager on the DC01-SPDEV VM. Afterwards the site was accessible however after I backed up the farm via central admin on my dev server SP2019-SPDEV, did a powershell restoration on my prod server SRV-SHAREPOINT (E) I couldn't access the site on the prod server. I clicked the same configuration option instead of new if that is of any importance. Why does IE and Microsoft Edge, now give the error message Can’t reach this page The DNS name does not exist. Error Code: INET_E_RESOURCE_NOT_FOUND*. It seems that the DNS manager on DC01-SPDEV is affecting the dev server but not my prod server. Renaming the Connections folder to ConnectionsX did not fix the issue. Were there any steps that I should have taken that I missed?

Below are ULS errors in case they are pertaining to the issue in some manner.

Event ID - 5214
Insufficient SQL database permissions for user 'Name: LINGUALISTEK\spfarmadmin SID: S-1-5-21-1292428093-1580436667-1343024091-22174 ImpersonationLevel: Impersonation' in database 'WSS_Content_LGPORTAL' on SQL Server instance 'SRV-SHAREPOINT'. Additional error information from SQL Server is included below. The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'. The SELECT permission was denied on the object 'syscolumns', database 'mssqlsystemresource', schema 'sys'. The SELECT permission was denied on the object 'stats', database 'mssqlsystemresource', schema 'sys'.

Event ID - 5617
There is a compatibility range mismatch between the Web server and database "WSS_Content_LGPORTAL", and connections to the data have been blocked to due to this incompatibility. This can happen when a content database has not been upgraded to be within the compatibility range of the Web server, or if the database has been upgraded to a higher level than the web server. The Web server and the database must be upgraded to the same version and build level to return to compatibility range.

Event ID - 5586
Unknown SQL Exception 233 occurred. Additional error information from SQL Server is included below. A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

Event ID - 3760
SQL Database 'SharePoint_AdminContent_1b64db8c-0fe9-4eda-9905-895401ed9963' on SQL Server instance 'SRV-SHAREPOINT' not found. Additional error information from SQL Server is included below. Cannot open database "SharePoint_AdminContent_1b64db8c-0fe9-4eda-9905-895401ed9963" requested by the login. The login failed. Login failed for user 'LINGUALISTEK\spfarmadmin'.

Event ID - 6772
There was an internal error invoking the timer job '{91B5D67A-3A06-4468-A082-103DF86014B5}' for service '{561FFAAC-BEE3-4459-BE4C-575E5DD6CCDB}'.

Answer 1

Try to rename connections folder in Windows Registry. Please try the following steps:

1. Open Windows Registry – press down Windows key + R and type regedit into the Run prompt, click OK.
2. Expand folders in the given order – HKEY_LOCAL_MACHINE > Software > Microsoft > Windows > CurrentVersion > Internet Settings > Connections.
3. Right-click the Connections folder and rename it to ConnectionsBackup. Click Enter to save.

On this article you will find more troubleshooting steps.