Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2015
    Posts
    1

    Unanswered: Could not find server in sys.servers

    Hi
    I am trying to move a database/app from one sql2005 server to another sql 2005.

    Part of the app contains a function that executes an sql statement on the remote server.

    The error message I receive is Could not find server STORE4 in sys.servers. Verify that the correct server name was specified.

    The remote server is called STORE4 and the sql statement is
    SELECT SiteID,SiteName,Latitude,Longitude,CoordinateSourc eType FROM STORE4.SitesDB.dbo.Sites

    STORE4 is in the sys.servers so it cannot be added by sp_addlinkedserver

    Can anyone give me some clues as to what this error message might mean and how to fix it.

    Cheers
    Laurie

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Check the name of the server to make sure that it does not contain leading or trailing spaces. Also check to see if you can run the query yourself outside of the application.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •