Post reply

Connectivity from SQL Server 2000 to SQL Server 2008

  • July 9, 2010 at 5:46 am

    #221070

    Hi All,

    i am trying to connect to SQL Server 2008 Database through a DTS Package but i am facing troubles while creating the DTS packages with connection string pointing to SQL Server 2008.

    Please let know is this Possible if yes (hope fully) please suggest me how i can proceed.

    Thanks and Regards,

    Raja

  • July 9, 2010 at 5:53 am

    #1190718

    As far as I know there's no particular issue on this kind of connection.

    SQL Server 2008 can be set up as an OLEDB source in your DTS package.

    What error are you getting?

    -- Gianluca Sartori

  • July 9, 2010 at 5:59 am

    #1190723

    Hi,

    Thanks for the reply.

    i am getting the following error.

    ERROR Source : Microsoft OLEDB Provide for SQL Server

    ERROR Description : [DBNETLIB][ConnectionOpen(Connect();]SQL Server does not exist or access denied.

    with same package when try to connect another remote server (sql server 2000) i was able to connect.

    Regards,

    Raja

  • July 9, 2010 at 6:08 am

    #1190729

    Can you connect from the DTS host to the SQL2008 server using SSMS or OSQL?

    -- Gianluca Sartori

  • July 9, 2010 at 6:11 am

    #1190730

    I am facing the same problem with OSQL Command

  • July 9, 2010 at 6:24 am

    #1190745

    It's a connectivity issue then.

    Check you network and firewall settings.

    -- Gianluca Sartori

  • July 9, 2010 at 8:43 am

    #1190835

    Also verify that the 2008 instance is set to receive remote connections on the protocol you are using (pipes vs. TCP/IP only). This can be turned off and you won't be able to connect no matter what.

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

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