Ask the Community
Groups
Installing Microsoft reporting service SSRS on existing VSA server OR InteropServices.COMException (0x8007052E):Logon failure Error - Connect IT Community | Kaseya
<main> <article class="userContent"> <h2 data-id="problem"><strong>Problem: </strong></h2> <p>SSRS is configured when kinstaller.exe installs the VSA. You will need to manually configure Microsoft Reporting Service (SSRS) when installing on an existing VSA server.</p> <p> When switching to SSRS from Kaseya reporting service you receive this error;</p> <p><strong>InteropServices.COMException (0x8007052E):Logon failure</strong></p> <p>You need to correctly configure the reporting service database.</p> <h2 data-id="resolution"> <strong>Resolution:</strong> </h2> <p>Follow these steps to install and configure Microsoft reporting services after the VSA has been installed.</p> <p>1. Follow the instructions on this article to install the service and configure it.</p> <p><a rel="nofollow" href="/home/leaving?allowTrusted=1&target=https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Freporting-services%2Finstall-windows%2Finstall-reporting-services%3Fview%3Dsql-server-ver15">https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/install-reporting-services?view=sql-server-ver15</a></p> <p id="ways-to-create-the-report-server-database"><strong>After install use the wizard to create the report server database</strong></p> <h3 id="native-mode" data-id="native-mode">Native mode</h3> <ul><li> <p><strong>Automatic</strong>. Use the SQL Server setup wizard if you choose the default configuration option for installation. In the SQL Server Installation Wizard, this option is <strong>Install and configure</strong> on the <strong>Report Server Installation Options</strong> page. If you choose the <strong>Install only</strong> option, you must use SQL Server Reporting Services Configuration Manager to create the database.</p> </li> </ul><p>2. You will create a "KaseyaReports" user account and give it proper permissions:</p> <p><img src="https://us.v-cdn.net/6032361/uploads/migrated/CYAQ9B4FNQ08/mceclip0.png" alt="mceclip0.png" class="embedImage-img importedEmbed-img"></img></p> <p><strong>Note: </strong>If you currently use SQL Server 2008 R2 or earlier you need to add the "SQLServer2005SQLBrowserUser as "Member Of" for the "KaseyaReports" account as this does not apply for SQL Server 2012 and later.</p> <p><img src="https://us.v-cdn.net/6032361/uploads/migrated/ET875ER2KQVW/mceclip1.png" alt="mceclip1.png" class="embedImage-img importedEmbed-img"></img></p> <p> </p> <p>3. Go to the Start menu > All Programs > Microsoft SQL Server > Configuration Tools > Reporting Services Configuration Manager</p> <ul><li>Once the Reporting Services opens up, Click on Database and confirm the ReportServer Database is created.<img src="https://us.v-cdn.net/6032361/uploads/migrated/DX1XOQWV5J4R/mceclip2.png" alt="mceclip2.png" class="embedImage-img importedEmbed-img"></img></li> <li>Next Click on Web Service URL and set the TCP port to 18086.<img src="https://us.v-cdn.net/6032361/uploads/migrated/ISJX36EABBR5/mceclip3.png" alt="mceclip3.png" class="embedImage-img importedEmbed-img"></img></li> <li>Next click on "Web Portal URL" tab on the left hand side menu, then click Advanced. Set all assigned IP addresses to port 18086.<img src="https://us.v-cdn.net/6032361/uploads/migrated/27SSGLC5JH5M/mceclip4.png" alt="mceclip4.png" class="embedImage-img importedEmbed-img"></img></li> <li>Next Click on the "URLs": it will take you to the Reporting Services web page configurations. Login and Please follow the screenshots below:</li> </ul><p>4. Select Manage Folder from the Home screen.</p> <p><img src="https://us.v-cdn.net/6032361/uploads/migrated/G2TOUXEUCTXB/mceclip7.png" alt="mceclip7.png" class="embedImage-img importedEmbed-img"></img></p> <p>Under Home >Manage >Security Add KaseyaReport as Browser role.</p> <p><img src="https://us.v-cdn.net/6032361/uploads/migrated/63QDUC26XEMG/mceclip8.png" alt="mceclip8.png" class="embedImage-img importedEmbed-img"></img></p> <p>5. Select Settings Gear and Then Site settings.</p> <p><img src="https://us.v-cdn.net/6032361/uploads/migrated/N23M2NEIS4IP/mceclip5.png" alt="mceclip5.png" class="embedImage-img importedEmbed-img"></img></p> <p> Select Security and "+Add group or user" then add the "KaseyaReport" user as a System User.</p> <p><img src="https://us.v-cdn.net/6032361/uploads/migrated/OX5RGH5PB6QV/mceclip6.png" alt="mceclip6.png" class="embedImage-img importedEmbed-img"></img></p> <div> <strong>5.</strong> Log into your VSA and go into the <strong>System module > Configure page</strong>, click on <strong>Change URL</strong>. Then click on <strong>Edit</strong> and specify the "KaseyaReports" account you created:<br><br><br><img src="https://us.v-cdn.net/6032361/uploads/migrated/PSOJYFYG3AOC/mceclip2.png" alt="mceclip2.png" class="embedImage-img importedEmbed-img"></img></div> <div> </div> <div> </div> <div> </div> <div> <br><img src="https://us.v-cdn.net/6032361/uploads/migrated/80IP9ZGEJFI6/mceclip3.png" alt="mceclip3.png" class="embedImage-img importedEmbed-img"></img></div> <div>Save settings and then test the connection.</div> <div><img src="https://us.v-cdn.net/6032361/uploads/migrated/6MXM12VXKAW9/mceclip9.png" alt="mceclip9.png" class="embedImage-img importedEmbed-img"></img></div> <div><img src="https://us.v-cdn.net/6032361/uploads/migrated/8T9AJJ4P2Y68/mceclip10.png" alt="mceclip10.png" class="embedImage-img importedEmbed-img"></img></div> <div> </div> <div> <strong>Applies to</strong>: VSA 9.4, 9.5.</div> </article> </main>