Post reply

ActiveX component can't create object: "SQLDMO.SQLServer"

  • December 15, 2008 at 9:05 am

    #126534

    Hey all,

    I've been running an older VBScript using DMO to do some database auditing in my environment as of a few weeks ago appears that it stopped working. Went to run it now and receiving the error "ActiveX component can't create object: "SQLDMO.SQLServer". I'm a bit baffled as this process has been running for about 8 months without issue. I do not see any windows updates applied around the time in which my process broke. I have not installed any recent SQL Cumulative Updates either.

    The process is running on a Windows 2003 Server with SQL2005. I attempted to install the Microsoft SQL Server 2005 Backward Compatibility Components and was told that a higher version already exists.

    Any thoughts on my next route?

    Thanks

  • December 15, 2008 at 9:42 am

    #912584

    Has one of the servers that you are monitoring been upgraded at all?


    Shamless self promotion - read my blog http://sirsql.net

  • December 15, 2008 at 10:17 am

    #912629

    Nicholas Cain (12/15/2008)

    Has one of the servers that you are monitoring been upgraded at all?

    The problem isn't on the destination server(s), it's on the source server running my script. Yet I did just notice that I was running on 9.00.3054.00 up until last month and now I'm on 9.00.3073.00. So it would appear that someone applied a CU that I was unaware of. Anyone have that link handy that shows the breakdown of version to release?

    So with that said, how can I resolve this matter? Should I uninstall my current backwards compatibility and apply the one from Microsoft?

  • December 15, 2008 at 10:20 am

    #912636

    Steve Jones put together this awesome list of SQL Server version numbers and what they relate to, something I keep as a favourite, and refer back to pretty frequently.

    http://www.sqlservercentral.com/articles/Administration/2960/[/url]


    Shamless self promotion - read my blog http://sirsql.net

  • December 15, 2008 at 11:46 am

    #912692

    Well, I did a repair on the Backwards Compatibility ... and it appears I'm working now.

  • December 15, 2008 at 11:55 am

    #912697

    sweet


    Shamless self promotion - read my blog http://sirsql.net

  • December 31, 2008 at 10:35 am

    #919751

    What do you mean a repair on backwards compatibility? My server stopped working and I need to get it up and running ASAP!

  • December 31, 2008 at 11:21 am

    #919775

    tyler.clark (12/31/2008)

    What do you mean a repair on backwards compatibility? My server stopped working and I need to get it up and running ASAP!

    Explain "server not working". All I did was do a repair on the installation of the backward compatibility install (in add/remove programs).

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply