64 bit workstation Tools - OK to acces 32 bit SQL 2005?

• rhunt

  SSCertifiable

  Points: 5868

  More actions

  August 31, 2009 at 8:29 am

  #97984

  OK, hate to ask a stupid question...but I figured it was better to ask then to make a stupid mistake. I am pilot testing Windows 7 64 bit in my environment. One of my SQL boxes is a 32 bit version of SQL 2005 - running production work for the RDBMS, SSRS, and SSIS.

  If I install the 64 bit client on my 64 bit workstation, am I going to run into problems changing and developing new solutions for our SQL 2005 32 bit environment?

  Thanks. RH

• Jeffrey Williams

  SSC Guru

  Points: 90304

  More actions

  August 31, 2009 at 2:13 pm

  #1047131

  Nope - no problems. I am currently running Windows 7 x64 - accessing SQL Server 2000/2005/2008 instances running both x64 and x86 with no problems.

  Jeffrey Williams
  “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

  ― Charles R. Swindoll

  How to post questions to get better answers faster
  Managing Transaction Logs