Monday, February 20, 2012

Old Sql Server

Dear folks,
I can’t work out with that. I’m trying to add into my Enterprise Manager
(Sql2k) a sql Server 6.5 but appears this error:
Sql Server Registration failed because of the connection failure displayed
below: Do you wish to Register anyway?
[SQL- DMO] Sql Server SRVSMS2 must be upgraded to version 7.0 or later to be
administered by this version of sql-dmo
Any thought/solution in order to avoid upgrade that SQL to 7.0? I’ve been
tried it from Sql Server 7.0 and I obtain the same result.
Thanks in advance and regards,No. EM 7.0 can only connect to 7.0. EM 2000 can only connect to 2000 and 7.0
. None of those EM can
connect to 6.5.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:F7ABFAB7-81BB-49C0-9ECC-50585C4B048B@.microsoft.com...
> Dear folks,
> I can't work out with that. I'm trying to add into my Enterprise Manager
> (Sql2k) a sql Server 6.5 but appears this error:
> Sql Server Registration failed because of the connection failure displayed
> below: Do you wish to Register anyway?
> [SQL- DMO] Sql Server SRVSMS2 must be upgraded to version 7.0 or later to
be
> administered by this version of sql-dmo
> Any thought/solution in order to avoid upgrade that SQL to 7.0? I've been
> tried it from Sql Server 7.0 and I obtain the same result.
> Thanks in advance and regards,
>|||you are talking about I use ODBC or import data from Sql Server 6.5 to Acces
s
and from there to the recent versions?
Thanks for your input
"Tibor Karaszi" wrote:

> No. EM 7.0 can only connect to 7.0. EM 2000 can only connect to 2000 and 7
.0. None of those EM can
> connect to 6.5.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Enric" <Enric@.discussions.microsoft.com> wrote in message
> news:F7ABFAB7-81BB-49C0-9ECC-50585C4B048B@.microsoft.com...
>
>|||I'm sorry but I don't understand your question. I simply replied saying that
the Enterprise Manager
that comes with 7.0 or 2000 cannot connect to a 6.5 server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:B1D2C92D-7479-41B0-B07A-073A78D01DBB@.microsoft.com...
> you are talking about I use ODBC or import data from Sql Server 6.5 to Acc
ess
> and from there to the recent versions?
> Thanks for your input
> "Tibor Karaszi" wrote:
>|||don't worry it's my fault. I've formulated a new question
"Tibor Karaszi" wrote:

> I'm sorry but I don't understand your question. I simply replied saying th
at the Enterprise Manager
> that comes with 7.0 or 2000 cannot connect to a 6.5 server.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Enric" <Enric@.discussions.microsoft.com> wrote in message
> news:B1D2C92D-7479-41B0-B07A-073A78D01DBB@.microsoft.com...
>
>

No comments:

Post a Comment