SSMS - Right Click Server Properties, error

Another WTM moment: Cannot show requested Dialog.


An itch told me to profile and see what going on behind the scenes:

CREATE TABLE #SVer(ID INT, Name SYSNAME, Internal_Value INT, Value NVARCHAR(512))
INSERT #SVer EXEC MASTER.dbo.xp_msver

DECLARE @SmoRoot NVARCHAR(512)
EXEC MASTER.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\Setup', N'SQLPath', @SmoRoot OUTPUT

SELECT
(SELECT Value FROM #SVer WHERE Name = N'ProductName') AS [Product],
SERVERPROPERTY(N'ProductVersion') AS [VersionString],
(
SELECT Value FROM #SVer WHERE Name = N'Language') AS [Language],
(
SELECT Value FROM #SVer WHERE Name = N'Platform') AS [Platform],
CAST(SERVERPROPERTY(N'Edition') AS SYSNAME) AS [Edition],
(
SELECT Internal_Value FROM #SVer WHERE Name = N'ProcessorCount') AS [Processors],
(
SELECT Value FROM #SVer WHERE Name = N'WindowsVersion') AS [OSVersion],
(
SELECT Internal_Value FROM #SVer WHERE Name = N'PhysicalMemory') AS [PhysicalMemory],
CAST(SERVERPROPERTY('IsClustered') AS bit) AS [IsClustered],
@SmoRoot AS [RootDirectory],
CONVERT(SYSNAME, SERVERPROPERTY(N'collation')) AS [Collation]

DROP TABLE #SVer

-----
(0 row(s) affected)
Msg 0, LEVEL 11, State 0, Line 0
A severe error occurred ON the CURRENT command. The results, IF ANY, should be discarded.

Bah, first 2 lines. BUT, thats not all. Hunting and pecking as the norm goes.

Son-Of-Monkeys!!!

DECLARE @SmoRoot NVARCHAR(512)
EXEC MASTER.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\Setup', N'SQLPath', @SmoRoot OUTPUT
SELECT @SmoRoot
-------
c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\

WTM!!!

SQL, I KICK YOUR DOG!!!

I can only surmise that Reporting services lacks the proper resources to execute extended stored procs. And in addition, this may be benign for most, but in my case SQL was not installed in the default location, which would have been in same path, c:\Program Files\Microsoft SQL Server.

No one was using reporting services, so hey, uninstall it. And what do you know. It all works again. Meh, it was a bit of troubleshooting with the registry, prior to pulling the trigger on the uninstall, I change the name of the MSSQL.3\Setup key and renameing to Setupx. Changing that produced the expected query results.

Hope this helps someone other than myself.

~Enjoy

Comments :

0 comments to “SSMS - Right Click Server Properties, error”