tag:blogger.com,1999:blog-4344063455110164362.post2971070319414428786..comments2024-03-27T18:08:02.155+00:00Comments on Gerry Hampson Device Management: ConfigMgr 2012 / SCCM 2012 SP1 Step by Step Guide Part 14: SQL ReportingGerry Hampsonhttp://www.blogger.com/profile/09914662193585861190noreply@blogger.comBlogger19125tag:blogger.com,1999:blog-4344063455110164362.post-76501806564696127222014-11-02T12:18:58.198+00:002014-11-02T12:18:58.198+00:00Glad you sorted it out SuryaGlad you sorted it out SuryaGerry Hampsonhttps://www.blogger.com/profile/09914662193585861190noreply@blogger.comtag:blogger.com,1999:blog-4344063455110164362.post-36357639170683500812014-10-30T12:53:00.565+00:002014-10-30T12:53:00.565+00:00Hi Gerry,
The issue is resolved. Missed the simpl...Hi Gerry,<br /><br />The issue is resolved. Missed the simplest of things. my SMS_executive service was in stopped state. Do not how or why it was stopped. However once that is started, all the reports are now in my console.<br />Thanks for all your help.Anonymoushttps://www.blogger.com/profile/12340833166154011854noreply@blogger.comtag:blogger.com,1999:blog-4344063455110164362.post-12701476178199776882014-10-29T08:43:39.863+00:002014-10-29T08:43:39.863+00:00Also your problem could be that your virtual direc...Also your problem could be that your virtual directories have not been created in IIS. Have a look<br /><br />http://myitforum.com/myitforumwp/2012/10/10/reporting-services-site-role-setup-instance-blankempty/Gerry Hampsonhttps://www.blogger.com/profile/09914662193585861190noreply@blogger.comtag:blogger.com,1999:blog-4344063455110164362.post-82118910149429480672014-10-29T08:41:23.187+00:002014-10-29T08:41:23.187+00:00SSRS is not cluster aware. It must be configured a...SSRS is not cluster aware. It must be configured as a scale-out solution. Have you done this? You can find good information about this here:<br /><br />https://social.technet.microsoft.com/Forums/en-US/4479e73e-8a19-4c7e-9418-b36770656b9b/sccm-2012-reporting-point-server-instance-blankGerry Hampsonhttps://www.blogger.com/profile/09914662193585861190noreply@blogger.comtag:blogger.com,1999:blog-4344063455110164362.post-3333227402153152612014-10-27T11:04:17.270+00:002014-10-27T11:04:17.270+00:00Hi Gerry, Yes it is a remote SQL on a CLSUTER and ...Hi Gerry, Yes it is a remote SQL on a CLSUTER and the account is provided sysadmin role in SQLAnonymoushttps://www.blogger.com/profile/12340833166154011854noreply@blogger.comtag:blogger.com,1999:blog-4344063455110164362.post-56682117454156792062014-10-27T10:33:51.207+00:002014-10-27T10:33:51.207+00:00I am unable to enable the reporting point in my pr...I am unable to enable the reporting point in my primary site server, however the same is possible when i try to create reporting point in sql server. Does this make sense?Anonymoushttps://www.blogger.com/profile/12340833166154011854noreply@blogger.comtag:blogger.com,1999:blog-4344063455110164362.post-62268049968244681042014-10-27T10:32:23.013+00:002014-10-27T10:32:23.013+00:00Hi Gerry,
Thanks for the response. Its a remote SQ...Hi Gerry,<br />Thanks for the response. Its a remote SQL. Yes, the install account is a sys admin in SQL and is a local admin of the SQL.<br />Anonymoushttps://www.blogger.com/profile/12340833166154011854noreply@blogger.comtag:blogger.com,1999:blog-4344063455110164362.post-52055313837934633392014-10-24T15:01:14.878+01:002014-10-24T15:01:14.878+01:00You haven't given enough information Surya. Is...You haven't given enough information Surya. Is this local or remote SQL? Is your installation account local administrator of the SQL server and sysadmin role in SQL?Gerry Hampsonhttps://www.blogger.com/profile/09914662193585861190noreply@blogger.comtag:blogger.com,1999:blog-4344063455110164362.post-28610588801234236632014-10-22T11:17:22.189+01:002014-10-22T11:17:22.189+01:00Hi Gerry,
Whn i enable the reporting point, the in...Hi Gerry,<br />Whn i enable the reporting point, the instance is blank. i installed SRS, configured it and still the same prbm. any help is appreciated.Anonymoushttps://www.blogger.com/profile/12340833166154011854noreply@blogger.comtag:blogger.com,1999:blog-4344063455110164362.post-44591247406460060692014-10-16T13:06:12.477+01:002014-10-16T13:06:12.477+01:00I don't understand Amir.I don't understand Amir.Gerry Hampsonhttps://www.blogger.com/profile/09914662193585861190noreply@blogger.comtag:blogger.com,1999:blog-4344063455110164362.post-85178421229963253002014-10-15T18:45:14.479+01:002014-10-15T18:45:14.479+01:00software metering reports can't seem in sccm ...software metering reports can't seem in sccm 2012 r2<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4344063455110164362.post-62565400480839478992014-04-09T16:45:50.510+01:002014-04-09T16:45:50.510+01:00I ALWAYS insist of local SQL to avoid this kind of...I ALWAYS insist of local SQL to avoid this kind of problem.Gerry Hampsonhttps://www.blogger.com/profile/09914662193585861190noreply@blogger.comtag:blogger.com,1999:blog-4344063455110164362.post-70625356050154558272014-04-08T22:02:33.592+01:002014-04-08T22:02:33.592+01:00Have you heard or installed 2012 R2 with the Prima...Have you heard or installed 2012 R2 with the Primary and CAS in a SQL Cluster getting reporting point working?JohnwMillerhttps://www.blogger.com/profile/08039790085311786399noreply@blogger.comtag:blogger.com,1999:blog-4344063455110164362.post-42619627089901854462014-04-01T15:16:16.470+01:002014-04-01T15:16:16.470+01:00Thanks Charles.
Remember you have to add the Repo...Thanks Charles.<br /><br />Remember you have to add the Reporting Point role to the SQL site system (not the Primary Site Server).Gerry Hampsonhttps://www.blogger.com/profile/09914662193585861190noreply@blogger.comtag:blogger.com,1999:blog-4344063455110164362.post-15233018935140261992014-04-01T13:54:29.980+01:002014-04-01T13:54:29.980+01:00Gerry,
I really appreciate your help. May the fr...Gerry,<br /><br />I really appreciate your help. May the fruits of your labor and help come back to you bountifully. The Reporting Services server instance: is not showing my MSSQLServer. Do you know why this is the case; actually it's not giving me any option.<br /><br />Thanks<br />CharlesCharles Shttps://www.blogger.com/profile/08418212292122242941noreply@blogger.comtag:blogger.com,1999:blog-4344063455110164362.post-18295332568155765232013-11-20T05:41:01.449+00:002013-11-20T05:41:01.449+00:00Hmm iѕ anyone elѕ&X65; having problemѕ wit&...Hmm iѕ anyone elѕ&X65; having problemѕ wit&X68; thе <br />images on this blog lo&X61;ding? I'm trying tο determine i&X66; its a problem on &X6d;y end or if it's <br />the blo&X67;. Any response&X73; would be gгeatlу appreciateԁ.<br /><br /><br />Feel free to visi&X74; mу web-site; <a href="http://devin60njbblo.beeplog.com/459665_2524971.htm" rel="nofollow">Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4344063455110164362.post-59790123433851695552013-11-16T19:29:29.093+00:002013-11-16T19:29:29.093+00:00You ought to take part in a contest for one of the...You ought to take part in a contest for one of the most useful ssites <br />online. I am going too highly recommend this website!<br /><br /><br />Feel free to surf to mmy blog ... <a href="http://whorehousehoes.com/view_topic.php?tid=826" rel="nofollow">thrombosed hemorrhoid treatment during pregnancy</a>Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4344063455110164362.post-25427374873872817482013-11-16T03:38:36.918+00:002013-11-16T03:38:36.918+00:00Appreciate this post. Will try it out.
Also visit...Appreciate this post. Will try it out.<br /><br />Also visit my weblog <a href="http://ikraak.com/user.php?login=ausnicole" rel="nofollow">jailbreak ipod 4 6.1.3 evasion</a>Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4344063455110164362.post-31048041515049774772013-11-15T20:58:34.942+00:002013-11-15T20:58:34.942+00:00Wow that was unusual. I jusst wrote an incredibly ...Wow that was unusual. I jusst wrote an incredibly long comment but aafter I clicked submit mmy comment didn't appear.<br /><br />Grrrr... well I'm not writing alll thatt over again.<br />Anyhow,just wanted to say wonderful blog!<br /><br />Also visit my web-site; <a href="http://callgirls.waw.pl/index.php?a=stats&u=joeannflanagan" rel="nofollow">master resale rights selling your Anonymousnoreply@blogger.com