Jump to content


Search the Community

Showing results for tags 'Reporting Services'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Cloud
    • Azure
    • Microsoft Intune
    • Office 365
    • Windows 365
  • General Stuff
    • General Chat
    • Events
    • Site News
    • Official Forum Supporters
    • Windows News
    • Suggestion box
    • Jobs
  • MDT, SMS, SCCM, Current Branch &Technical Preview
    • How do I ?
    • Microsoft Deployment Toolkit (MDT)
    • SMS 2003
    • Configuration Manager 2007
    • Configuration Manager 2012
    • System Center Configuration Manager (Current Branch)
    • Packaging
    • scripting
    • Endpoint Protection
  • Windows Client
    • how do I ?
    • Windows 10
    • Windows 8
    • Windows 7
    • Windows Vista
    • Windows XP
    • windows screenshots
  • Windows Server
    • Windows Server General
    • Active Directory
    • Microsoft SQL Server
    • System Center Operations Manager
    • KMS
    • Windows Deployment Services
    • NAP
    • Failover Clustering
    • PKI
    • Hyper V
    • Exchange
    • IIS/apache/web server
    • System Center Data Protection Manager
    • System Center Service Manager
    • System Center App Controller
    • System Center Virtual Machine Manager
    • System Center Orchestrator
    • Lync
    • Application Virtualization
    • Sharepoint
    • WSUS

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Website URL


Location


Interests

Found 3 results

  1. Following along in the documentation, I get to where I want to install the Reporting Services Point Role. Figure no big deal. In walking through the steps of role setup everything is great until I go to dropdown the selection for the Reporting Server Instance. It does not see the reporting server instance. In looking at the SQL server, I don't see reporting services listed in the Start Menu and I selected Reporting Services on the original install. I've even gone back into SQL setup to look and SQL setup shows it is installed. Anyone have an idea?
  2. Hello, I'm new to SQL and I need help understanding the best approach to our current problem. I need to build a custom parameter-based report in Microsoft SQL Report Builder 3.0 where you select two or more collections as parameters. The report should then cross reference which computers exist in all selected collections and output their name it to the report. I have built a static query I can run against the SQL server directly, but we need to be able to dynamically select a collection for easier reporting purposes. This is the query I use: SELECT v_GS_SYSTEM.Name0 FROM v_GS_SYSTEM WHERE Name0 IN (SELECT Name from v_CM_RES_COLL_CMS0020B) AND Name0 IN (SELECT Name from v_CM_RES_COLL_CMS000D1) I don't know how to proceed in how to make the above query into a parameter report in Report Builder, or how to otherwise get what we're looking for. Does anyone know? Any help is greatly appreciated.
  3. I installed the Reporting Services Point role on my sql2012 site system server. sccm is installed on my sccm primary site server. I set my network username under the reporting services point properties. My account is a full administrator on both servers. When I click on reports under reporting on the monitoring tab it waits for a while and comes back with no reports. I checked the smsadminui.log and get the following. [7, PID:4532][11/21/2014 08:23:44] :[ReportProxy] - User-specified default Reporting Point [sCCM.legislature.intranet] could not be found, [sql2014-SCCM.legislature.intranet] is now the default Reporting Point. [10, PID:4532][11/21/2014 08:23:45] :[ReportProxy] - User-specified default Reporting Point [sCCM.legislature.intranet] could not be found, [sql2014-SCCM.legislature.intranet] is now the default Reporting Point. [6, PID:4532][11/21/2014 08:23:45] :[ReportProxy] - User-specified default Reporting Point [sCCM.legislature.intranet] could not be found, [sql2014-SCCM.legislature.intranet] is now the default Reporting Point. [6, PID:4532][11/21/2014 08:24:07] :[sCCM.legislature.intranet] : Unable to connect to the remote server [7, PID:4532][11/21/2014 08:24:28] :[sCCM.legislature.intranet] : Unable to connect to the remote server [10, PID:4532][11/21/2014 08:24:49] :[sCCM.legislature.intranet] : Unable to connect to the remote server [6, PID:4532][11/21/2014 08:25:10] :[sCCM.legislature.intranet] : Unable to connect to the remote server [24, PID:4532][11/21/2014 08:37:26] :[sCCM.legislature.intranet] : Unable to connect to the remote server [24, PID:4532][11/21/2014 08:37:47] :[sCCM.legislature.intranet] : Unable to connect to the remote server [37, PID:4532][11/21/2014 08:39:58] :[sCCM.legislature.intranet] : Unable to connect to the remote server [37, PID:4532][11/21/2014 08:40:19] :[sCCM.legislature.intranet] : Unable to connect to the remote server When I right click reports and choose report options and select my sql2012 server I get the below error: --------------------------- Configuration Manager --------------------------- There is a problem connectiong to the specified reporting server. Please check the connection and make sure SQL reporting service is running on the specified server. --------------------------- OK --------------------------- Now if i login to my sql server and open the reporting services configuration manager and go to the report manager url section there are two urls: http://sql2012-sccm:80/Reports https://sql2012-sccm.legislature.intranet:443/Reports Clicking on the http link I get your standard there is a problem with the cert click continue to this website in IE. When I click continue I get the webpage cannot be found. If i click on the https link I get a windows security login box. I login with my user creds and it appears to work, I can get to the SQL server reporting services home page. If i try to go to either of these pages when Im logged onto my sccm server I get page cannot be displayed. Anyone have any ideas? Thanks!
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.