Critical errors in uls log

Question

When running my sharepoint configuration it failed at the final stage and this is what my uls logs showed me? What is needed to fix these critical errors?

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

Hi @Tevon2.0 ,

• Event ID - 5214
  Windows SharePoint Services uses a service account to communicate with the database on behalf of a user request. For WSS, you must be a member of the SharePoint Administrators group to grant correct permissions to the database access account.
  Here are the specific steps to resolve this event ID error: Event ID 5214 (Windows SharePoint Services health model)
• Event ID - 5617

The Web server and the database must be upgraded to the same version and build level to return to compatibility range.

This prompts you to upgrade the content database.Please try to run the following powershell cmdlet: PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures
See this post for more discussion: There is a compatibility range mismatch between the Web server and database

• Event ID - 5586
  Insufficient permissions on the SQL Server database are one of the causes of this event
• Event ID - 3760
  Any SharePoint service account that requires access to SQL databases requires Security Administrator and DBCreator permissions to SharePoint related databases. Verify that the SharePoint service account has these permissions set for the SharePoint database.
  Reference article: Event 3760 in Application Log

To sum up, the most important thing is to check whether the account is authorized.

======The check steps are as follows:
Open SQL server management studio, expand security – server roles.

Double-click securityadmin and dbcreator separately.

---

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.

Answer 2

Insufficient SQL database permissions for user 'Name: LINGUALISTEK\spfarmadmin

As the message say, doesn't that Windows account do have the required permissions, e.g. is member of the Server role SysAdmin or is the database owner?