• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 939
  • Last Modified:

Is Windows 7 x64 SQL Client compatible with SQL Server 2005 32-bit?

We have SQL Server 2005 32-bit and want to allow access by a 64-bit Windows 7 client. Can this be done by just purchasing/installing a SQL Client 64-bit package on the new client?
0
edison04
Asked:
edison04
  • 5
  • 4
1 Solution
 
princeatapiCommented:
Yes it will
please find the general information
http://www.microsoft.com/sqlserver/2005/en/us/64-bit.aspx
0
 
edison04Author Commented:
My concern is whether a 64-bit client can successully access a 32-bit SQL Server.
0
 
princeatapiCommented:
Recently i tested my application moving to IIS7 (64bit) and Sql Server2008 but i ve located my database in a different server which is SqlServer 2005 32bit i have no issues in connecting with the DB
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
edison04Author Commented:
Do you know if I have to buy a separate software package to get the x64 SQL client?
0
 
princeatapiCommented:
I don't think so all the essential Components comes along with the Package , even you can avail for free from Microsoft web site
0
 
edison04Author Commented:
I will keep looking for a download
0
 
princeatapiCommented:
You can get express editions keep going ..
0
 
edison04Author Commented:
Yes, thank you. That's what I had to do. Plus I had to go here:

http://www.sqlservercurry.com/2008/05/install-sql-server-express-64-bit-on-64.html

and uninstall Sql Native Client and install these 2 things.
0
 
edison04Author Commented:
I did get the answer that I needed, but only part of the "how," which I had to find myself. It was good to know it could be done and to use SQL Express, that is why I am still giving all 500 points. Without that info, I would not have known what to look for. Thanks.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now