SQL Server 2008 r2 Management Studio problems -

-

i've been using management studio no problems on current machine 2 years, , migrated windows 10 few weeks back. last week started hanging on open following error: 

microsoft.sqlserver.management.registeredservers.registeredserverexception:  unable read list of registered servers on system.  re-register servers in 'registered servers' window.

after doing research, managed around following advice found in this post, object explorer refuses expand. program acts world if not responding, i'll following error:

value cannot null. parameter name: viewinfo (microsoft.sqlserver.management.sqlstudio.explorer)

after that, can open new query window , responds, cannot use object explorer. i've looked @ this thread, doesn't seem solve me.

is there any chance don't have reinstall ssms?

update: attempted reinstall, failed error "the specified account exists".

i received same error message did, yesterday, sept. 30, 2015, when tried opening trusty sql server 2008 r2 management studio.

after researching , trying same things mentioned, no avail, try re-installing ssms (which makes me shudder thinking it).

i know had made no system changes recently, perhaps microsoft had changed system recently? because restore point made automatically windows 7 whenever system change made, naturally makes 1 whenever microsoft performs critical update. below can seen change made system microsoft:

enter image description here

and there, above, see windows update done 9/29/2015, day before troubles began. , had not used ssms until 9/30/2015, , that's when got error message describe. circumstantial evidence, if will.

i learned hard way 5 years ago re-installing sql server 2008/2008 r2 fraught great pitfalls , risk everywhere turn.

so i've seen coincidence of windows update, i've decided wait few more days see if microsoft come out fix, or perhaps thread receive increased attention.

steps see view restore points:

  1. control panel\all control panel items\system

  2. then in left panel choose system protection.

  3. click button system restore...

  4. click button next

also 1 more clue following link, says such error message can occur when user profile become corrupted: http://www.sqlserverf1.com/tag/microsoft-net-framework-error-unable-to-read-the-list-of-previously-registered-servers-on-this-system/


Comments

Post a Comment

Popular posts from this blog

java - Date formats difference between yyyy-MM-dd'T'HH:mm:ss and yyyy-MM-dd'T'HH:mm:ssXXX -

-
i trying parse date 2014-12-03t10:05:59.5646+08:00 using these 2 formats: yyyy-mm-dd't'hh:mm:ss yyyy-mm-dd't'hh:mm:ssxxx when parse using yyyy-mm-dd't'hh:mm:ss works fine, when parse yyyy-mm-dd't'hh:mm:ssxxx parseexception thrown. which correct format parse date , difference between these 2 formats? note : cannot use joda :( those valid formats: yyyy-mm-dd't'hh:mm:ss.sssz >>> e.g.: 2001-07-04t12:08:56.235-0700 yyyy-mm-dd't'hh:mm:ss.sssxxx >>> e.g.: 2001-07-04t12:08:56.235-07:00 edit: btw, "x" refer (iso 8601 time zone)
Read more

c# - Get rid of xmlns attribute when adding node to existing xml -

-
i have xml-file: <ns2:root xmlns:ns2="namespace"> <ns2:a> <ns2:b>some content</b> <ns2:c>some content</c> <ns2:d>some content</d> </a> </root> i need add new node in specific place, code is: var doc = xdocument.load(file); xnamespace ns2 = "namespace"; doc.element(ns2 + "root").element(ns2 + "a").element(ns2 + "c").addafterself( new xelement(ns2+"new", new xelement("new1", new xelement("new2","some content"), new xelement("new3", "some content")))); the output is: <ns2:root xmlns:ns2="namespace"> <ns2:a> <ns2:b>some content</b> <ns2:c>some content</c> <ns2:new> <new1 xmlns=""> <new2>some content</new2> ...
Read more