Recently I got a mail for following problem
While the client tries to open registered server window in Mbanagement Studio
he gets following error
so he could not use registered servers windows and it really annoys him :-(.
This is because the file which stores registered servers might be corrupt.
So first close Management Studio
So go to C:\Documents and Settings\\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell
and rename regsvr.xml to some other name for ex. regsvr_old.xml
Now open Management studio , it will create new regsvr.xml and we can use registered window without any problem :-)
While the client tries to open registered server window in Mbanagement Studio
he gets following error
so he could not use registered servers windows and it really annoys him :-(.
This is because the file which stores registered servers might be corrupt.
So first close Management Studio
So go to C:\Documents and Settings\
and rename regsvr.xml to some other name for ex. regsvr_old.xml
Now open Management studio , it will create new regsvr.xml and we can use registered window without any problem :-)
14 comments:
Nice one, this is really which I am finding.
Thank you.
I experience this every few months. The error is slightly different but also affects registered server list. I have historically uninstalled and re-installed to fix this error.
This just saved me a few hrs.
Thanks.
p.s. for Server2008/Win7 the path is:
C:\Users\\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell
Thanks... Resolved my problem!
Bang! You hit the nail on the head!
Had this problem after a power fail. I do wish this link had the actual error message in its title, though. I searched countless links with that string to no avail. Finally, searched for just RegSvr.xml and got here.
Thank you so much for sharing!
thank you!
Your method didn't work but I copied RegSvr.xml from good working computer and it did the trick. I noticed it had a lot more enries than auto-created one
thank you!!!, this the path for
windows 7
C:\Users\YourName\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell
thank you!
This method didn't work but I opened and closed SQL Server Configuration Manager.
I tried this method as well and also tried to rename the Microsoft SQL Server Folder to Microsoft SQL Server_Old and this did not worked.
Finally, I found that the issue was taken care by disabling the Antivirus. The antivirus was blocking some of the dll files that ssms.exe was trying to access. Hence, even for the registered servers the issue was there. every time the error was different:-
Different error was reported in the same procedure as follows:-
===============================
TITLE: Registered Servers
------------------------------
Unable to read the list of previously registered servers on this system. Re-register your servers in the 'Registered Servers' window.
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1540+)&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
Deserialization operation on /RegisteredServersStore/ServerGroup/AnalysisServicesServerGroup has failed. (Microsoft.SqlServer.Management.Sdk.Sfc)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1540+)&LinkId=20476
------------------------------
Unable to generate a temporary class (result=1).
error CS1567: Error generating Win32 resource: The process cannot access the file because it is being used by another process.
(System.Xml)
------------------------------
BUTTONS:
OK
------------------------------
============================================
And sometimes it is as below:-
============================================
TITLE: Registered Servers
------------------------------
Unable to read the list of previously registered servers on this system. Re-register your servers in the 'Registered Servers' window.
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1540+)&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
Deserialization operation on /RegisteredServersStore/ServerGroup/AnalysisServicesServerGroup has failed. (Microsoft.SqlServer.Management.Sdk.Sfc)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1540+)&LinkId=20476
------------------------------
Unable to generate a temporary class (result=1).
error CS1567: Error generating Win32 resource: The process cannot access the file because it is being used by another process.
(System.Xml)
------------------------------
BUTTONS:
OK
------------------------------
============================================
Hi. I'm using SQL Server 2012 and SSMS. Whenever I click on registered servers nothing happens. Please help. Thanks
Helpful post for every job seekers like any latest job openings on
php openings in hyderabad
thank you very much
"Unable to generate a temporary class (result=1). Error CS1567: Error generating win32 resource: The process cannot access the file because it is being used by another process. Error code 0x84B10001"
Post a Comment