Solved

Issue installing SQL 2005 SP3

Posted on 2011-03-14
6
230 Views
Last Modified: 2012-05-11
We are receiving an error message when installing SP3 on a SQL server 2005 install running on Windows Server 2008 R2 Standard.  The error we receive is attached to this article below.

Any help resolving this issue would be much appreciated, from what I can see it looks like the authentication is failing however I am unsure how to access the instance to resolve this.  We have tried both SQL and Windows authentication with no prevail.

Regards,
Tristan
SQLServerSP3Issue.jpg
0
Comment
Question by:bs_user
  • 3
  • 2
6 Comments
 
LVL 13

Expert Comment

by:geek_vj
ID: 35127137
From the error message, it is clear that there is a problem with installing Reporting services. So, you should be able to access Database services without any issues.
Please try accessing database services from the Management studio and revert in case of any queries.
0
 
LVL 13

Expert Comment

by:geek_vj
ID: 35127145
Also, please check if the services are in started state for SQL Server (MSSQLServer). If not, please start it and try accessing the instance from Management Studio.
0
 
LVL 13

Expert Comment

by:geek_vj
ID: 35127157
For Reporting Services, I could see that it is configured for a different instance. So, I believe you should be able to connect to SQL Server Management Studio for the default instance without any issues. Please check and revert in case of any errors/queries.
0
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 

Author Comment

by:bs_user
ID: 35127193
The problem we are having is we are not able to complete the install of SP3 because of this issue so we need a workaround to complete the install or to resolve the error.

Regards
0
 

Author Comment

by:bs_user
ID: 35127266
To add to my previous post, we dont have any issues with accessing the management studio or databases we are just unable to complete the install of SQL server SP3, I can also add that all the necessary services are running.
0
 
LVL 9

Accepted Solution

by:
kaminda earned 500 total points
ID: 35127475
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I was supporting a handful of Windows 2008 (non-R2) 2 node clusters with shared quorum disks. Some had SQL 2008 installed and some were just a vendor application that we supported. For the purposes of this article it doesn’t really matter which so w…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

832 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