Log in to remote SQL Server as a domain user, but from computer outside domainSQL Server - Connect as another domain userCan't connect to SQL Server in different domain using SSMS and Windows 7 Crendential ManagerConnect to SQL Server from web application doesn't work?Using Windows Authentication accross Domains when using VPN?Cannot connect to SQL Server 2012 Express instance outside a VMIs it possible to store a credential for Windows Authentication to an Analysis Services server?SQL 2012 AlwaysOn Availability Groups Failover Successfully But Application Complains About Login Failed for UserUnable to login to SQL Server Management Studio using domain accountHow to connect multiple sql instances installed in same azure vm via internetConfigure SSRS remotely - A connection to the computer cannot be established
DBCC SHRINKFILE on the distribution database
Commencez à vous connecter -- I don't understand the phrasing of this
Loop counter not interpreted as number
Jam with honey & without pectin has a saucy consistency always
Is it possible to have battery technology that can't be duplicated?
Realistic, logical way for men with medieval-era weaponry to compete with much larger and physically stronger foes
typeid("") != typeid(const char*)
Opposite of "Concerto Grosso"?
Must a CPU have a GPU if the motherboard provides a display port (when there isn't any separate video card)?
Has JSON.serialize suppressApexObjectNulls ever worked?
Is all-caps blackletter no longer taboo?
Was the Lonely Mountain, where Smaug lived, a volcano?
What do I need to do, tax-wise, for a sudden windfall?
Do Veracrypt encrypted volumes have any kind of brute force protection?
Should I move out from my current apartment before the contract ends to save more money?
Idiom for 'person who gets violent when drunk"
Boss making me feel guilty for leaving the company at the end of my internship
What are the advantages of using TLRs to rangefinders?
Why is it bad to use your whole foot in rock climbing
How to search for Android apps without ads?
The best in flight meal option for those suffering from reflux
A flower's head or heart?
Is it a good security practice to force employees hide their employer to avoid being targeted?
usage of mir gefallen
Log in to remote SQL Server as a domain user, but from computer outside domain
SQL Server - Connect as another domain userCan't connect to SQL Server in different domain using SSMS and Windows 7 Crendential ManagerConnect to SQL Server from web application doesn't work?Using Windows Authentication accross Domains when using VPN?Cannot connect to SQL Server 2012 Express instance outside a VMIs it possible to store a credential for Windows Authentication to an Analysis Services server?SQL 2012 AlwaysOn Availability Groups Failover Successfully But Application Complains About Login Failed for UserUnable to login to SQL Server Management Studio using domain accountHow to connect multiple sql instances installed in same azure vm via internetConfigure SSRS remotely - A connection to the computer cannot be established
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I have few Windows Servers (2016/2019), say WS1, WS2 and WS3, where WS1 is domain master and rest are within the domain. Each of those run separate SQL Server instance (2017).
There are user accounts defined in the domain, say "domainJoe". "Joe" can log into any of those SQL Servers (via management studio - SSMS) from client computer that is in the domain.
I'd like to use same user account ("Joe" from domain) to access those SQL Servers, but without being in the domain.
Is that even possible? Would I need to set up separate login/pass (SQL Server Auth) for each SQL Server on each machine?
sql-server windows-server-2016 windows-authentication
asked May 29 at 20:47
ErnioErnio
1011
add a comment |
I have few Windows Servers (2016/2019), say WS1, WS2 and WS3, where WS1 is domain master and rest are within the domain. Each of those run separate SQL Server instance (2017).
There are user accounts defined in the domain, say "domainJoe". "Joe" can log into any of those SQL Servers (via management studio - SSMS) from client computer that is in the domain.
I'd like to use same user account ("Joe" from domain) to access those SQL Servers, but without being in the domain.
Is that even possible? Would I need to set up separate login/pass (SQL Server Auth) for each SQL Server on each machine?
sql-server windows-server-2016 windows-authentication
asked May 29 at 20:47
ErnioErnio
1011
add a comment |
I have few Windows Servers (2016/2019), say WS1, WS2 and WS3, where WS1 is domain master and rest are within the domain. Each of those run separate SQL Server instance (2017).
There are user accounts defined in the domain, say "domainJoe". "Joe" can log into any of those SQL Servers (via management studio - SSMS) from client computer that is in the domain.
I'd like to use same user account ("Joe" from domain) to access those SQL Servers, but without being in the domain.
Is that even possible? Would I need to set up separate login/pass (SQL Server Auth) for each SQL Server on each machine?
sql-server windows-server-2016 windows-authentication
asked May 29 at 20:47
ErnioErnio
1011
I have few Windows Servers (2016/2019), say WS1, WS2 and WS3, where WS1 is domain master and rest are within the domain. Each of those run separate SQL Server instance (2017).
There are user accounts defined in the domain, say "domainJoe". "Joe" can log into any of those SQL Servers (via management studio - SSMS) from client computer that is in the domain.
I'd like to use same user account ("Joe" from domain) to access those SQL Servers, but without being in the domain.
Is that even possible? Would I need to set up separate login/pass (SQL Server Auth) for each SQL Server on each machine?
sql-server windows-server-2016 windows-authentication
sql-server windows-server-2016 windows-authentication
asked May 29 at 20:47
ErnioErnio
1011
asked May 29 at 20:47
ErnioErnio
1011
asked May 29 at 20:47
ErnioErnio
1011
asked May 29 at 20:47
ErnioErnio
1011
asked May 29 at 20:47
ErnioErnio
1011
1011
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f969394%2flog-in-to-remote-sql-server-as-a-domain-user-but-from-computer-outside-domain%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Server Fault!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f969394%2flog-in-to-remote-sql-server-as-a-domain-user-but-from-computer-outside-domain%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
