Installing SQL Server 2005 Service Pack fails due to authentication on install

Posted on 2011-10-19
Last Modified: 2012-08-14
I have a new installation of SQL Server 2005 which installed smoothly. It also installed reporting services but I did not configure this just yet as this is something we plan on using in the future. For some reason, when I install the service pack 1 or 2, it fails to authenticate for the reporting services. The Database services authenticate fine but no matter what login option I use it does not work. I tried creating new logins but it still does not work.
Question by:MSSC_support
    LVL 18

    Accepted Solution

    set up the report service and make sure it is running

    Author Closing Comment


    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    Suggested Solutions

    Scenario:  You do full backups to a internal hard drive in either product (SBS or Server 2008).  All goes well for a very long time.  One day, backups begin to fail with a message that the disk is full.  Your disk contains many, many more backups th…
    The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
    To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
    This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

    746 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

    18 Experts available now in Live!

    Get 1:1 Help Now