Create login with SID as stringCannot connect to SQL Server database regardless of connection stringHyphen in...
80-bit collision resistence because of 80-bit x87 registers?
Why write a book when there's a movie in my head?
Why are "square law" devices important?
Can a Hydra make multiple opportunity attacks at once?
Are all power cords made equal?
Was the Soviet N1 really capable of sending 9.6 GB/s of telemetry?
Why does this quiz question say that protons and electrons do not combine to form neutrons?
Is corrosion inhibitor paste conductive?
How can guns be countered by melee combat without raw-ability or exceptional explanations?
Why is airport car rental so cheap
Does the Resurrection spell consume material components if the target isn’t willing to be resurrected?
Last Reboot commands don't agree
Confusion about different running times of two algorithms in C
What does "don't have a baby" imply or mean in this sentence?
How do I add a strong "onion flavor" to the biryani (in restaurant style)?
Can I legally make a website about boycotting a certain company?
Boss asked me to sign a resignation paper without a date on it along with my new contract
Use intersection in field calculator
Can I do anything else with aspersions other than cast them?
Why are `&array` and `array` pointing to the same address?
Why Is Image Exporting At Larger Dimensions Than In Illustrator File?
Why do we divide Permutations to get to Combinations?
Badly designed reimbursement form. What does that say about the company?
What if you do not believe in the project benefits?
Create login with SID as string
Cannot connect to SQL Server database regardless of connection stringHyphen in my computer's name causing T-SQL errorSQL Server passing variable to a string in a stored procDynamic SQL UNPIVOT and putting results into existing tableCreate SQL Server user with SQL Server AuthentificationUsing WITH and IF in the same queryopenrowset to connect to SQL server with a password containing single quotesCreate DDL Trigger Dynamically“If not exists” using OBJECT_ID() doesn't work for views and triggers. why?How do I use 'N' in my prepared SELECT statement
I'm trying to create a login as follows:
CREATE LOGIN [Test] WITH PASSWORD='Test123', SID=SID_BINARY(N'S-1-5-21-408552231-458724953-3089381293-513')
But no matter what it looks like SID only accepts a binary input, no subqueries or anything else really.
Incorrect syntax near 'SID'.
Is there a way to create a login with SID with a string?
sql-server
New contributor
add a comment |
I'm trying to create a login as follows:
CREATE LOGIN [Test] WITH PASSWORD='Test123', SID=SID_BINARY(N'S-1-5-21-408552231-458724953-3089381293-513')
But no matter what it looks like SID only accepts a binary input, no subqueries or anything else really.
Incorrect syntax near 'SID'.
Is there a way to create a login with SID with a string?
sql-server
New contributor
add a comment |
I'm trying to create a login as follows:
CREATE LOGIN [Test] WITH PASSWORD='Test123', SID=SID_BINARY(N'S-1-5-21-408552231-458724953-3089381293-513')
But no matter what it looks like SID only accepts a binary input, no subqueries or anything else really.
Incorrect syntax near 'SID'.
Is there a way to create a login with SID with a string?
sql-server
New contributor
I'm trying to create a login as follows:
CREATE LOGIN [Test] WITH PASSWORD='Test123', SID=SID_BINARY(N'S-1-5-21-408552231-458724953-3089381293-513')
But no matter what it looks like SID only accepts a binary input, no subqueries or anything else really.
Incorrect syntax near 'SID'.
Is there a way to create a login with SID with a string?
sql-server
sql-server
New contributor
New contributor
New contributor
asked 5 mins ago
Farlock85Farlock85
1012
1012
New contributor
New contributor
add a comment |
add a comment |
0
active
oldest
votes
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
});
}
});
Farlock85 is a new contributor. Be nice, and check out our Code of Conduct.
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%2f230432%2fcreate-login-with-sid-as-string%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
Farlock85 is a new contributor. Be nice, and check out our Code of Conduct.
Farlock85 is a new contributor. Be nice, and check out our Code of Conduct.
Farlock85 is a new contributor. Be nice, and check out our Code of Conduct.
Farlock85 is a new contributor. Be nice, and check out our Code of Conduct.
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%2f230432%2fcreate-login-with-sid-as-string%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