Hi

I just upgraded my Vista Business to Ultimate and managed to break a working
install of SQL Server 2008 in the process. Now when I open SSMS I get the
error:

Microsoft .NET framework: Unhandled exception has occurred in a component in
your application. If you click continue the application will ignore this
error and attempt to continue. Unable to read the list of previously
registered servers on this system. Re-register your servers in the
'Registered Servers' window.

If I click continue I then get an SSMS window. If I click on the Registered
Servers tab I get another error message:

Unable to read list of previously registered servers on this
system.Re-register your servers in the 'Registered Servers' window.
Additional information: serialization output is invalid
(Microsoft.SqlServer.Management.Sdk.Sfc: None is an invalid XMLNodeType. Line
7, position 9. (System.Xml)

If I then click OK I het a Microsoft .NET Framework message:

Unhandled exception has occurred in a component in your application. If you
click continue the application will ignore this error and attempt to
continue. Serialization output is invalid.

If I click Continue I can then try to register a new server, but when I do
so I get error message:

serialization output is invalid (Microsoft.SqlServer.Management.Sdk.Sfc)
Additional information: Unable to generate a temporary class (result = 1)
error cs2001: Source file 'C:\Windows\Temp\tt3wvw-n.0.cs' could not be found.
error cs2008: no inputs specified
(system.xml)

I have tried repairing the .NET framework 3.5 SP1 and repairing the SQL
Server installation, to no avail.

Does anyone know what the problem is, please?

Thanks in advance for any help.

Regards

TimP

Does this help?

http://support.microsoft.com/kb/955648




On 2/20/09 1:27 PM, in article
01D682F4-7E39-4281-B088-414C44ED2C10...soft (DOT) com, "Tim P"
<TimP (AT) discussions (DOT) microsoft.com> wrote:

Hi Aaron

Thanks for the reply.

Unfortunately there is no node to expand. Left clicking, right clicking,
double clicking does nothing at all. It seems to be this panel which is
broken. There is a row of five icons above the white panel which will do
nothing and nothing at all actually in the panel. Frustratingly, repairing
the sql server installation doesn't help. I suppose I could try completely
removing and reinstalling, but I have a nasty feeling that that isn't going
to do it either.

Regards

Tim

Do you have other SQL Server or Visual Studio tools installed (including SQL
Server Management Studio Express)? How about previous versions? Obviously
the unhandled exceptions are not a good sign, so it may be best to uninstall
the client tools and reinstall them fresh is going to be necessary anyway.
What does Help|About say the version of SSMS is? I'm just curious if you
have 10.0.1622 or possibly an older (pre-release) version.




On 2/20/09 5:44 PM, in article
9B9ADDFF-6806-4FC3-80DD-B22E9C66379C...soft (DOT) com, "Tim P"
<TimP (AT) discussions (DOT) microsoft.com> wrote:

Hi Aaron

I don't have any other version of sql server installed - I removed my old 2k
Developer and 2005 Express before installing 2008. And it was all working
fine before upgrading between Vista versions.

My versions are:

Microsoft SQL Server Management Studio 10.0.1600.22
((SQL_PreRelease).080709-1414 )
Microsoft Analysis Services Client Tools 2007.0100.1600.022
((SQL_PreRelease).080709-1414 )
Microsoft Data Access Components (MDAC) 6.0.6001.18000
(longhorn_rtm.080118-1840)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.6001.18000
Microsoft .NET Framework 2.0.50727.3074
Operating System 6.0.6001

Oddly the .NET framework is showing as v2 although I have 3.5SP1 installed.

The install was done from the release 2008 DVD and I've never had the
pre-release software installed. So it is a bit odd that pre-release versions
are mentioned above.....

In terms of an uninstall, one of the posts I found on another forum from
someone with the same issue was that both reinstalling Windows and removing
and reinstalling sql server didn't fix the problem once it started.
Frustratingly, the poster never posted a solution.

One change I had to make before upgrading windows (Vista Business to
Ultimate) was uninstalling Windows Powershell. Could this have anything to do
with it?

Regards & thanks for your advice.

TP

Another thought - can you remove the client tools whilst leaving the database
engine and all your dbs intact?

Checking into the Powershell issue, it is back installed, presumably done as
part of the repair of sql server I did when the problem first materialised,
so that's not it.

Tim P (TimP (AT) discussions (DOT) microsoft.com) writes:
Yes, maybe that's the way out? Reinstall .Net Fx 3.5 SP1?

Note, this is not suggestion based on knowledge, just idea of something
to try.




--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) 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

Thanks Erland

Unfortunately that doesn't help either - I removed .net 3.5 and reinstalled
it, but still have the problem.

I also tried uninstalling and reinstalling older versions of .net, but no
change.

I've repaired the sql server installation, no change.

I'm all out of ideas.....

Regards

This is actually a bug. I complained about it in these two Connect items
and it should be fixed in the next CU that involves any modifications to
SSMS.

http://connect.microsoft.com/SQL/fee...edbackID=36343
1

http://connect.microsoft.com/SQL/fee...edbackID=36984
5