Post reply

can we connect to 64-Bit SQL server instance with 32-bit SQL server?

  • October 31, 2012 at 3:12 am

    #283846

    Hi,

    I have installed sql server 2005 standard edition 32-Bit in my XP desktop (VDI).I tried to connect to one of my QA server using sql server authentication mode which is running on SQL Server 2005 Enterprise Edition 64-Bit....but no luck.Getting error 233, stating that sql server version missmatch and access denied or server not available.

    My question is, can we connect to 64-Bit SQL server instance with 32-bit SQL server ? Please let me know...

    Thanks,

    Vamshi..

  • October 31, 2012 at 3:15 am

    #1554513

    Yes you can use the tools of a 32 bit client to talk to a 64 bit server.

    Have you tried to ping the server from your VDI, are the nessesary ports open between your VDI and the server and all other general troubleshooting steps taken?

  • October 31, 2012 at 3:23 am

    #1554515

    Thanks for your reply.It may be some issue with the ports then.I will check with my network team.Thanks again for your reply..

Viewing 3 posts - 1 through 2 (of 2 total)

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