Let see Additional Connection Parameters in the Connect to Database login window how used to connect SQL Server from different domain
It’s a very typical use case for us, when we need to connect to a SQL server in a different domain, such as production or TEST/UAT or cloud domain, its generally requires Windows-only authentication (its more secured) that is different from our current security login context, but the “User name” is grayed out and can’t be changed when we select “Windows Authentication” in the “Login” tab.
As per below image, User name is not editable in case of Windows Authentication.
I would like to use User Name as DCDOMAIN\Virendra.Yaduvanshi, to do this just click on Option button, then Select Additional Connection Parameters tab, and write there your additional connection string as below image,
Now click on connect, JJ
Great!, now you are connected.
Note : Please refer http://www.connectionstrings.com for connection string.
Hmm is anyone else experiencing problems with the pictures on this blog loading?
I’m trying to find out if its a problem on my end or if it’s the
blog. Any feed-back would be greatly appreciated.
LikeLike