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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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?
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?
ASKER
:-(
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 --
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 --
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
No relation with service pack 4.