Need to retrieve hashed password without usage of LoginPropertySQL Server memory usageHow does “Be made...
Will the duration of traveling to Ceres using the same tech developed for going to Mars be proportional to the distance to go to Mars or not?
If I tried and failed to start my own business, how do I apply for a job without job experience?
Need help now with power steering
Why do single electrical receptacles exist?
What does "don't have a baby" imply or mean in this sentence?
Graphical modeler calculator missing in QGIS3
Is Developer Console going to be deprecated?
How can guns be countered by melee combat without raw-ability or exceptional explanations?
Partial derivative with respect to three variables
What is the reward?
What is an efficient way to digitize a family photo collection?
What is formjacking?
Is it possible to detect 100% of SQLi with a simple regex?
How can I handle players killing my NPC outside of combat?
How bad is a Computer Science course that doesn't teach Design Patterns?
What does an unprocessed RAW file look like?
Multiple null checks in Java 8
Disk space full during insert, what happens?
Buying a "Used" Router
How to know you are over-explaining and oversimplifying a subject?
Sets that are both Sum-free and Product-free
Coworker is trying to get me to sign his petition to run for office. How to decline politely?
What really causes series inductance of capacitors?
How many copper coins fit inside a cubic foot?
Need to retrieve hashed password without usage of LoginProperty
SQL Server memory usageHow does “Be made using the login's current security context” pass the users password to remote serverHarden a public login to only let it retrieve a list of other logins, and do nothing elseWhy shouldn't a pre-hashed password be used with CREATE LOGIN all the time?Transposing/Wrangling Database TableINSERT INTO SQL Server : Linked Server without specifying database in semi-fully qualified namePermissions via Trusted Connection partially workingLog bad call to stored procedureHow to update sys.login_token without restart SQL Server Service
I need to retrieve the hashed password on a linked server, since its a linked server I cant seem to just use LoginProperty in the query. At the moment I go after the sys.syslogins but the password is stored in there as what appears to be Chinese lettering and what I need is something that is the varbinary form like:
0x0200DF5602211E3AEC954FDD54A114C59B6B07C72BAB3E6DFC7A2CE0046B0B7A6037EB9F5AE6E04005FF
What is the best way to accomplish this? If I am missing a way to just use LoginProperty when going after a linked server that is fine as well.
If possible I would like to stick with querying the syslogins and convert what is stored there into something usable.
sql-server t-sql
edited Dec 5 '17 at 19:03
SQLguy123
1014
asked Dec 5 '17 at 16:02
GGGGGG
1
bumped to the homepage by Community♦ 14 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I need to retrieve the hashed password on a linked server, since its a linked server I cant seem to just use LoginProperty in the query. At the moment I go after the sys.syslogins but the password is stored in there as what appears to be Chinese lettering and what I need is something that is the varbinary form like:
0x0200DF5602211E3AEC954FDD54A114C59B6B07C72BAB3E6DFC7A2CE0046B0B7A6037EB9F5AE6E04005FF
What is the best way to accomplish this? If I am missing a way to just use LoginProperty when going after a linked server that is fine as well.
If possible I would like to stick with querying the syslogins and convert what is stored there into something usable.
sql-server t-sql
edited Dec 5 '17 at 19:03
SQLguy123
1014
asked Dec 5 '17 at 16:02
GGGGGG
1
bumped to the homepage by Community♦ 14 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I need to retrieve the hashed password on a linked server, since its a linked server I cant seem to just use LoginProperty in the query. At the moment I go after the sys.syslogins but the password is stored in there as what appears to be Chinese lettering and what I need is something that is the varbinary form like:
0x0200DF5602211E3AEC954FDD54A114C59B6B07C72BAB3E6DFC7A2CE0046B0B7A6037EB9F5AE6E04005FF
What is the best way to accomplish this? If I am missing a way to just use LoginProperty when going after a linked server that is fine as well.
If possible I would like to stick with querying the syslogins and convert what is stored there into something usable.
sql-server t-sql
edited Dec 5 '17 at 19:03
SQLguy123
1014
asked Dec 5 '17 at 16:02
GGGGGG
1
I need to retrieve the hashed password on a linked server, since its a linked server I cant seem to just use LoginProperty in the query. At the moment I go after the sys.syslogins but the password is stored in there as what appears to be Chinese lettering and what I need is something that is the varbinary form like:
0x0200DF5602211E3AEC954FDD54A114C59B6B07C72BAB3E6DFC7A2CE0046B0B7A6037EB9F5AE6E04005FF
What is the best way to accomplish this? If I am missing a way to just use LoginProperty when going after a linked server that is fine as well.
If possible I would like to stick with querying the syslogins and convert what is stored there into something usable.
sql-server t-sql
sql-server t-sql
edited Dec 5 '17 at 19:03
SQLguy123
1014
asked Dec 5 '17 at 16:02
GGGGGG
1
edited Dec 5 '17 at 19:03
SQLguy123
1014
asked Dec 5 '17 at 16:02
GGGGGG
1
edited Dec 5 '17 at 19:03
SQLguy123
1014
edited Dec 5 '17 at 19:03
SQLguy123
1014
edited Dec 5 '17 at 19:03
SQLguy123
1014
1014
asked Dec 5 '17 at 16:02
GGGGGG
1
asked Dec 5 '17 at 16:02
GGGGGG
1
asked Dec 5 '17 at 16:02
GGGGGG
1
1
bumped to the homepage by Community♦ 14 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 14 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Just run a passthrough query on the linked server. EG
select * from openquery(LinkedServer,'select loginproperty(''SomeLogin'',''PasswordHash'') hash')
answered Dec 5 '17 at 16:21
David Browne - MicrosoftDavid Browne - Microsoft
11.6k729
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%2f192439%2fneed-to-retrieve-hashed-password-without-usage-of-loginproperty%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
Just run a passthrough query on the linked server. EG
select * from openquery(LinkedServer,'select loginproperty(''SomeLogin'',''PasswordHash'') hash')
answered Dec 5 '17 at 16:21
David Browne - MicrosoftDavid Browne - Microsoft
11.6k729
add a comment |
Just run a passthrough query on the linked server. EG
select * from openquery(LinkedServer,'select loginproperty(''SomeLogin'',''PasswordHash'') hash')
answered Dec 5 '17 at 16:21
David Browne - MicrosoftDavid Browne - Microsoft
11.6k729
add a comment |
Just run a passthrough query on the linked server. EG
select * from openquery(LinkedServer,'select loginproperty(''SomeLogin'',''PasswordHash'') hash')
answered Dec 5 '17 at 16:21
David Browne - MicrosoftDavid Browne - Microsoft
11.6k729
Just run a passthrough query on the linked server. EG
select * from openquery(LinkedServer,'select loginproperty(''SomeLogin'',''PasswordHash'') hash')
answered Dec 5 '17 at 16:21
David Browne - MicrosoftDavid Browne - Microsoft
11.6k729
answered Dec 5 '17 at 16:21
David Browne - MicrosoftDavid Browne - Microsoft
11.6k729
answered Dec 5 '17 at 16:21
David Browne - MicrosoftDavid Browne - Microsoft
11.6k729
answered Dec 5 '17 at 16:21
David Browne - MicrosoftDavid Browne - Microsoft
11.6k729
11.6k729
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%2f192439%2fneed-to-retrieve-hashed-password-without-usage-of-loginproperty%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
