Forum Discussion

misaki233's avatar
misaki233
Helper II
5 years ago
Solved

Unable to create a report server database

Hi , I came up with a problem when I was configuring the RS. User does not have permission to perform this action.   System.Data.SqlClient.SqlException (0x80131904): User does not have permis...
RS
  • FarhanAhmed's avatar
    FarhanAhmed
    5 years ago


    Login to SQL Server with sa or sqladmin

    -Go to Object Explorer
    -Expand Security --> Logins
    -Right Click on Login and select "New Login"
    -Click on search and find that windows user which you are trying to install PBIRS
    -Under Server Role on the Left side assign this user as "sysadmin" role.

FarhanAhmed's avatar
FarhanAhmed
Community Champion
5 years ago

Make sure that the user that you are using to Install PBIRS has the Administrator privileges in SQL Database or Machine.

  • misaki233's avatar
    misaki233
    Helper II
    5 years ago

    FarhanAhmed 
    I am trying to use an existing database but this error also occured. Which role do I need?

    System.Data.SqlClient.SqlException (0x80131904): User does not have permission to perform this action.
    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
    at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
    at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
    at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
    at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(SqlConnection conn, String script, ICommandWrapperFactory commandWrapper)
    at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script)
    at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script)
    ClientConnectionId:47b2bae7-667a-486a-84b9-bcd4cb8e58fc
    Error Number:15247,State:1,Class:16

     

    • FarhanAhmed's avatar
      FarhanAhmed
      Community Champion
      5 years ago


      Login to SQL Server with sa or sqladmin

      -Go to Object Explorer
      -Expand Security --> Logins
      -Right Click on Login and select "New Login"
      -Click on search and find that windows user which you are trying to install PBIRS
      -Under Server Role on the Left side assign this user as "sysadmin" role.