Re: Services not listed on Configuration Manager screen?
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Wed, 24 Sep 2008 21:56:32 +0000 (UTC)
aj (ronald@xxxxxxxxxxxxx) writes:
Here's the @@version output:
Microsoft SQL Server 2005 - 9.00.3050.00 (X64) Mar 2 2007 22:06:10
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit)
on Windows NT 5.2 (Build 3790: Service Pack 2)
3050? That's a very odd version!
I don't remember under which build number SP2 was originally released as,
but the one you can download now is 3042. Shortly after the release of
SP2 yet a serious bug with maintenance plans were uncovered, and they
released a so called GDR with build number 3054.
Thus, most people running SQL 2005 SP2 runs 3042 or 3054. Or they run
one the nine Cumultative Updates that have been released. The CU:s are
not downloadable; you have to register for them, and then they will
send it to you. As the KB articles for the CUs includes the general
caveat that they are only intended to fix a particular problem, I cannot
really recommend that you try one of them.
Instead I would suggest that you install build 3073, which includes two
security fixes, of which one appears to relatively critical. You can
find information on http://support.microsoft.com/kb/954606, and from
there you should be able to find a download.
I don't know if your odd build number is related to your problems with
the Config Manager and funny things you see in SSMS, but since you ought to
install that security fix anyway, I think it's worth to see id it helps.
Oh, also check the version of the tools, so that you don't happen to
run the RTM or SP1 version of them.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Services not listed on Configuration Manager screen?
- From: aj
- Re: Services not listed on Configuration Manager screen?
- From: Erland Sommarskog
- Re: Services not listed on Configuration Manager screen?
- From: aj
- Services not listed on Configuration Manager screen?
- Prev by Date: Re: Interview type Question
- Next by Date: Re: How do i write Set based queries and avoid a cursor?
- Previous by thread: Re: Services not listed on Configuration Manager screen?
- Next by thread: How often would this call my UDF?
- Index(es):
Relevant Pages
|
