SQL Server 205 SP2 64-bit, Windows Server 2003 R2 64-bit

I have SQLS happily running, but when I run Configuration
Manager (I need to change MSSQLSERVER startup param properties),
the only entry I see is Integration services - nothing else.
This happens even with a local administrator login.

In Control-Panel, Services, MSSQLSERVER and other SQLS services are
definitely running and the "Log On As" is set to Local System.

I have another (test) server, and Config Mgr there shows FullText,
Analysis, Reporting Services, Browser, etc...

Any help appreciated.

TIA

aj

aj (ronald@mcdonalds.com) writes:

SQL Server 205 SP2 64-bit, Windows Server 2003 R2 64-bit
>
I have SQLS happily running, but when I run Configuration
Manager (I need to change MSSQLSERVER startup param properties),
the only entry I see is Integration services - nothing else.
This happens even with a local administrator login.
>
In Control-Panel, Services, MSSQLSERVER and other SQLS services are
definitely running and the "Log On As" is set to Local System.
>
I have another (test) server, and Config Mgr there shows FullText,
Analysis, Reporting Services, Browser, etc...

I have no idea what might be going on, but can you connect to the instance
and run SELECT @@version and post the output?


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Erland Sommarskog wrote:

aj (ronald@mcdonalds.com) writes:

>
I have no idea what might be going on, but can you connect to the instance
and run SELECT @@version and post the output?

Thanks for the help, Erlang. Yes, absolutely.

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)

As I said, its acting just fine as far as using the engine.

Other symptoms noted since OP:
-When I run SSMS on the server, and try to save a maintenance plan, I
get a dialog saying "Library Not Registered"

-SAC->Services and Connections gives dialog:
"Specified argument was out of the range of valid values.
Parameter name: index (System.Windows.Forms)"

-SAC->Features gives dialog:
"To configure the surface area, one or more services for the Database
Engine or Analysis Services or Reporting Services must be running. (SQLSAC)"

The issue is not the engine itself, but the admin tools around the
engine...

<scratching head>................????

AJ

Erland Sommarskog wrote:

aj (ronald@mcdonalds.com) writes:

>
I have no idea what might be going on, but can you connect to the instance
and run SELECT @@version and post the output?

Thanks for the help, Erlang. Yes, absolutely.

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)

As I said, its acting just fine as far as using the engine.

Other symptoms noted since OP:
-When I run SSMS on the server, and try to save a maintenance plan, I
get a dialog saying "Library Not Registered"

-SAC->Services and Connections gives dialog:
"Specified argument was out of the range of valid values.
Parameter name: index (System.Windows.Forms)"

-SAC->Features gives dialog:
"To configure the surface area, one or more services for the Database
Engine or Analysis Services or Reporting Services must be running. (SQLSAC)"

The issue is not the engine itself, but the admin tools around the
engine...

<scratching head>................????

AJ

aj (ronald@mcdonalds.com) 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@sommarskog.se

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/prodinf...ons/books.mspx