| Author |
Topic |
|
chen149
Starting Member
19 Posts |
 Posted - 2006-01-11 : 11:23:37
|
| Hello everyone,Thanks first.I got in trouble. My sql authentication set to 'Windows only' but I have sa account. Now I accidently delete my window's account which is sysadmin role. My question is my sa account cannot be used because it is windows only. How can I get my window user set back to sysadmin role? Is it possible?Thanks againChen |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-01-11 : 11:30:36
|
| U can tryif u have admin login rights to the machine where this SQL server is in?If so login as administrator to the MachineUse windows authentication to log increate whatever the user (in windows)create whatever the users in SQL serverIf u can open Enterprise ManagerSelect the corresponding instanceright click and select propertiesselect security tabu can change the authentication mode as u wish. |
 |
|
|
chen149
Starting Member
19 Posts |
Posted - 2006-01-11 : 11:42:38
|
| Thanks Srinika,I tried that before. It showed 'only member of sysadmins role can access this feature.any idea?Thankschen |
|
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-01-11 : 12:01:15
|
| U tried my 2nd suggestion ?also readhttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=59028 |
|
|
|
chen149
Starting Member
19 Posts |
Posted - 2006-01-11 : 14:29:41
|
| Hello Srinika,I tried both way. They are not working for me. My problem is I didn't has any login which has sysadmin role signed. So I cannot change Authentication from windows only.Thanks again,Chen |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-11 : 14:33:19
|
| Did you remove the sysadmin fixed server role from the BUILTIN\Administrators group? If so, then create a local user on the database server. Grant it local admin access by adding it to the Administrators group. You do this via Computer Management which can be found in Administrative Tools in Control Panel. Once you've setup this account, log into the box using this new account. This use Windows Authentication to connect. Now fix your problem by changing the security to mixed mode.Tara Kizeraka tduggan |
|
|
|
chen149
Starting Member
19 Posts |
Posted - 2006-01-11 : 14:48:25
|
| Thanks Tara,According the secrity best practice, I removed BUILTIN\Administrators group from my sql server. If there is other way to do it.Thanks again, Chen |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-11 : 14:52:02
|
| There is no other way to get into your SQL Server then.Tara Kizeraka tduggan |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-01-11 : 19:35:08
|
| do you domain accounts running sql server service?if yes, log on to any machine with sql em using that account which is not local admin in that machine, if you've configured the sql server right and following best practice, the service account should have sa privilegesHTH--------------------keeping it simple... |
|
|
|
TimS
Posting Yak Master
198 Posts |
|
|
chen149
Starting Member
19 Posts |
Posted - 2006-01-12 : 16:03:25
|
| Thanks Tim, you are the best. I solved ny problem.have a nice day!Chen |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2006-01-13 : 10:23:26
|
| Obviously, you sell the oranges to make enough money to buy apples. Welcome back, Brett. Long time no post? |
|
|
|
|
Login