Upgrade SQL Express 2008 sp2 problem

piaakit
piaakit used Ask the Experts™
on
Dear All


              I was trying to upgrade SQL Express 2008 sp2, but during the installation, I received 2 failed, any idea how to get this fix ?

1
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
lcohanDatabase Analyst

Commented:
Did you clicked on the "Failed" to get more details and did you checked the log file generated? With so little details is really impossible to help in my opinion and the log file should give you the most info about what went wrong.

https://docs.microsoft.com/en-us/sql/database-engine/install-windows/view-and-read-sql-server-setup-log-files?view=sql-server-2017

Author

Commented:
1

C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log   <--- I seeing the log data is in year 2015, is that still useful ?
lcohanDatabase Analyst

Commented:
For the first error it may be that the account used to perform the upgrade does not have sufficient permissions to restart SQL Service and for second is the fact that SQL Express SP can't upgrade the R2 edition.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial