Manage-Stored-Credentials.jpg

<div>
<div class="content wysiwyg-content">
I am creating an application to retrieve data from an remote SQL Server Database in a different domain. &nbsp; I have the window authentication for the SQL Server domain. &nbsp;How can I specify to use the SQL Server domain window authentication rather than that of my domain? &nbsp;Does it means I need to used SQL Server Authentication instead if I do not established a trust relationship between SQL Server Domain and My Domain.?<br />

</div>
</div>


I am creating an application to retrieve data from an remote SQL Server Database in a different domain.   I have the window authentication for the SQL Server domain.  How can I specify to use the SQL Server domain window authentication rather than that of my domain?  Does it means I need to used SQL Server Authentication instead if I do not established a trust relationship between SQL Server Domain and My Domain.?


Remote login to SQL Server Database from a local SQL Server Management Studio

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

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.