We help IT Professionals succeed at work.

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

Medium Priority
263 Views
Last Modified: 2012-05-12
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.?
Comment
Watch Question

Cloud Architect
Commented:
Hi
if you just want automatic network login for a server you can use store network password option in control panel  

 Manage-Stored-Credentials
you need to store your user name and password on the server from wear you trying to access SQL server . (on source server )

Example :
 Logon to : MYSQLSERVER)!
 username: DOMAIN\ADMIN
 Password: Mypassword


Commented:
while defining the connection string for the application, use the userid and password for the sql login that exists in the remote server. You can get more details from
http://www.connectionstrings.com/

Author

Commented:
Thanks

Explore More ContentExplore courses, solutions, and other research materials related to this topic.