the proper type library could not be found in the system registry sql 2008 R2 Management Studio Error

Question

Hi,

I am getting an error when opening the ssms in sql server 2008 R2. Tried all the comments in msdn forums and googled a lot and finally no luck. Some one has to help me out to get this issue fixed.

Installed sql server 2008 r2 sp1 and sp2. Still no luck.

" the proper type library could not be found in the system registry" is the error message.

Thanks
Rahul

Answer 1

Hi Rahul,

Looks like .NET 3.5 libaries are corrupt. I suggest you do the following:

1) Launch Control Panel and then Add Remove Programs.

2) Locate .NET 3.5, choose uninstall and then restart your server

3) After restart, re-install .NET 3.5 or above and then all reinstall all client tools.

4) Restart server and hopefully the problem will disappear.

---

Regards,

Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)

http://basitaalishan.com

Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Answer 2

Hi Basit,

I am using .NET 4. Do I have to uninstall and reinstall that?

Answer 3

Hi Rahulreigns,

Cause: There was a permissions issue in the registry.
Resolution: correcting registry permissions so you could open SSMS. Change the ownership in the parent folder in registry. Give full control to local admin.

Thanks,
Maggie

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

Answer 4

Hi Maggie,

Could you please specify the correct registry i should give permission to. coz, I gave full permission to all the parent folders and still no luck.

If you could give me the correct registry subfolder, it will be much helpful.

Thanks

Rahul

Answer 5

Hi Rahulreigns,

Please launch SQL Server Setup Program to repair the SQL Server 2008 R2 instance.

When you repair an instance of SQL Server:
All missing or corrupt files are replaced.
All missing or corrupt registry keys are replaced.
All missing or invalid configuration values are set to default values

How to repair: http://msdn.microsoft.com/en-us/library/cc646006(v=SQL.105).aspx.

Thanks,
Maggie

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

Answer 6

Still No luck Maggie....

I formated my laptop twice earlier due to the same issue. But this time I dont want to format and I want to fix this permanently. Hope you guys can help me out.

Thanks and Regards

Rahul

Answer 7

Let us know if you see the same issue with SQL 2012. You can download Evaluation edition from here  http://www.microsoft.com/betaexperience/pd/SQL2012EvalCTA/enus/default.aspx

Thanks

Sethu  Srinivasan [MSFT]

SQL Server

Answer 8

Hi Sethu Srinivasan,

I installed sql server 2012 express edition with advance services after uninstalling sql server 2008 R2 and this time another issue popped up. When I click New Query in management studio, it returns an error as shown below :

" Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED)) "

SQL issues are freeking me out. Hope some one can put an end to this. Microsoft guys, you have to seriously look in to this.

Thanks in advance

Rahul

Answer 9

Please report this issue to https://connect.microsoft.com/SQLServer/feedback

Please include the following

1) OS version, Service packs

2) Visual Studio version(s) installed, Service packs installed

4) SQL Server versions installed

5) Any other software, 3rd party tools, virus scanners installed on your machine

6) SQL Server Setup logs ( available at Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log )

If you can attach the process (ssms.exe) to Windows debugger and provide us a full process dump when this error occurred, it would help us understand the problem you are facing

Thanks

Sethu  Srinivasan  [MSFT]

SQL Server

Answer 10

Hi Sethu Srinivasan,

Still no one has responded to my feedback in microsoft connect.

Thanks

Rahul

Answer 11

Hi,

It look like a permission issue, could you try to "run as Administrator" to repaire SQL 2008 R2?

Regards,

James

Answer 12

Hi james,

I did the installation logging in as administrator.

Regards

Rahul