Post reply

Linked Server

  • November 16, 2007 at 12:02 pm

    #118823

    I am trying to connect some of the SQL 2000 server to SQL 2005 through Linked server but I am getting error.

    I have enabled RPC etc, I tried connecting from SQL 2005 to SQL 2000 vice-versa still I am getting error

    Server is not configured for Data Access. (microsoft SQL error , 7411)

    I am also getting this error Server is not configured for Data Access. (microsoft SQL error , 7399)

    Nita

  • November 16, 2007 at 5:10 pm

    #752017

    Refer the below link,

    http://support.microsoft.com/default.aspx/kb/241267

    Regards..Vidhya Sagar
    SQL-Articles

  • November 19, 2007 at 2:18 am

    #752168

    Is remote connection enabled in sql 2005 server?

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • November 20, 2007 at 4:33 am

    #752588

    Which direction are you going? Are you creating 2005 as a linked server on 2000? Or vice versa?

    I don't think the first one will work. I think you have to go from 2005 to 2000 (with 2000 being the linked server) because SQL 2000 won't recognize 2005 as being a database it can link to, but 2005 will recognize 2000.

    Does that make sense?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

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