Does SQL Server Managerment Studio 2008 R2 support a connection to a SQL Server 2000 database.

• hmbtx

  SSCarpal Tunnel

  Points: 4664

  More actions

  June 20, 2012 at 8:28 am

  #271512

  I am running SQL Server 2008 R2 on my local SBS 2011 server and I have legacy SQL Server 2000 databases running on a remote server.

  I am currently using Enterprise Manager and Query Analyzer for access to the remote SQL Server 2000 databases.

  My question is does Microsoft support the connection of SSMS 2008 R2 to a SQL Server 2000 database and if so, does anyone know of any problems with doing this?

  Thanks

  Howard

• Jared

  SSC Guru

  Points: 61793

  More actions

  June 20, 2012 at 9:34 am

  #1503544

  Yes you can, and I am not "aware" of any problems.

  Jared
  CE - Microsoft

• hmbtx

  SSCarpal Tunnel

  Points: 4664

  More actions

  June 20, 2012 at 9:50 am

  #1503561

  Jared:

  Thank you for your response to my question.

  Am I correct that in order to access the remote SQL Server 2000 databases I would perform the following steps:

  In SSMS Object Explorer

  File

  Connect Object Explorer

  Enter the appropriate information.

  Howard

• Jared

  SSC Guru

  Points: 61793

  More actions

  June 20, 2012 at 10:59 am

  #1503602

  hmbtx (6/20/2012)

  ---

  Jared:

  Thank you for your response to my question.

  Am I correct that in order to access the remote SQL Server 2000 databases I would perform the following steps:

  In SSMS Object Explorer

  File

  Connect Object Explorer

  Enter the appropriate information.

  Howard

  That's one way. I don't go to file-->connect object explorer. I just click on connect --> database engine in the object explorer window. However, they both do the same thing.

  Jared
  CE - Microsoft

• hmbtx

  SSCarpal Tunnel

  Points: 4664

  More actions

  June 20, 2012 at 12:33 pm

  #1503640

  Jared:

  Thank you for taking the time to help on this.

  Howard