Connect to SQL Server 2014 from SSMS 2008R2

  • Has anyone connected to Server 2014 from SSMS 2008R2? I've seen issues before connecting to Server 2012 but wanted to check if it was possible for 2014?

    Thanks

    Nick

  • SSMS will connect, but you won't get access to the new features and you may get some errors in dialog windows. I suggest that you install SSMS 2014, which works with all previous versions.

    -- Gianluca Sartori

  • Half my team are stuck on windows XP so it's not an option. I'm on Windows 7 so will be planning on installing SSMS 2014.

    Ideally we are looking to upgrade the other members to Windows 7.

    Thanks

  • XP is out of support and a bag of security holes. It's a 14 years old OS. Get out of there as soon as you can.

    -- Gianluca Sartori

  • Tell me about it. I think we're one of the companies paying for extended support.

    There is a large project to move people to Windows 7 but there are so many in-house systems that need to be made compatible.

  • spaghettidba (4/17/2015)


    XP is out of support and a bag of security holes. It's a 14 years old OS. Get out of there as soon as you can.

    +1

  • nick.latocha (4/17/2015)


    Half my team are stuck on windows XP so it's not an option. I'm on Windows 7 so will be planning on installing SSMS 2014.

    Ideally we are looking to upgrade the other members to Windows 7.

    Thanks

    You need to get rid of XP. If management does not want to spend some bucks on that, let them know. Provide the links and the Os requirements. They will eventually do it.

    Having said that, a cheap and ugly workaround, would be setup 2 or 3 machines (could be virtual machines) with Win7 or a recent Windows Os, install Management Studio and let them connect via RDP. I think the Os allow up to two people that way.

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

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