An exception of type System.Data.SqlClient.SqlException was thrown.

Question

Recieved this error when running my sharepoint configuration.

An exception of type System.Data.SqlClient.SqlException was thrown. Additional exception information: Cannot open database "SharePoint_AdminContent_1b64db8c-0fe9-4eda-9905-895401ed9963" requested by the login. The login failed.
Login failed for user 'LINGUALISTEK\spfarmadmin'

Begin trace logging for SharePoint 2019 Products Configuration Wizard. Version 16.0.10393.20000
12/30/2022 10:15:43 1 INF Entering function PsconfigUserInterfaceMain.Main
12/30/2022 10:15:43 1 INF Entering function Common.SetCurrentThreadCultureToInstalledCulture
12/30/2022 10:15:43 1 INF Entering function Common.SetThreadCultureToInstalledCulture
12/30/2022 10:15:43 1 INF Current thread culture is English (United States), current thread ui culture is English (United States), installed culture is English (United States)
12/30/2022 10:15:43 1 INF Leaving function Common.SetThreadCultureToInstalledCulture
12/30/2022 10:15:43 1 INF The current ui culture English (United States) is NOT right to left
12/30/2022 10:15:43 1 INF Leaving function Common.SetCurrentThreadCultureToInstalledCulture
12/30/2022 10:15:43 1 INF Creating the psconfig application context
12/30/2022 10:15:43 1 INF Entering function PsconfigApplicationContext.PsconfigApplicationContext
12/30/2022 10:15:43 1 INF Entering function UserInterface.UserInterface
...

See the full log here.

Answer 1

This may be related to permissions. Could you please verify the sp_farm admin has all the permissions required? Please read here all permissions.

A Microsoft MVP shared some troubleshooting steps on this article. Please try those steps.

If that is not the case, could you download ULS Viewer and examine the logs with more detail.

Answer 2

Hi @Tevon2.0 ,
Make sure the Farm Account "LINGUALISTEK\spfarmadmin" has enough access to the content database!
Here are steps:

1. Go to SQL Server QL server management studio->expand Security->Logins
2. Under Logins right-click on your Farm Admin Account and select Properties
3. Click Server Roles-> Check "LINGUALISTEK\spfarmadmin" has the server roles: dbcreator, public, securityadmin.
   
4. Under “User Mapping” tab->Select your SharePoint content database-> Check the db_owner, SPDataAccess, WSS_Content_Application_Pools rights roles.
   

---

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 3

Hi, is the problem solved?

App Lock