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

Question

Post reply

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

Adam Bean

One Orange Chip

Points: 26631
More actions
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

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

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

Nicholas Cain SSC-Dedicated Points: 33009 More actions · Answer 1

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

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

Adam Bean One Orange Chip Points: 26631 More actions · Answer 2

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?

Nicholas Cain SSC-Dedicated Points: 33009 More actions · Answer 3

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

Adam Bean One Orange Chip Points: 26631 More actions · Answer 4

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

Nicholas Cain SSC-Dedicated Points: 33009 More actions · Answer 5

sweet

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

tyler.clark SSC Journeyman Points: 85 More actions · Answer 6

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

Adam Bean One Orange Chip Points: 26631 More actions · Answer 7

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).

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

Cookies on SQLServerCentral