I am basically facing saperate problems here. Both of the problem shave been triggered by supposedly one event. The computer is on active directory domain and when SQL server was installed on the system, there was a different user using the system. Now that user has been deleted from the domain and a new user is using the system.
Since the new user is created, SQL server started acting crazy. It gives 2 separate kind of errors on 2 separate events.
1. When I try to connect to the local instance, it gives error which says "Login failed for user kde\opusonecorp ( that is my current user on the domain)
2. This may be completely different thing but started showing up since the new user is created. This occurs when i try to connect my local SSMS to a remote instance, it says "Unable to cast COM object of type "system._comobject to interface type "Microsoft.VisualStudio.OLE.interop.Iserviceprovider" call on COM interface failed due to the following error:No such interface supported"
I am not sure whether there is any relationship between these two errors but they started showing up at the same time after en event occured, i just wanted to give you all the pieces of this puzzle.
Is there anything that anyone can suggest?