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 |
|
ratheeshknair
Posting Yak Master
129 Posts |
 Posted - 2008-05-22 : 07:11:25
|
| Hi Experts, Am able to restart my local sql server using a login which dont have a sysadmin privileage.This login only have access to a particular database .Its only having datareader and datawriter as DB roles but still am able to restart the server.Please help TIARKNAIR |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-05-22 : 07:14:56
|
| how are you restarting it?_______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.0 out! |
 |
|
|
ratheeshknair
Posting Yak Master
129 Posts |
Posted - 2008-05-22 : 07:27:23
|
| AM restarting using SSMS. Connected using SQL Server Authetication not Windows.RKNAIR |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-22 : 09:08:53
|
| So what is the issue? |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-05-22 : 13:15:29
|
| Answered over on Central.[url]http://www.sqlservercentral.com/Forums/Topic505031-146-1.aspx[/url]--Gail Shaw |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-22 : 22:35:19
|
| >> still am able to restart the serverYou can restart sql service if your windows account has local admin rights. |
|
|
|
|
|
|
Strange