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  

Hi

Look at this forum

http://sql-server-performance.com/Community/forums/p/736/4390.aspx

Thanks

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

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.

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