MSSQL Server 2008 Express R2 (SP ?)

So I am being asked to support a SQL Server 2008 R2 Express, in looking at the discovery report I believe I am on the core product (10.50.1600.1) and that the previous admin has not applied any of the service packs.  Since the box is seeing a login storm as noted in this tech note - https://connect.microsoft.com/SQLServer/feedback/details/435782/sever-login-failure-storm-for-sql-server-2008-x64-sql-service-account   

I want to update the box.  

SP4 appears to be the current service pack and based on the quote "service packs are cumulative updates" . I plan on just installing SP 4, but wanted to see if anyone had any issues following this approach.  https://support.microsoft.com/en-us/kb/2979596

Thank for any feedback / advice.
LVL 15
PhonebuffAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Alexandre SimõesManager / Technology SpecialistCommented:
I don't want to leave you blank here, and it's been a while since I last updated a sql 2008 but I don't recall having any issues.
0
Deepak ChauhanSQL Server DBACommented:
No such type of issue faced. Anyhow this is common issue when ever you create a login by default Master is the default database unless you have not changed it to another. If the default database is deleted\inaccessible\offline\rename then you will get this type of error.  Whenever you see this error check the login's default databases first.

No relation with service pack 4.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Be careful. SP4 is the last service pack for SQL Server 2008.
For SQL Server 2008 R2, as in the title for this question, the last service pack is SP3 and can be downloaded here.
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Problems using Powershell and Active Directory?

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

Eugene ZCommented:
as per above post
sql 2008r2 the lates sp is sp3
and you must have local admin ans sql sa rights to do this install

How to obtain the latest service pack for SQL Server 2008 R2
https://support.microsoft.com/en-us/kb/2527041

---

about the "https://connect.microsoft.com" post: did you get the same error?
0
PhonebuffAuthor Commented:
:-(

    Now I am stuck as we do not have SA rights to this instance.  Need to contact the vendor who supplied the DB and work through that issue..  Or finish a project I started awhile a while ago to recover the passwords.

    Thank you --
0
Seth SimmonsSr. Systems AdministratorCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.