Help! Sql Server 2005 kicked my Sql Server 7s You-Know-What

Life is not good.

So I've got a machine that I do some development work on, nothing
major, but I'd like to keep some things intact. I'm running SQL Server
7, it's an old installation, but it works and I've got a number of
databases on it.

So I see the new 2005 Express downloads and I download the Web
Developer edition, install it, it installs 2005, but my SQL Server 7
installation now seems to be hosed.

The SQL Server Service Manager still shows SQL Server 7 starting and
running, but the Enterprise Manager can no longer connect, it gives a
vague "General Error" message even though the sqlservr.exe process is
still running. It was not able to connect upon installing the other
products.

I've de-installed the new Express stuff and now just have my trusty
VS2003 installation. Everything seems fine except nothing can talk to
the database, which makes sense since the database now doesn't even
show up on the Enterprise Manager. The Application node of the Event
Log shows no errors coming from SQLServer. But when I try to connect
or re-register a database I get: "Server registration information
cannot be changed on remote registries"

Nothing like this has even vaguely happened to me before. Is there
anyone with any constructive advice? I'd be grateful.

Peace,
Greg McClureI suspect this is down to a DMO error, SQL Express installs a new version of
DMO and when it uninstalls DMO is de-registered but it does not put back the
old one.

try the following:

regsvr32 SQLDMO.dll you can find the file in the SQL Server 7 directory.

-Euan

"Greg McClure" <gmcclure@.gmail.com> wrote in message
news:9a4845b3.0407031958.608f2401@.posting.google.c om...
> Life is not good.
> So I've got a machine that I do some development work on, nothing
> major, but I'd like to keep some things intact. I'm running SQL Server
> 7, it's an old installation, but it works and I've got a number of
> databases on it.
> So I see the new 2005 Express downloads and I download the Web
> Developer edition, install it, it installs 2005, but my SQL Server 7
> installation now seems to be hosed.
> The SQL Server Service Manager still shows SQL Server 7 starting and
> running, but the Enterprise Manager can no longer connect, it gives a
> vague "General Error" message even though the sqlservr.exe process is
> still running. It was not able to connect upon installing the other
> products.
> I've de-installed the new Express stuff and now just have my trusty
> VS2003 installation. Everything seems fine except nothing can talk to
> the database, which makes sense since the database now doesn't even
> show up on the Enterprise Manager. The Application node of the Event
> Log shows no errors coming from SQLServer. But when I try to connect
> or re-register a database I get: "Server registration information
> cannot be changed on remote registries"
> Nothing like this has even vaguely happened to me before. Is there
> anyone with any constructive advice? I'd be grateful.
> Peace,
> Greg McClure|||"Euan Garden" <euan_garden@.hotmail.com> wrote in message news:<Z6OFc.22019$Oq2.12415@.attbi_s52>...
> I suspect this is down to a DMO error, SQL Express installs a new version of
> DMO and when it uninstalls DMO is de-registered but it does not put back the
> old one.
> try the following:
> regsvr32 SQLDMO.dll you can find the file in the SQL Server 7 directory.

Yup, this did it, mostly. Thank you, I appreciate your help!
Enterprise Manager still isn't quite behaving the way it used to. It
doesn't show the database "coming on" after a moment and I have to
force it to connect. But it does connect and at least I can access my
databases, so this was a huge help.

I suppose it's likely there are some other DLLs that were unregistered
and that need to be re-registered, so I'll check that possibility out
and perhaps my old functionality will be restored.

Thanks for your guidance.|||Thank you Euan-

I was facing the same symptoms and your fix resolved my problem.

Much appreciated!

-SplitDiff