Can I add a password for SQL Server “sysadmin” role?
I need help in adding password to SQL server role. Actually I'm working on SQL server and Sybase ASE. In Sybase I can add a password for SA_ROLE & SSO_Role. Can I do the same in SQL Server?
Thanks in advance,
Ramez Nabil
sql-server
asked Jan 17 at 16:41
user986501user986501
1
add a comment |
I need help in adding password to SQL server role. Actually I'm working on SQL server and Sybase ASE. In Sybase I can add a password for SA_ROLE & SSO_Role. Can I do the same in SQL Server?
Thanks in advance,
Ramez Nabil
sql-server
asked Jan 17 at 16:41
user986501user986501
1
add a comment |
I need help in adding password to SQL server role. Actually I'm working on SQL server and Sybase ASE. In Sybase I can add a password for SA_ROLE & SSO_Role. Can I do the same in SQL Server?
Thanks in advance,
Ramez Nabil
sql-server
asked Jan 17 at 16:41
user986501user986501
1
I need help in adding password to SQL server role. Actually I'm working on SQL server and Sybase ASE. In Sybase I can add a password for SA_ROLE & SSO_Role. Can I do the same in SQL Server?
Thanks in advance,
Ramez Nabil
sql-server
sql-server
asked Jan 17 at 16:41
user986501user986501
1
asked Jan 17 at 16:41
user986501user986501
1
asked Jan 17 at 16:41
user986501user986501
1
asked Jan 17 at 16:41
user986501user986501
1
asked Jan 17 at 16:41
user986501user986501
1
1
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Typical SQL Server roles do not have passwords associated with them. A SQL login has a password, and that SQL login is then assigned to a role.
(There is a mechanism with SQL called an Application Role. That type of role has a password associated with it, but I don't think that's what you are asking about.)
answered Jan 17 at 16:44
Doug DedenDoug Deden
757213
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
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%2fsuperuser.com%2fquestions%2f1395455%2fcan-i-add-a-password-for-sql-server-sysadmin-role%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
Typical SQL Server roles do not have passwords associated with them. A SQL login has a password, and that SQL login is then assigned to a role.
(There is a mechanism with SQL called an Application Role. That type of role has a password associated with it, but I don't think that's what you are asking about.)
answered Jan 17 at 16:44
Doug DedenDoug Deden
757213
add a comment |
Typical SQL Server roles do not have passwords associated with them. A SQL login has a password, and that SQL login is then assigned to a role.
(There is a mechanism with SQL called an Application Role. That type of role has a password associated with it, but I don't think that's what you are asking about.)
answered Jan 17 at 16:44
Doug DedenDoug Deden
757213
add a comment |
Typical SQL Server roles do not have passwords associated with them. A SQL login has a password, and that SQL login is then assigned to a role.
(There is a mechanism with SQL called an Application Role. That type of role has a password associated with it, but I don't think that's what you are asking about.)
answered Jan 17 at 16:44
Doug DedenDoug Deden
757213
Typical SQL Server roles do not have passwords associated with them. A SQL login has a password, and that SQL login is then assigned to a role.
(There is a mechanism with SQL called an Application Role. That type of role has a password associated with it, but I don't think that's what you are asking about.)
answered Jan 17 at 16:44
Doug DedenDoug Deden
757213
edited Jan 17 at 16:55
answered Jan 17 at 16:44
Doug DedenDoug Deden
757213
answered Jan 17 at 16:44
Doug DedenDoug Deden
757213
answered Jan 17 at 16:44
Doug DedenDoug Deden
757213
757213
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- 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%2fsuperuser.com%2fquestions%2f1395455%2fcan-i-add-a-password-for-sql-server-sysadmin-role%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
