Trying to upgrade from mssql 2005 standard to mssql 2008 standard

Posted on 2010-01-05
Last Modified: 2012-05-08
Attached is a picture of four errors I got when trying to upgrade from MSSQL 2005 standard to MSSQL 2008 standard. Any ideas how to fix these?
Question by:TrueBlue
    LVL 29

    Expert Comment

    Go to the IIS websites on the server and make sure anonymous access is NOT enabled for both the reportserver and reports virtual directory.

    Author Comment

    I can not find an anonymous access option under the IIS manager for reporting.
    I am using Windows 7 Pro for the operating system and under administrative tools, I found the IIS which it says is version 6. Any ideas?
    LVL 29

    Accepted Solution

    expand default web site under IIS
    Below here you should see 2 folders reportserver and reports.
    Click on each indivdually and under the security settings ensure that anonymous access is not enabled

    Author Comment

    I do not see an anonymous item to check if it is enabled or not.
    Here is a screen shot of what I see.
    Any ideas?
    LVL 15

    Assisted Solution

    To go to IIS, follow this steps:

    1) Programs >> Administrative Tools >> IIS Manager
    2) Browse to your machine  >> Sites >> Deafult Website (if you set it under default)
    3) Go to Reports folder >> Authentication >> Anonymous Authentication. Check the value, this should be disabled
    4) Go to Report Server >> Authentication >> Anonymous Authentication. Check the value, this should be disabled


    Author Comment


    I looked at both of those folders and the anonymous authentication was already disabled.
    Here is a screen shot of one of them.
    Any other ideas? :)

    Author Comment

    Problem not solved, but awarded points for attempt.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now