Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sumith
Starting Member
1 Post |
 Posted - 2013-02-14 : 14:37:00
|
| there are 5 logins includes login 'sa' in sql server.'sa' login is not enabled.All users except 'sa' are not 'sysadmin'. the other users have 'public' role only. (they cannot create any database or change privileges of user).i tried to enable 'sa' login . but it failed due to insuuficient rights of loginwhat i do to enable 'sa' account' |
|
|
srimami
Posting Yak Master
160 Posts |
Posted - 2013-02-14 : 18:29:50
|
| Right click on sever (Object Explorer), go to security and change the settings as required. |
 |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2013-02-15 : 14:04:27
|
| First, verify that SQL Server has been configured for both Windows and SQL Authentication. If it is only Windows authentication - enabling/disabling the sa account will have no effect.Second, if SQL authentication is available - verify that you are logged in with a sysadmin level account. If - as you say above - the only login available with sysadmin rights is sa, then you will need to use the following process: http://blogs.msdn.com/b/raulga/archive/2007/07/12/disaster-recovery-what-to-do-when-the-sa-account-password-is-lost-in-sql-server-2005.aspxAnd finally, if you only have windows authentication available - then you need to follow the same type of procedure but instead of making the change to the sa account you would add your own account and set it as sysadmin.All options will require an outage... |
|
|
|
Jeff Moden
Aged Yak Warrior
652 Posts |
Posted - 2013-02-15 : 20:41:23
|
quote:
Originally posted by srimami
Right click on sever (Object Explorer), go to security and change the settings as required.
Read the orginal post. How is the OP going to do as you suggest when none of the logins (including the OPs) have the privs to change security.--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for "Row By Agonizing Row".First step towards the paradigm shift of writing Set Based code:"Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column." When writing schedules, keep the following in mind:"If you want it real bad, that's the way you'll likely get it." |
|
|
|
|
|
|
cannot enable 'sa' login