Accessing SQL7 from SQL6.5 Enterprise Manager

Can you register a SQLServer7 database in a SQLServer6.5 Enterprise Manager.
I've added the server but when I select it, an error stating that a connection could not be established is displayed. Is there something that I am missing?
SQLserver7 is clustered but I am trying to connect to the published dbservice so that should not make a difference.

Any help would be greatly appreciated.

Roberto.
roberto_simiAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jon_RaymondCommented:
I hate to use the c word but that can't be done.  However, you can link to 6.5 servers from version 7.  The error you get is valid since 6.5 doesn't recognize an 7 server.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
roberto_simiAuthor Commented:
In that case can I use normal ISQ_l to access the database. This also gives me a similar error message?
0
Jon_RaymondCommented:
I assume not. The 6.5 installation doesn't recognize 7.  You could install 7 on the same system where you have 6.5.  The downside is that you can't run both versions at the same time.  You would have to use the switcher utility to switch between versions.  But, this might be an option.  I have both versions on an NT workstation and I switch between them.  I support a production version in 6.5 which is to be upgraded soon.
0
roberto_simiAuthor Commented:
Very prompt response.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.