Solved

Issue installing SQL 2005 SP3

Posted on 2011-03-14
6
213 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
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 

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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Server 2008 Cluster Fail-over Errors 5 49
Raid problem 10 35
granting Active Directory permissions 18 58
Query 14 0
If you migrate a Terminal Server licenses server inside the 2008 server family, you can takte advantage of the build-in migration tool. If you like to migrate an older 2003 Server (and the installed client CALs) to a 2008 R2 server for example, you …
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
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…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

760 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

20 Experts available now in Live!

Get 1:1 Help Now