Paul Hartland
Paul.Hartland at orridge.co.uk
Tue Jun 6 02:18:44 CDT 2006
Marty, Thanks but although I have often thought f looking at SQL Express at work I never have done.....I only have the SQL Server 2000 client installed on my machine so I don't think that will be the problem. Not to worry I will uninstall my SQL Client and re-install or try a repair. Thanks anyway.. PAUL HARTLAND Database Designer/Programmer paul.hartland at orridge.co.uk DDI - 01922 472031 Mobile - 07730 523179 -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of MartyConnelly Sent: 05 June 2006 18:08 To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] Enterprise Manager Opening, But No Objects !!!! 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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ * This message is confidential. * This email, its content and any files transmitted with it are intended solely for the addressee and may be legally privileged and/or confidential. * Access by any other party is unauthorised without the express written permission of the sender. * If you have received this email in error you may not copy or use the contents, attachments or information in any way and any review, use, dissemination, forwarding, disclosure, alteration, printing of this information is strictly prohibited. Please destroy it and notify the sender via return e-mail. * This email has been prepared using information believed by Paul Hartland to be reliable and accurate, but the company makes no warranty as to accuracy or completeness. In particular the author does not accept responsibility for changes made to this email after it was sent. * Any opinions expressed in this document are those of the author and do not necessarily reflect the opinions of the company or its affiliates. The Orridge web site can be found at: http://www.orridge.co.uk