{"id":245,"date":"2007-12-25T00:18:03","date_gmt":"2007-12-24T22:18:03","guid":{"rendered":"http:\/\/contoso.se\/blog\/?p=245"},"modified":"2007-12-25T00:18:03","modified_gmt":"2007-12-24T22:18:03","slug":"ops-mgr-2007-and-win-srv-2008-with-hyper-v","status":"publish","type":"post","link":"http:\/\/contoso.se\/blog\/?p=245","title":{"rendered":"Ops Mgr 2007 and Win Srv 2008 with Hyper-V"},"content":{"rendered":"<p><span lang=\"EN-GB\">I saw an interesting blog <\/span><a href=\"http:\/\/blogs.technet.com\/momteam\/archive\/2007\/12\/17\/steps-to-install-opsmgr-2007-db-and-reporting-on-windows-server-2008-longhorn.aspx\"><span lang=\"EN-GB\"><font color=\"#800080\">post<\/font><\/span><\/a> <span lang=\"EN-GB\">from the Operations Manager product team about Ops Mgr db and reporting running at Windows Server 2008 (Longhorn). Of course I wanted to test that and what is a better occupy on a winter day then try some new technologies.<strong> <\/strong><\/span><\/p>\n<p><span lang=\"EN-GB\" \/><span lang=\"EN-GB\"><\/p>\n<div style=\"text-align: center\"><img decoding=\"async\" title=\"OpsMgr2007 in Hyper-V\" alt=\"OpsMgr2007 in Hyper-V\" src=\"http:\/\/www.contoso.se\/files\/opsmgr_hyperv.jpg\" \/><\/div>\n<p \/><\/span>\u00c2\u00a0<\/p>\n<p><span lang=\"EN-GB\">I already had a Windows Server 2008 RC1 ENT X64\u00c2\u00a0box running so I simple added the Hyper-V role. I\u00c2\u00a0installed a new virtual machines in Hyper-V, a virtual machine running 2008 RC1 ENT X64.\u00c2\u00a0<\/span><span lang=\"EN-GB\">There was no real issue during the setup of Ops Mgr. The blog post from the product team is pretty accurate about the SQL setup.\u00c2\u00a0But I didn\u00e2\u20ac\u2122t do any changes to my applicationHost.config files as the blog post tells you to. I first did, but after a lot of trouble with SQL reporting I\u00c2\u00a0restored my original file and SQL reporting started to\u00c2\u00a0work. I\u00c2\u00a0install all components of Ops Mgr and then\u00c2\u00a0installed SP1 RC too. The only issue was the\u00c2\u00a0AcsConfig.xml permission issue, there is a KB about that problem <\/span><a href=\"http:\/\/support.microsoft.com\/default.aspx\/kb\/936579\"><span lang=\"EN-GB\"><font color=\"#800080\">here<\/font><\/span><\/a><span lang=\"EN-GB\">.<\/span><\/p>\n<p><span lang=\"EN-GB\">After\u00c2\u00a0I had installed Ops Mgr Reporting and also applied SP1 RC\u00c2\u00a0I had to re-run Reporting Services Configuration Manager. I had some problem with the encryption key and also the web service identity. My ReportServer application pool also reconfigured it self during the setup, so I had to reconfigure that\u00c2\u00a0application pool identity\u00c2\u00a0too in the IIS console. <\/span>My Reporting configuration now looks like<span lang=\"EN-GB\"> this<\/span><\/p>\n<p>-Report Server Virtual<span lang=\"EN-GB\"> Directory<\/span><\/p>\n<ul type=\"disc\">\n<li>Name: ReportServer<\/li>\n<li>Website: Default Web Site<\/li>\n<\/ul>\n<p>-Report Manager Virtual Directory<\/p>\n<ul type=\"disc\">\n<li>Name: Reports<\/li>\n<li>Website: Default Web Site<\/li>\n<\/ul>\n<p>-Windows Service Identity<\/p>\n<ul type=\"disc\">\n<li>Service Name: ReportServer<\/li>\n<li>Service Account: NT Authority\\LocalService<\/li>\n<li>Built-in Account: Local Service<\/li>\n<\/ul>\n<p>-Web Service Identity<\/p>\n<ul type=\"disc\">\n<li><span lang=\"EN-GB\">ASP -NET Service Account: NT Authority\\SYSTEM<\/span><\/li>\n<li>Report Server: ReportServer<\/li>\n<li>Report Manager: ReportServer<\/li>\n<\/ul>\n<p>-Database Setup<\/p>\n<ul type=\"disc\">\n<li>Server Name: OpsMgr<\/li>\n<li>Database Name: ReportServer<\/li>\n<li>Credentials Type: Windows Credentials<\/li>\n<li><span lang=\"EN-GB\">Account Name: CORP\\svc_dra (Data Warehouse Read Account)<\/span><\/li>\n<\/ul>\n<p>-Execution Account<\/p>\n<ul type=\"disc\">\n<li>Account: CORP\\svc_dra<\/li>\n<\/ul>\n<p><span lang=\"EN-GB\">Later I\u00c2\u00a0had a problem when running reports, I recived &#8220;Value cannot be null, parameter name: GroupList&#8221;. The problem seems to be with the &#8220;Data Warehouse Main&#8221; data source. You can edit it from <\/span><a href=\"http:\/\/servername\/reports\"><span lang=\"EN-GB\">http:\/\/servername\/reports<\/span><\/a><span lang=\"EN-GB\">. It is in the root and it is hidden, but if you click &#8220;show details&#8221; you will se it. The problem was that the connection string was blank and that the security settings was incorrect.<br \/>\n<\/span><\/p>\n<p>-Connection string<\/p>\n<ul type=\"disc\">\n<li><span lang=\"EN-GB\">data source=servername;initial catalog=OperationsMnaagerDW;Integrated Security=SSPI<br \/>\n<\/span><\/li>\n<\/ul>\n<p>-Connect using<\/p>\n<ul type=\"disc\">\n<li>Credentials are not required<\/li>\n<\/ul>\n<p><span lang=\"EN-GB\">I have seen that issue in news groups before so I am not sure that has to do with Windows Server 2008. I think it is because I reconfigure the application pool and interrupt the encrypted content in SQL Reporting.\u00c2\u00a0<br \/>\n<\/span><span lang=\"EN-GB\">Some word about working with Hyper-V. <\/span><\/p>\n<p><span lang=\"EN-GB\">Last time I tried Microsoft Virtualization was in some early beta of Windows Server 2008. Virtualization was not very fast in that version. But this version is really nice to work with, installing OS don\u00e2\u20ac\u2122t take many minutes, I have tried\u00c2\u00a0Windows Server 2003 and 2008 as guests, both X64.\u00c2\u00a0I recommend you all you try it in your lab.<\/span><\/p>\n<p><span lang=\"EN-GB\">As you all understand this setup of Windows Server 2008 and Ops Mgr 2007 is not supported at all,\u00c2\u00a0so dont try this in your production environment.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I saw an interesting blog post from the Operations Manager product team about Ops Mgr db and reporting running at Windows Server 2008 (Longhorn). Of course I wanted to test that and what is a better occupy on a winter day then try some new technologies. \u00c2\u00a0 I already had a Windows Server 2008 RC1 &hellip; <a href=\"http:\/\/contoso.se\/blog\/?p=245\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[19],"tags":[],"_links":{"self":[{"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts\/245"}],"collection":[{"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=245"}],"version-history":[{"count":0,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts\/245\/revisions"}],"wp:attachment":[{"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=245"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=245"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=245"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}