SQL Server SP

Question

SQL Server SP

river1

SSC-Insane

Points: 24309
More actions
June 26, 2009 at 10:31 am

#131647

Hi masters,
Is the SQL Server 2005 SP3 the latest SP for this engine?
tks,
Pedro

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

SA-1 SSCrazy Eights Points: 8113 More actions · Answer 1

It is the latest SP. However it includes SP2 + 10 CU. There are CU11 and 12 which are not part of SP3. Keep in mind though, you should be applying CU only if necessary.

Adam Bean One Orange Chip Points: 26631 More actions · Answer 2

Adam Bean

One Orange Chip

Points: 26631

June 26, 2009 at 11:01 am

#1016194

SP3 also has up to CU4 now released ...

river1 SSC-Insane Points: 24309 More actions · Answer 3

ok. If i understud there are where released 4 new CUs after SP3 was relesed.

I understud that i only need to install it if necessary, but what is a CU?

thank you

khalle SSC Enthusiast Points: 184 More actions · Answer 4

CU is Cumulative Update package. I've always taken the approach that they should always be installed if the don't cause you any issues, not an only if you need it type thing. Use http://sqlserverpedia.com/wiki/SQL_Server_Release_Date_Calendar to keep up with SP/update releases.

river1 SSC-Insane Points: 24309 More actions · Answer 5

If i have 2 diferente instances (one default instance and one named instance )on the same computer, can i use the same domain account for all the services of this two instances?

thank you,

Pedro

Ewan Hampson SSCrazy Points: 2780 More actions · Answer 6

river (7/1/2009)
can i use the same domain account for all the services of this two instances?

Works for me, though in my case one is 2000 and one is 2005. I can't see any reason why not.

khalle SSC Enthusiast Points: 184 More actions · Answer 7

river (7/1/2009)
If i have 2 diferente instances (one default instance and one named instance )on the same computer, can i use the same domain account for all the services of this two instances?
thank you,
Pedro

You certainly can, but I wouldn't really recommend it. Many of the different services don't really need to use domain accounts, and some need more rights than others. You should try to avoid running a service with an account that can do more than it needs to do. Here is an article about service accounts. Straight from the article:

Security Note Always run SQL Server services by using the lowest possible user rights. Use a specific low-privilege user account or domain account instead of a shared account for SQL Server services. Use separate accounts for different SQL Server services. Do not grant additional permissions to the SQL Server service account or the service groups.

SA-1 SSCrazy Eights Points: 8113 More actions · Answer 8

What ever account type you decide to use, you should configure the services from Configuration Manager. CM grants the account all the necessary permissions on the OS and SQL.

river1 SSC-Insane Points: 24309 More actions · Answer 9

I have configutared using CM. for SQL Server 2005

For SQL Server 2000 i dind't because the services of this named instance are not in the CM

Ewan Hampson SSCrazy Points: 2780 More actions · Answer 10

With 2000 you can do that in the Security tab of SQL Enterprise Manager, though as I recall you can set the accounts per service directly in the computer Services management. This is a bad idea with 2K5.