• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 264
  • Last Modified:

Issue installing SQL 2005 SP3

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
bs_user
Asked:
bs_user
  • 3
  • 2
1 Solution
 
geek_vjCommented:
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
 
geek_vjCommented:
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
 
geek_vjCommented:
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
Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

 
bs_userAuthor Commented:
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
 
bs_userAuthor Commented:
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
 
kamindaCommented:
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now