<div>
You're going to need to provide quite a bit more detail on this. This isn't a SQL error with a query. The query is fine. What is the set up there? You mention linked servers. What credentials are being used between the 2 servers? How are they linked?
</div>


You're going to need to provide quite a bit more detail on this. This isn't a SQL error with a query. The query is fine. What is the set up there? You mention linked servers. What credentials are being used between the 2 servers? How are they linked?

<div>
thank you for the reply<br />
i run this query <br />

<pre><code id="code-20-40107845-1">USE master;
GO
EXEC sp_linkedservers</code></pre>
<br />
and i found that server2 was added in linked servers for server1
</div>


thank you for the reply
i run this query


USE master;
GO
EXEC sp_linkedservers


and i found that server2 was added in linked servers for server1

<div>
<div class="content wysiwyg-content">
Hi experts<br />
i have a query that retrieve data from 2 differents server, but once i execute the query i am getting this error<br />

<blockquote>
Login failed for user 'usr1'
</blockquote>
<br />
i am running the query in server1, with username: usr1<br />
<br />

<pre><code id="code-10-28447074-1">select userid, m.name, Cardid, m.dircode, 
from [Server1].Database1.dbo.member m
JOIN [Server2].Database2.dbo.GetUserDetails p 
on p.cprno = m.cardid 
WHERE PerUserName='mftrame'</code></pre>
<br />
i already provide <b>usr1 </b>read permission on <b>[Server2].Database2.dbo.Ge<wbr />tUserDetai<wbr />ls </b><br />
<br />
also how can i check if i added a link to <b>server1</b> into <b>server2</b>
</div>
</div>


Hi experts
i have a query that retrieve data from 2 differents server, but once i execute the query i am getting this error
Login failed for user 'usr1'

i am running the query in server1, with username: usr1

(CODE)

i already provide usr1 read permission on [Server2].Database2.dbo.GetUserDetails 

also how can i check if i added a link to server1 into server2

Login failed for user

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.