SQLMS 32bit to admin SQL2K8R2 x64?

Question

Post reply

SQLMS 32bit to admin SQL2K8R2 x64?

kkanaya

SSCommitted

Points: 1615
More actions
November 14, 2012 at 7:08 am

#265419

Hello,
Can anyone tell me if I could use SQL 2008 Management Studio (32 bit) to administor a SQL 2008 R2 x64? What would not work due to the above?
Any help will be highly appreciated.
Kailash.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 1

None, it's just a client tool.

I connect with my 32-bit SSMS (still on Windows XP) to 64-bit servers all the time without issues.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

Well, there isn't a 64-bit version of SSMS... It's only the server components that are 64 bit (and drivers), not the client tools.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

kkanaya SSCommitted Points: 1615 More actions · Answer 3

Thank you Koen Verbeeck!! I will proceed with the install.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 4

Should work with no problems. That was the setup I used at a previous employer, desktop system was 32-bit and servers were 64-bit.

kkanaya SSCommitted Points: 1615 More actions · Answer 5

Thank you GilaMonster and Lynn Pettis for your advice.

Your advice and help is highly appreciated.

Regards,

Kailash.