Quick question about sql server and client tools

osaddictosaddict London, UK
edited November 2007 in Internet & Media
I happily use SQL 2005 Client tools to connect to a SQL 2000 server, my colleagues use SQL 2000 Client tools to connect to the SQL 2000 server...

However, we are moving to a new server with 2005 SQL Server installed - I have the 2005 client tools, so no worries there - but will they be able to connect to it with the 2000 client tools, and if so will there be any problems / pitfalls of doing so?

(I did google but not much cropped up - perhaps someone can shed some light?!)

Thanks!

Comments

  • kryystkryyst Ontario, Canada
    edited October 2007
    I don't know if there are any issues. But I'd suggest not messing around and upgrade your colleagues to the 2005 client tools.
  • ThraxThrax 🐌 Austin, TX Icrontian
    edited October 2007
    I would do the same. I don't know how MsSQL works when compared to MySQL, but it seems logical.
  • sharkydartsharkydart KY Icrontian
    edited November 2007
    As far as I know, they will need to install the 2005 tools. And make sure they *get the service pack*, or else bad stuff happens... like failing imports from delimited files ;P

    here ya go:SQLServer2005SP1-KB913090-x86-ENU.exe

    ...and since it's been a month since the last post, hopefully you've done this already
Sign In or Register to comment.