Problems during installation of the reporting role in Configuration Manager

Aleksandr Terekhov 21 Reputation points
2023-01-30T15:42:16.4266667+00:00

Greetings

I'm having a problem installing the reporting role

SCCM installed on server A

SQL and Report service install in Server B

But when I start configuring the role, it doesn't show me the name of my reporting role database

SCCM

I read several articles but they did not help me

Tell me what could be the reason?

https://learn.microsoft.com/en-us/answers/questions/984039/unable-to-locate-any-configured-srs-instances-on-t

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,797 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,110 questions
Microsoft Configuration Manager Updates
Microsoft Configuration Manager Updates
Microsoft Configuration Manager: An integrated solution for for managing large groups of personal computers and servers.Updates: Broadly released fixes addressing specific issue(s) or related bug(s). Updates may also include new or modified features (i.e. changing default behavior).
960 questions
Microsoft Configuration Manager Application
Microsoft Configuration Manager Application
Microsoft Configuration Manager: An integrated solution for for managing large groups of personal computers and servers.Application: A computer program designed to carry out a specific task other than one relating to the operation of the computer itself, typically to be used by end users.
457 questions
Microsoft Configuration Manager
0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bjoern Peters 8,781 Reputation points
    2023-01-30T16:00:09.6133333+00:00

    Hi Aleksandr,

    just to be sure...

    Have you already set up a complete Server for SQL and SSRS according to the SQL Server/SSRS documentation?

    For example... Have you checked if SSRS is up and running correctly? Databases and URLs configured?

    https://learn.microsoft.com/en-us/mem/configmgr/core/servers/manage/configuring-reporting

    I hope my answer is helpful to you,

    Your

    Bjoern Peters

    If the reply was helpful, please upvote and/or accept it as an answer, as this helps others in the community with similar questions. Thanks!

    0 comments
  2. Bjoern Peters 8,781 Reputation points
    2023-01-30T16:03:07.19+00:00

    Hi Aleksandr,

    just to be sure...

    Have you already set up a complete Server for SQL and SSRS according to the SQL Server/SSRS documentation?

    For example... Have you checked if SSRS is up and running correctly? Databases and URLs configured?

    https://learn.microsoft.com/en-us/mem/configmgr/core/servers/manage/configuring-reporting

    I hope my answer is helpful to you,

    Your

    Bjoern Peters

    If the reply was helpful, please upvote and/or accept it as an answer, as this helps others in the community with similar questions. Thanks!

    0 comments
  3. Aleksandr Terekhov 21 Reputation points
    2023-01-31T07:49:58.67+00:00

    Yes according to this guide

    As you can see in the screenshot, the database connection check passes, but the Reporting Services server instance

    cannot display ... I can be wrong, but it seems to me that my mistake is somewhere at the level of access rights. Just where?

  4. Aleksandr Terekhov 21 Reputation points
    2023-01-31T08:25:30.12+00:00

    Unable to locate any configured SRS instances on the server. Verify SRS is installed, accessible, and correctly configured. == Exception Type == N/A == Stack Trace == at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) at System.Environment.get_StackTrace() at Microsoft.ConfigurationManagement.Feedback.Common.OcvMessageBox.OcvMessageBox.WindowActivated(Object sender, CbtEventArgs e) at Microsoft.ConfigurationManagement.Feedback.Common.OcvMessageBox.LocalCbtHook.OnWindowActivated() at Microsoft.ConfigurationManagement.Feedback.Common.OcvMessageBox.LocalCbtHook.CbtHookInvoked(Object sender, HookEventArgs e) at Microsoft.ConfigurationManagement.Feedback.Common.OcvMessageBox.LocalWindowsHook.OnHookInvoked(HookEventArgs e) at Microsoft.ConfigurationManagement.Feedback.Common.OcvMessageBox.LocalWindowsHook.CoreHookProc(Int32 code, IntPtr wParam, IntPtr lParam) at System.Windows.Forms.SafeNativeMethods.MessageBox(HandleRef hWnd, String text, String caption, Int32 type) at System.Windows.Forms.MessageBox.ShowCore(IWin32Window owner, String text, String caption, MessageBoxButtons buttons, MessageBoxIcon icon, MessageBoxDefaultButton defaultButton, MessageBoxOptions options, Boolean showHelp) at Microsoft.ConfigurationManagement.AdminConsole.SmsWizardForm.DisplayError(Control errorControl, String errorMessage) at Microsoft.ConfigurationManagement.AdminConsole.SmsPageControl.DisplayError(Control errorControl) at Microsoft.ConfigurationManagement.AdminConsole.SmsPageControl.DisplayError() at Microsoft.ConfigurationManagement.AdminConsole.SmsWizardPage.get_CanDeactivate() at Microsoft.ConfigurationManagement.AdminConsole.WizardFramework.WizardForm.OnNext() at Microsoft.ConfigurationManagement.AdminConsole.WizardFramework.WizardForm.OnNextClicked(Object sender, EventArgs e) at Microsoft.ConfigurationManagement.AdminConsole.WizardFramework.NavigationButtonBar.OnNext(Object sender, EventArgs e) at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnClick(EventArgs e) at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ButtonBase.WndProc(Message& m) at System.Windows.Forms.Button.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) at MS.Win32.UnsafeNativeMethods.DispatchMessage(MSG& msg) at System.Windows.Threading.Dispatcher.PushFrameImpl(DispatcherFrame frame) at System.Windows.Threading.Dispatcher.PushFrame(DispatcherFrame frame) at System.Windows.Window.ShowHelper(Object booleanBox) at System.Windows.Window.Show() at System.Windows.Window.ShowDialog() at Microsoft.EnterpriseManagement.ConsoleFramework.WindowManager.GenericWpfWindowConstructor.BeginShow(ShowViewContext showViewContext, Object parent, Object view, AsyncCallback callback, Object state) at Microsoft.EnterpriseManagement.ConsoleFramework.ViewConstructor.BeginShow(ShowViewContext showViewContext, AsyncCallback callback, Object state) at Microsoft.EnterpriseManagement.ConsoleFramework.WindowManager.WpfWindowRecord.ShowWindow() at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Delegate.DynamicInvokeImpl(Object[] args) at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs) at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler) at System.Windows.Threading.DispatcherOperation.InvokeImpl() at System.Windows.Threading.DispatcherOperation.InvokeInSecurityContext(Object state) at MS.Internal.CulturePreservingExecutionContext.CallbackWrapper(Object obj) at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at MS.Internal.CulturePreservingExecutionContext.Run(CulturePreservingExecutionContext executionContext, ContextCallback callback, Object state) at System.Windows.Threading.DispatcherOperation.Invoke() at System.Windows.Threading.Dispatcher.ProcessQueue() at System.Windows.Threading.Dispatcher.WndProcHook(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled) at MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled) at MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o) at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs) at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler) at System.Windows.Threading.Dispatcher.LegacyInvokeImpl(DispatcherPriority priority, TimeSpan timeout, Delegate method, Object args, Int32 numArgs) at MS.Win32.HwndSubclass.SubclassWndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam) at MS.Win32.UnsafeNativeMethods.DispatchMessage(MSG& msg) at System.Windows.Threading.Dispatcher.PushFrameImpl(DispatcherFrame frame) at System.Windows.Threading.Dispatcher.PushFrame(DispatcherFrame frame) at System.Windows.Application.RunDispatcher(Object ignore) at System.Windows.Application.RunInternal(Window window) at System.Windows.Application.Run(Window window) at Microsoft.EnterpriseManagement.ConsoleFramework.ConsoleApplication.LaunchWindow() at Microsoft.EnterpriseManagement.ConsoleFramework.ConsoleApplication.Run() at Microsoft.ConfigurationManagement.AdminConsole.Program.Main()

    0 comments