MS SQL 2005 개체탐색기 오류 > db

[오류내용]

I have just installed the released VS2005 as well as the released SQL2005.  When ever I try to browse my SQL Server with either the Object Explorer in MS SQL Server Management Studio or the Server Explorer in VS2005 I get the following error:

Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.VisualStudio.OLE.Interop.IServiceProvider'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{6D5140C1-7436-11CE-8034-00AA006009FA}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).

[해결방법]

Try re-registering actxprxy.dll (in system32). I had this problem, and the root cause was that the path to this dll in the InProcServer registry key was wrong. I have no idea how it got corrupted, but running regsvr32 on the dll fixed it.

[정리]

위와같은 오류 발생시

실행-> regsvr32 actxprxy.dll

-> 등록완료 메시지 확인 후 MS SQL 2005 다시 실행

[출처]

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=120476&SiteID=1