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
http://members.cox.net/pamela444/errorwindow.jpg
Well, it won't let me insert a link, but the photo's at that URL.
|||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
No comments:
Post a Comment