Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Issue installing SQL 2005 SP3

Posted on 2011-03-14
6
Medium Priority
?
262 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
Does Powershell have you tied up in knots?

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

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
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…
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
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 …

610 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