MartyConnelly
martyconnelly at shaw.ca
Mon Jun 5 12:07:37 CDT 2006
Don't know if this fixed in a final released version of SQL 2005 or Express But if you have installed either might be a conflict between SQL-DMO and SQL-SMO. Just a maybe guess .. got this from sqlexpress's WebLog on MSDN http://blogs.msdn.com/sqlexpress This is a cached version as I cant reach it just now FAQ: Installing SQL Express side by side with SQL 2000 Enterprise Manager seems to break it, its still broken when I uninstall express, whats going on? Because of changes in the SQL Server 2005 metadata we have updated SQLDMO, the new version is SQLDMO9, it should work with SQL Server 7/2000 and 2005. For backwards compatibility it is installed by SQL Express so that existing DMO apps should just work. Due to the way that SQLDMO is versioned, only one version can exist on a machine at one time, so when Express is installed the SQLDMO9 version is the one that is registered. Having explained the scenario lets take a look at potential problems: 1/ Looking at permisions of objects in EM does not work. Like the rest of the current version of SQL Express this is a pre-release version, the permissions problem is a bug which we have resolved in the B2 build of SQL Server 2005. If you need to use EM before we update SQLDMO and Express, then go to the version of SQLDMO.dll thats in SQL Server 2000 directory and execute regsvr32 sqldmo.dll. This should enable EM to work as it was before against SQL Server 2000 but neither EM nor DMO will work against SQL Express in this case. 2/ Uninstalling SQL Express breaks DMO and Enterprise Manager When SQL Express installs it registers SQLDMO9 and when it uninstalls, it de-registers it, but if there was a SQLDMO (SQL2000 or SQL7) version on the machine previously this registration is not put back, leaving the machine with no SQLDMO registered. The resolution to this is the same as the above, re-register the right version of SQLDMO. paul.hartland at fsmail.net wrote: >To all, >Have just come to open my Enterprise Manager and I am getting the error as below: >Microsoft SQL-DMO >Error 126: General Error >If you click the ok button Enterprise Manager opens but it's as if all my registration properties have been lost, I tried right clicking on SQL Server Groups and New SQL Server Registration but then get another error message as below: >Server Registration Information Cannot Be Changed On Remote Registeries. >Has anyone else ever had the same problem, if so how do I go about resolving this...I have thought about re-installing my SQL Server on my machine, but thought I would see if I can get away without doing this. >Thanks in advance for any help on this. >Paul Hartland >Database Developer. >_ > > > > -- Marty Connelly Victoria, B.C. Canada