SQL Server Performance

Linked MSDE server

Discussion in 'General Developer Questions' started by nilayinc, Aug 22, 2003.

  1. nilayinc New Member

    Hi :

    I have made a remote MSDE server as a linked server on my machine (SQL Server).
    But it fails and am not able to run any queries on the linked MSDE server.
    Any advises ?

    I get the following error whenever I run any query on the MSDE server database:
    SQL Server does not exist or access denied.
  2. gaurav_bindlish New Member

    What is the error that you recive?

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
  3. nilayinc New Member

    I get the following error whenever I run any query on the MSDE server database:
    SQL Server does not exist or access denied
  4. gaurav_bindlish New Member

    Are you able to ping the server?

    How about the login mappings using sp_addlinkedserverlogin. Has this been carred out>

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

Share This Page