locked
"No Such Interface Supported" Exception 0x80004002 - HELP! RRS feed

  • Question

  • AAAAARRRRRRRRRRRGGGGGGGGG!

    I finally figure out why I can't connect to the SQLEXPRESS on this computer (technically, I was a remote connection), get everything installed (Advanced edition), and then...

    It keeps telling me that "No Such Interface is Supported" and "Unable to cast COM object of type "System._ComObject" to Interface type..."

    I grabbed it in a screen capture and will try to get it to a server tonight when I get home.

    Any ideas on this problem?

     

    Jason

    Sunday, April 9, 2006 7:19 AM

Answers

  • This error comes from VS. Have you determined if SQL Express is functioning correctly by itself?

    On the computer you are getting this error, try connecting to SQL Express using SQLCmd, open a command prompt and type:

    SQLCmd -S <machinename>\sqlexpress -Q "select @@version"

    If this returns the version of your server, then you know that SQL Express is functioning correctly and that you have it configured to accept the connection if you're trying to access it remotely. Info on configuring remote connections is at:

    914277 How to configure SQL Server 2005 to allow remote connections
    http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

    Regards,

    Mike Wachal
    SQL Express team

    ----
    Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

    Monday, April 10, 2006 11:07 PM

All replies