Sql Server Error 18452 The Login Is From An Untrusted Domain
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
I have two MS SQL databases under the same server: I connect normally to one of them using MS SQL Server Management Studio with Windows Authentication but when I try to connect to the other I get the error stated in the title of this question.
I am a total ignorant when it comes to Windows and I do not even know what other details are required for someone to be able to help me.
Any help will be appreciated.
sql-server windows-server-2012
|
show 11 more comments
I have two MS SQL databases under the same server: I connect normally to one of them using MS SQL Server Management Studio with Windows Authentication but when I try to connect to the other I get the error stated in the title of this question.
I am a total ignorant when it comes to Windows and I do not even know what other details are required for someone to be able to help me.
Any help will be appreciated.
sql-server windows-server-2012
firtsly, could you provide screenshots of everything you do!?
– George K
Sep 27 '17 at 12:44
Please confirm if I understood you well: You have 1 server with 2 instances. You can connect to one of them using Windows Authentication, and you cannot connect to your second instance. You connect remotely from pc in the same domain, right?
– sepupic
Sep 27 '17 at 12:50
@sepupic I am connecting locally, using SQL Server Management Studio. The rest you understood well. Cheers
– clapas
Sep 27 '17 at 13:08
@GeorgeK Everything I do would take dozens of screenshots. What do you want to see exactly?
– clapas
Sep 27 '17 at 13:10
Do you use . for default instance and .InstName for named instance or do you use IP?
– sepupic
Sep 27 '17 at 13:11
|
show 11 more comments
I have two MS SQL databases under the same server: I connect normally to one of them using MS SQL Server Management Studio with Windows Authentication but when I try to connect to the other I get the error stated in the title of this question.
I am a total ignorant when it comes to Windows and I do not even know what other details are required for someone to be able to help me.
Any help will be appreciated.
sql-server windows-server-2012
I have two MS SQL databases under the same server: I connect normally to one of them using MS SQL Server Management Studio with Windows Authentication but when I try to connect to the other I get the error stated in the title of this question.
I am a total ignorant when it comes to Windows and I do not even know what other details are required for someone to be able to help me.
Any help will be appreciated.
sql-server windows-server-2012
sql-server windows-server-2012
asked Sep 27 '17 at 12:35
clapasclapas
1011
1011
firtsly, could you provide screenshots of everything you do!?
– George K
Sep 27 '17 at 12:44
Please confirm if I understood you well: You have 1 server with 2 instances. You can connect to one of them using Windows Authentication, and you cannot connect to your second instance. You connect remotely from pc in the same domain, right?
– sepupic
Sep 27 '17 at 12:50
@sepupic I am connecting locally, using SQL Server Management Studio. The rest you understood well. Cheers
– clapas
Sep 27 '17 at 13:08
@GeorgeK Everything I do would take dozens of screenshots. What do you want to see exactly?
– clapas
Sep 27 '17 at 13:10
Do you use . for default instance and .InstName for named instance or do you use IP?
– sepupic
Sep 27 '17 at 13:11
|
show 11 more comments
firtsly, could you provide screenshots of everything you do!?
– George K
Sep 27 '17 at 12:44
Please confirm if I understood you well: You have 1 server with 2 instances. You can connect to one of them using Windows Authentication, and you cannot connect to your second instance. You connect remotely from pc in the same domain, right?
– sepupic
Sep 27 '17 at 12:50
@sepupic I am connecting locally, using SQL Server Management Studio. The rest you understood well. Cheers
– clapas
Sep 27 '17 at 13:08
@GeorgeK Everything I do would take dozens of screenshots. What do you want to see exactly?
– clapas
Sep 27 '17 at 13:10
Do you use . for default instance and .InstName for named instance or do you use IP?
– sepupic
Sep 27 '17 at 13:11
firtsly, could you provide screenshots of everything you do!?
– George K
Sep 27 '17 at 12:44
firtsly, could you provide screenshots of everything you do!?
– George K
Sep 27 '17 at 12:44
Please confirm if I understood you well: You have 1 server with 2 instances. You can connect to one of them using Windows Authentication, and you cannot connect to your second instance. You connect remotely from pc in the same domain, right?
– sepupic
Sep 27 '17 at 12:50
Please confirm if I understood you well: You have 1 server with 2 instances. You can connect to one of them using Windows Authentication, and you cannot connect to your second instance. You connect remotely from pc in the same domain, right?
– sepupic
Sep 27 '17 at 12:50
@sepupic I am connecting locally, using SQL Server Management Studio. The rest you understood well. Cheers
– clapas
Sep 27 '17 at 13:08
@sepupic I am connecting locally, using SQL Server Management Studio. The rest you understood well. Cheers
– clapas
Sep 27 '17 at 13:08
@GeorgeK Everything I do would take dozens of screenshots. What do you want to see exactly?
– clapas
Sep 27 '17 at 13:10
@GeorgeK Everything I do would take dozens of screenshots. What do you want to see exactly?
– clapas
Sep 27 '17 at 13:10
Do you use . for default instance and .InstName for named instance or do you use IP?
– sepupic
Sep 27 '17 at 13:11
Do you use . for default instance and .InstName for named instance or do you use IP?
– sepupic
Sep 27 '17 at 13:11
|
show 11 more comments
1 Answer
1
active
oldest
votes
- Press Windows+R
- Type services.msc
- Click OK
- Go to SQL services
- Right click on it and go to Properties
- Click on Log On
- Click Browse
- Write Local on Text field ‘Enter the object name to select’
- Click OK
- Reset this passwords
- Simply click Apply
- Click Ok and Ok once again
- Restart the service and try to login again
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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%2fdba.stackexchange.com%2fquestions%2f187043%2fsql-server-error-18452-the-login-is-from-an-untrusted-domain%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
- Press Windows+R
- Type services.msc
- Click OK
- Go to SQL services
- Right click on it and go to Properties
- Click on Log On
- Click Browse
- Write Local on Text field ‘Enter the object name to select’
- Click OK
- Reset this passwords
- Simply click Apply
- Click Ok and Ok once again
- Restart the service and try to login again
add a comment |
- Press Windows+R
- Type services.msc
- Click OK
- Go to SQL services
- Right click on it and go to Properties
- Click on Log On
- Click Browse
- Write Local on Text field ‘Enter the object name to select’
- Click OK
- Reset this passwords
- Simply click Apply
- Click Ok and Ok once again
- Restart the service and try to login again
add a comment |
- Press Windows+R
- Type services.msc
- Click OK
- Go to SQL services
- Right click on it and go to Properties
- Click on Log On
- Click Browse
- Write Local on Text field ‘Enter the object name to select’
- Click OK
- Reset this passwords
- Simply click Apply
- Click Ok and Ok once again
- Restart the service and try to login again
- Press Windows+R
- Type services.msc
- Click OK
- Go to SQL services
- Right click on it and go to Properties
- Click on Log On
- Click Browse
- Write Local on Text field ‘Enter the object name to select’
- Click OK
- Reset this passwords
- Simply click Apply
- Click Ok and Ok once again
- Restart the service and try to login again
answered 8 mins ago
PriyankaPriyanka
698
698
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- 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%2fdba.stackexchange.com%2fquestions%2f187043%2fsql-server-error-18452-the-login-is-from-an-untrusted-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
firtsly, could you provide screenshots of everything you do!?
– George K
Sep 27 '17 at 12:44
Please confirm if I understood you well: You have 1 server with 2 instances. You can connect to one of them using Windows Authentication, and you cannot connect to your second instance. You connect remotely from pc in the same domain, right?
– sepupic
Sep 27 '17 at 12:50
@sepupic I am connecting locally, using SQL Server Management Studio. The rest you understood well. Cheers
– clapas
Sep 27 '17 at 13:08
@GeorgeK Everything I do would take dozens of screenshots. What do you want to see exactly?
– clapas
Sep 27 '17 at 13:10
Do you use . for default instance and .InstName for named instance or do you use IP?
– sepupic
Sep 27 '17 at 13:11