SQL Server Performance

Linked server

Discussion in 'SQL Server 2005 General DBA Questions' started by contactjimmyus, Apr 16, 2008.

  1. contactjimmyus New Member

    Ihave a sql 2000 and 2005 server.I need to query sql 2000 from sql 2005 machine .
    SQL 2000 IS RUNNING under local system account. and sql 2005 under a domain account .
    Is it possible to run query to sql 2000 from 20005 machine ..or
    else openrowset function will work for the issue...
    Please comment on this
    Thanks a lot
    contactjimmyus, Apr 16, 2008
    #2

  2. jagblue New Member

    jagblue, Apr 16, 2008
    #3

  3. contactjimmyus New Member

    In my case i have an sql 2005 machine and sql 2000 machine .sql 2005 is running under domiin account and sql 2000 in local system account .
    i am trying to query from sql 2005 to sql200-0 machine and not able to do so .Both server has the same sql login and password but not able to create the login it gives the error message as there is no remote user 'xpi8user' mapped to local user (null) from the remote server (servername) microsoft sql server error 15466
    the login exist on the remote user with the same user id and password and iam able to login to the server using it .is the error is due to the service account on the remote server was local system account ? what is the solution to connect to the sql 2000 serve r ?lll
    contactjimmyus, Apr 20, 2008
    #4

  4. satya Moderator

    The error is obvious that because of service accounts are different, in this case on SQL 2005 if you can setup the service account or authenticate with same account (username &password) to be the same on 2 servers, you should be able to start the database normally, and then you could change the service account to something else, if you wish - but you must start the database under the same account as on the source server. Otherwise, you'll have to use the FORCE option to reload the SMK.
    satya, Apr 21, 2008
    #5

  5. contactjimmyus New Member

    SO inorder to create linked server between sql 2005 and 2000 the service account of both servers should have the same domain account ?
    Both servers have the same userid and password but when setting up the linked server getting the error .
    Thnaks
    contactjimmyus, Apr 22, 2008
    #6

Share This Page