?
Solved

Issue installing SQL 2005 SP3

Posted on 2011-03-14
6
Medium Priority
?
257 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 

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 2000 total points
ID: 35127475
0

Featured Post

What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

Question has a verified solution.

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

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
A safe way to clean winsxs folder from your windows server 2008 R2 editions
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Suggested Courses

777 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