Post reply

SQL Server 2012 remote connectivity issue

  • October 21, 2017 at 7:20 pm

    #324217

    Hi,
    I am able to connect to this SQL 2012 instance on a 64 bit server from a remote client (64 bit server) using the following:
    ODBC 64 bit
    Management Studio 17.x
    But NOT able to connect using the following:
    ODBC 32 bit
    Management Studio 2014
    SQL Server Data Tools' Integration Services connection manager

    Any clue? Thanks.

  • October 23, 2017 at 9:59 am

    #1964820

    "Not able to connect" could be lots of things.   First, what error do you get?   Second, what kind of connection, exactly, are you trying to make?   Please be more detailed and specify what kind of connection we're talking about.   Are you using SSIS ?   SSIS, when run in 64-bit mode, can NOT access 32-bit ODBC drivers, so if you need both, then you'll need separate packages or a custom script.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

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

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