select query problem

Results 1 to 2 of 2

Thread: select query problem

  1. #1
    Madhu Guest

    Default select query problem

    Hi, <BR>I want to execute a sql SELECT query from two tables(join) residing in two different machines(MS-SQL servers). I tried in the following way.<BR>SELECT ONE.companyname, <BR>TWO.profession<BR>from SERVER1.DBNAME.USERNAME1.TABLENAME ONE, <BR>SERVER2.DBNAME.USERNAME2.TABLENAME TWO<BR>where ONE.customerid=73146<BR>But when I executes this query from SERVER2 ...FOLLWING error is displayed "Server &#039;SERVER1&#039; is not configured for DATA ACCESS."<BR>How to solve this problem ?

  2. #2
    Join Date
    Dec 1969

    Default RE: select query problem

    Hi!<BR>Make Sure that a login with the same name through which u r logged into Server 2 exsists on Server 1.<BR>Suppose! if u r using login &#039;xyz&#039; to logged into server 2 then server 1 should be having a user &#039;xyz&#039; with the permission to query that table.<BR>I hope it will work.<BR>

Posting Permissions

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