<div>
that depends on how you want security to work? &nbsp;If you want all users to only be able to use the linked server if their current credentials are valid on both databases, use the &quot;Be made using the login's current security context&quot; option. &nbsp;If you want to create a link that will work on the linked server even if the current user does not have access to it, you have to use the last option, &quot;Be made using this security context:&quot; and provide a valid remote login/pw that has access to the remote db.
</div>


that depends on how you want security to work?  If you want all users to only be able to use the linked server if their current credentials are valid on both databases, use the "Be made using the login's current security context" option.  If you want to create a link that will work on the linked server even if the current user does not have access to it, you have to use the last option, "Be made using this security context:" and provide a valid remote login/pw that has access to the remote db.

<div>
<div class="content wysiwyg-content">
i have a SQL in database engine .. it has a windows authen and works... now i want to add this server as a linked server<br />
<br />
going to linked server --&gt; new server.. then choose SQL server and fill in the SQL servername ... but what do i fill in at the security tab?<br />
<br />
Thanks in advanced
</div>
</div>


i have a SQL in database engine .. it has a windows authen and works... now i want to add this server as a linked server

going to linked server --> new server.. then choose SQL server and fill in the SQL servername ... but what do i fill in at the security tab?

Thanks in advanced

trouble linking servers

Microsoft SQL Server 2005 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. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

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.