469,890 Members | 2,158 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,890 developers. It's quick & easy.

Help! Sql Server 2005 kicked my Sql Server 7's 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 McClure
Jul 20 '05 #1
3 1617
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.

-Euan

"Greg McClure" <gm******@gmail.com> wrote in message
news:9a**************************@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

Jul 20 '05 #2
"Euan Garden" <eu*********@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.
Jul 20 '05 #3
Thank you Euan-

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

Much appreciated!

-SplitDiff
Jul 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Sarir Khamsi | last post: by
1 post views Thread by mp | last post: by
1 post views Thread by DBC User | last post: by
2 posts views Thread by JIM.H. | last post: by
1 post views Thread by john | last post: by
5 posts views Thread by Steve | last post: by
3 posts views Thread by lord.zoltar | last post: by
1 post views Thread by Lie Ryan | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.