SQL Server 7 connecting to SQL Server 2000


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: SQL Server 7 connecting to SQL Server 2000

  1. #1
    Mario F. Guest

    SQL Server 7 connecting to SQL Server 2000

    Hello,

    I'm trying to connect to a SQL Server 2000 on another location by means
    of the Enterprise Manager on my location. Basically what I want to do is
    to manage my database on that SQL 2000 server. Problem is, I'm using on
    my side SQL Server 7 and Enterprise Manager can't connect saying that I
    must upgrade my SQL Enterprise Manager and SQL-DMO.

    Is there any way I can manage this connection without the need to
    purchase an upgrade to SQL Server 2000?

    Thanks in advance,
    Mario Figueiredo
    -- co-founder of Quiet Technology, Ltd.
    http://www.quiettech.com
    marfig@quiettech.com

    At last something a little less noisy

  2. #2
    Guest

    Re: SQL Server 7 connecting to SQL Server 2000

    Just install the client tools from SQL 2000, you can connect to both 7 and
    2000 with the newer version.

    As far as I'm aware, the opposite just ain't so...

    Sigh...




    "Mario F." <marfig@i-zoom.net> wrote in message
    news:MPG.157e01c8d2eac4e5989685@news.devx.com...
    > Hello,
    >
    > I'm trying to connect to a SQL Server 2000 on another location by means
    > of the Enterprise Manager on my location. Basically what I want to do is
    > to manage my database on that SQL 2000 server. Problem is, I'm using on
    > my side SQL Server 7 and Enterprise Manager can't connect saying that I
    > must upgrade my SQL Enterprise Manager and SQL-DMO.
    >
    > Is there any way I can manage this connection without the need to
    > purchase an upgrade to SQL Server 2000?
    >
    > Thanks in advance,
    > Mario Figueiredo
    > -- co-founder of Quiet Technology, Ltd.
    > http://www.quiettech.com
    > marfig@quiettech.com
    >
    > At last something a little less noisy




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center