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

Tevon2.0 631 Reputation points
2023-01-03T13:49:18.473+00:00

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.

Azure SQL Database
No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Alberto Morillo 24,721 Reputation points Microsoft MVP
    2023-01-04T13:36:53.487+00:00

    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.

    No comments

  2. Haoyan Xue_MSFT 5,341 Reputation points Microsoft Employee
    2023-01-06T07:28:24.383+00:00

    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.
      276777-image.png
    4. Under “User Mapping” tab->Select your SharePoint content database-> Check the db_owner, SPDataAccess, WSS_Content_Application_Pools rights roles.
      276688-image.png

    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.


  3. damien dada 1 Reputation point
    2023-01-06T09:10:56.027+00:00

    Hi, is the problem solved?

    App Lock

    No comments