Ask the Community
Groups
A report fails with an error similar to: ...found response content type of ' ', but expected 'text/xml' - Connect IT Community | Kaseya
<main> <article class="userContent"> <p><strong>Question </strong><br></p> <p>A report fails with the following error:</p> <p><img src="/attachments/token/qf5bek3leecjsap/?name=05_01.png" alt="05_01.png" class="embedImage-img importedEmbed-img"></img></p> <p> </p> <p><strong>Answer </strong></p> <p><br>Reports that fail with this error is caused by incorrect permissions in SQL. Please follow the instructions below to correct this issue.<br><br>1. Open up Computer Management and give the ASPNET account membership of SQLReportServerUser (Please Note: If your server is on Windows 2008, please skip this step as you will not have an ASPNET account):</p> <p><img src="/attachments/token/gkhpcz1f8xzqkzy/?name=05_02.png" alt="05_02.png" class="embedImage-img importedEmbed-img"></img></p> <p>2. You will now create a KaseyaReports user account and give it proper permissions:</p> <p><img src="/attachments/token/bxv3ca9qj3itkhv/?name=05_03.png" alt="05_03.png" class="embedImage-img importedEmbed-img"></img></p> <p><img src="/attachments/token/kwlsjym2c3yilge/?name=05_04.png" alt="05_04.png" class="embedImage-img importedEmbed-img"></img></p> <p>3. Open up SQL Management Studio and assign the KaseyaReports account as a Login:</p> <p><img src="/attachments/token/lawenlodvgrfxpg/?name=05_05.png" alt="05_05.png" class="embedImage-img importedEmbed-img"></img></p> <p><img src="/attachments/token/j1fzi0dwi39bho3/?name=05_06.png" alt="05_06.png" class="embedImage-img importedEmbed-img"></img></p> <p> </p> <p>On the following screenshot make sure that you add both of these ReportServer and ReportServerTemp separately not both at once:</p> <p><img src="/attachments/token/3ogaskdorn50kcg/?name=05_07.png" alt="05_07.png" class="embedImage-img importedEmbed-img"></img></p> <p><img src="/attachments/token/y5sz97m4aukmli7/?name=05_08.png" alt="05_08.png" class="embedImage-img importedEmbed-img"></img></p> <p>Then click "OK"<br><br><br></p> <p>4a. If you are using SQL 2008, skip to step 4b.</p> <p> </p> <p>If you are using SQL 2005, do the following:</p> <p>A. Logon to the system hosting SQL Server 2005.</p> <p>B. Open IIS Manager</p> <p>C. Navigate to the Report virtual directory.</p> <p>D. Right-click Home.aspx and select the Browse option.</p> <p><img src="/attachments/token/hzp0ucsc4hbbs0a/?name=05_09.jpg" alt="05_09.jpg" class="embedImage-img importedEmbed-img"></img></p> <p>Skip to step 5.</p> <p> </p> <p>4b. If you are using SQL 2008, please navigate to the following:<br><br>A. Go to the start menu > All Programs > Microsoft SQL server > Configuration Tools > Reporting Services Configuration Manager<br>B. Once the Reporting Services opens up, click on "Report Manager URL" tab on the left hand side menu.<br>C. Click on the "URL":</p> <p><img src="/attachments/token/pvgztcu7mncxiqr/?name=05_10.jpg" alt="05_10.jpg" class="embedImage-img importedEmbed-img"></img></p> <p>Once you click on the URL, it will take you to the Reporting Services web page configurations. Please follow the screenshots below:<br><br></p> <p>5. PLEASE NOTE: If you are on SQL 2008 R2, you will first have to click on "Folder Settings" on the Homepage.</p> <p><img src="/attachments/token/fgbh3gkbgxrqlqj/?name=05_11.jpg" alt="05_11.jpg" class="embedImage-img importedEmbed-img"></img></p> <p><img src="/attachments/token/7s9mboiu1qgpnoo/?name=05_12.jpg" alt="05_12.jpg" class="embedImage-img importedEmbed-img"></img></p> <p><img src="/attachments/token/ujxiddaaxhkydwc/?name=05_13.jpg" alt="05_13.jpg" class="embedImage-img importedEmbed-img"></img></p> <p><img src="/attachments/token/haowjjhmtafoqaq/?name=05_14.jpg" alt="05_14.jpg" class="embedImage-img importedEmbed-img"></img></p> <p>6. Log into your VSA and go into the system tab > Configure page, click on "Change URL". Then click on "Edit" and specify the KaseyaReports account you created:</p> <p><img src="/attachments/token/38e3j011wsjzloe/?name=05_15.jpg" alt="05_15.jpg" class="embedImage-img importedEmbed-img"></img></p> <p><img src="/attachments/token/a0qikdjka9gu9ra/?name=05_16.jpg" alt="05_16.jpg" class="embedImage-img importedEmbed-img"></img></p> <p>Now that you have properly set permissions, you will delete and reload the hotfixes<br><br>7. Open up SQL Management Studio and connect. Expand the "Databases" section and click on the "ksubscribers" database to highlight it</p> <p><img src="/attachments/token/5v3kcqxfqzhhx29/?name=05_17.jpg" alt="05_17.jpg" class="embedImage-img importedEmbed-img"></img></p> <p>8. Click on "New Query" and enter the following query:<br><br>delete from tempdata where tempname = 'vsaPatchUpdate'<br><br>Once you type it in, click on "Execute"</p> <p><img src="/attachments/token/1h7xk6g8axubpxt/?name=05_18.jpg" alt="05_18.jpg" class="embedImage-img importedEmbed-img"></img></p> <p>Once you execute this query, it will have deleted on your hotfixes.<br><br>Now you must re-download and apply your hotfixes by doing the following:<br><br>If your SQL is on the same machine as Kaseya, you can use the following: <a href="/home/leaving?allowTrusted=1&target=http%3A%2F%2Flocalhost%2Fsystemtab%2Fhotfixcheck.asp">http://localhost/systemtab/hotfixcheck.asp</a><br>If your SQL is on a separate machine from Kaseya, you are not able to use localhost and must replace the "localhost" portion of the address above with your external name/IP address of your Kserver, for example: <a href="/home/leaving?allowTrusted=1&target=http%3A%2F%2Fmycompany.com%2Fsystemtab%2Fhotfixcheck.asp">http://mycompany.com/systemtab/hotfixcheck.asp</a><br><br>Once the hotfixes re-download and apply you are able to log into your VSA and run reports successfully.</p> </article> </main>