<div>
<div class="content wysiwyg-content">
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. 
</div>
</div>


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. 

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

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.

Windows Server 2008

Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).

Windows Server 2003

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.