SQL Server Management Studio Change User Server Roles to sysadmin?
On my local machine I have SSMS (SQL Server 2008 R2).
For user xxxx Server Roles are only public.
When I try to change it to sysadmin it throws the error:
User does not have permission to perform this action. (.Net SqlClient Data Provider)
Error Code 15247
- Server type (local)/SQLExpress
- Authentication: Windows Authentication
- User: ComputerNameusername (disabled)
- Password: none (disabled)
How can I do this?
The user I am connecting with server role is: public, but Windows Admin user.
The instance is configured for mixed mode authentication, but I don't remember the password for sa. I can't change the password because I am not sysadmin.
Is there any way I can create a sysadmin user account or make my account sysadmin and get full control of my SSMS?
sql-server sql-server-2008 role
edited 12 mins ago
Paul White♦
51k14278450
asked Feb 13 '12 at 18:53
HaBoHaBo
14628
migrated from stackoverflow.com Feb 14 '12 at 22:57
This question came from our site for professional and enthusiast programmers.
add a comment |
On my local machine I have SSMS (SQL Server 2008 R2).
For user xxxx Server Roles are only public.
When I try to change it to sysadmin it throws the error:
User does not have permission to perform this action. (.Net SqlClient Data Provider)
Error Code 15247
- Server type (local)/SQLExpress
- Authentication: Windows Authentication
- User: ComputerNameusername (disabled)
- Password: none (disabled)
How can I do this?
The user I am connecting with server role is: public, but Windows Admin user.
The instance is configured for mixed mode authentication, but I don't remember the password for sa. I can't change the password because I am not sysadmin.
Is there any way I can create a sysadmin user account or make my account sysadmin and get full control of my SSMS?
sql-server sql-server-2008 role
edited 12 mins ago
Paul White♦
51k14278450
asked Feb 13 '12 at 18:53
HaBoHaBo
14628
migrated from stackoverflow.com Feb 14 '12 at 22:57
This question came from our site for professional and enthusiast programmers.
add a comment |
On my local machine I have SSMS (SQL Server 2008 R2).
For user xxxx Server Roles are only public.
When I try to change it to sysadmin it throws the error:
User does not have permission to perform this action. (.Net SqlClient Data Provider)
Error Code 15247
- Server type (local)/SQLExpress
- Authentication: Windows Authentication
- User: ComputerNameusername (disabled)
- Password: none (disabled)
How can I do this?
The user I am connecting with server role is: public, but Windows Admin user.
The instance is configured for mixed mode authentication, but I don't remember the password for sa. I can't change the password because I am not sysadmin.
Is there any way I can create a sysadmin user account or make my account sysadmin and get full control of my SSMS?
sql-server sql-server-2008 role
edited 12 mins ago
Paul White♦
51k14278450
asked Feb 13 '12 at 18:53
HaBoHaBo
14628
On my local machine I have SSMS (SQL Server 2008 R2).
For user xxxx Server Roles are only public.
When I try to change it to sysadmin it throws the error:
User does not have permission to perform this action. (.Net SqlClient Data Provider)
Error Code 15247
- Server type (local)/SQLExpress
- Authentication: Windows Authentication
- User: ComputerNameusername (disabled)
- Password: none (disabled)
How can I do this?
The user I am connecting with server role is: public, but Windows Admin user.
The instance is configured for mixed mode authentication, but I don't remember the password for sa. I can't change the password because I am not sysadmin.
Is there any way I can create a sysadmin user account or make my account sysadmin and get full control of my SSMS?
sql-server sql-server-2008 role
sql-server sql-server-2008 role
edited 12 mins ago
Paul White♦
51k14278450
asked Feb 13 '12 at 18:53
HaBoHaBo
14628
edited 12 mins ago
Paul White♦
51k14278450
asked Feb 13 '12 at 18:53
HaBoHaBo
14628
edited 12 mins ago
Paul White♦
51k14278450
edited 12 mins ago
Paul White♦
51k14278450
edited 12 mins ago
Paul White♦
51k14278450
51k14278450
asked Feb 13 '12 at 18:53
HaBoHaBo
14628
asked Feb 13 '12 at 18:53
HaBoHaBo
14628
asked Feb 13 '12 at 18:53
HaBoHaBo
14628
14628
migrated from stackoverflow.com Feb 14 '12 at 22:57
This question came from our site for professional and enthusiast programmers.
migrated from stackoverflow.com Feb 14 '12 at 22:57
This question came from our site for professional and enthusiast programmers.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You've explained that you don't have the SA password and you're not an administrator. In that case, you're going to have to hack your way around it.
See Think Your Windows Administrators Don’t Have Access to SQL Server 2008 by Default? Think Again. by Argenis Fernandez.
That post explains how to impersonate the NT AUTHORITYSYSTEM login using PsExec (or creating a Windows Scheduled Task running under the SYSTEM account) to create a new login for yourself. Then, you can log in via that new login, and grant your Windows account SA permissions.
edited 10 mins ago
Paul White♦
51k14278450
answered Dec 27 '13 at 22:14
Brent OzarBrent Ozar
34.3k19102230
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%2f13066%2fsql-server-management-studio-change-user-server-roles-to-sysadmin%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
You've explained that you don't have the SA password and you're not an administrator. In that case, you're going to have to hack your way around it.
See Think Your Windows Administrators Don’t Have Access to SQL Server 2008 by Default? Think Again. by Argenis Fernandez.
That post explains how to impersonate the NT AUTHORITYSYSTEM login using PsExec (or creating a Windows Scheduled Task running under the SYSTEM account) to create a new login for yourself. Then, you can log in via that new login, and grant your Windows account SA permissions.
edited 10 mins ago
Paul White♦
51k14278450
answered Dec 27 '13 at 22:14
Brent OzarBrent Ozar
34.3k19102230
add a comment |
You've explained that you don't have the SA password and you're not an administrator. In that case, you're going to have to hack your way around it.
See Think Your Windows Administrators Don’t Have Access to SQL Server 2008 by Default? Think Again. by Argenis Fernandez.
That post explains how to impersonate the NT AUTHORITYSYSTEM login using PsExec (or creating a Windows Scheduled Task running under the SYSTEM account) to create a new login for yourself. Then, you can log in via that new login, and grant your Windows account SA permissions.
edited 10 mins ago
Paul White♦
51k14278450
answered Dec 27 '13 at 22:14
Brent OzarBrent Ozar
34.3k19102230
add a comment |
You've explained that you don't have the SA password and you're not an administrator. In that case, you're going to have to hack your way around it.
See Think Your Windows Administrators Don’t Have Access to SQL Server 2008 by Default? Think Again. by Argenis Fernandez.
That post explains how to impersonate the NT AUTHORITYSYSTEM login using PsExec (or creating a Windows Scheduled Task running under the SYSTEM account) to create a new login for yourself. Then, you can log in via that new login, and grant your Windows account SA permissions.
edited 10 mins ago
Paul White♦
51k14278450
answered Dec 27 '13 at 22:14
Brent OzarBrent Ozar
34.3k19102230
You've explained that you don't have the SA password and you're not an administrator. In that case, you're going to have to hack your way around it.
See Think Your Windows Administrators Don’t Have Access to SQL Server 2008 by Default? Think Again. by Argenis Fernandez.
That post explains how to impersonate the NT AUTHORITYSYSTEM login using PsExec (or creating a Windows Scheduled Task running under the SYSTEM account) to create a new login for yourself. Then, you can log in via that new login, and grant your Windows account SA permissions.
edited 10 mins ago
Paul White♦
51k14278450
answered Dec 27 '13 at 22:14
Brent OzarBrent Ozar
34.3k19102230
edited 10 mins ago
Paul White♦
51k14278450
edited 10 mins ago
Paul White♦
51k14278450
edited 10 mins ago
Paul White♦
51k14278450
51k14278450
answered Dec 27 '13 at 22:14
Brent OzarBrent Ozar
34.3k19102230
answered Dec 27 '13 at 22:14
Brent OzarBrent Ozar
34.3k19102230
answered Dec 27 '13 at 22:14
Brent OzarBrent Ozar
34.3k19102230
34.3k19102230
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%2f13066%2fsql-server-management-studio-change-user-server-roles-to-sysadmin%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
