Forums on Intune, SCCM, and Windows 11

Welcome to the forums. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your topics and posts, as well as connect with other members through your own private inbox!

PENDING Reporting service error

  • Thread starter Thread starter ER_singh
  • Start date Start date
  • Replies Replies 2
  • Views Views 440

ER_singh

Member
Messages
15
Solutions
1
Reaction score
0
Points
1
Hi Prajwal ji,

I am facing a issue with the reporting service credential there is an issue with this.
I am attaching a snippet of the error and also, My SCCMadmin user credentials are not accepted but built-in account administrator password accepted for reporting services login.
after login, it show "reporting service error." snippet attached
If i want to change the credentials of reporting services it show these error"
System.Data.SqlClient.SqlException (0x80131904): Database 'ReportServer' does not exist. Make sure that the name is entered correctly.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.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:f1116f46-d7aa-4b7f-af76-fa9eb57f76bd
Error Number:911,State:1,Class:16
Please help me.
 

Attachments

  • SCCM error reporting servcies.png
    SCCM error reporting servcies.png
    61.7 KB · Views: 6
  • error after change the credentials.png
    error after change the credentials.png
    309.9 KB · Views: 7
  • changed credentials to service auth to windows credentials.png
    changed credentials to service auth to windows credentials.png
    142.9 KB · Views: 7
  • changing credentials reporting servcies.png
    changing credentials reporting servcies.png
    153.8 KB · Views: 8

Forum statistics

Threads
7,122
Messages
27,817
Members
18,118
Latest member
hariprasad

Latest posts

Back
Top