I would like to update my development machine to SQL Server 2012 but I still manage some (very old) SQL Server 2000 machines. Wil my 2012 SSMS be able to connect to those SQL Server 2000 machines?
SQL Server 2008 R2 works fine (what I have now).
Sql-server – connect to a SQL Server 2000 instance from SQL Server Management Studio 2012
sql-server-2000sql-server-2012ssms
Related Question
- Sql-server – Can SQL Server Management Studio Express be installed standalone
- Sql-server – Connection to local SQL Server 2012 can be established from SSMS 2008 but not from SSMS 2012
- SQL Server 2000 – Support from Visual Studio 2013
- SQL Server – Migrating from 2000 to 2012 and Handling Old Versions of Views
- SQL Server 2012 – Cannot Connect from Management Studio
- SQL Server Migration – How to Migrate from 2000 to 2012 Without Intermediate Versions
- SQL Server 2000 – Installation on Windows 10
- Sql-server – How to restore a database from SQL Server 2000 to SQL Server 2012
Best Answer
Yes, I have done it. My website http://www.rocketclubs.com is on SQL server 2000 and I updated it last night in full windows 8, SSMS 2012 setup.