May 22, 2008 at 2:30 am
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 :hehe:
TIA
May 22, 2008 at 3:35 am
Are you restarting the service from withing SSMS?
Are you a domain/local administrator on the server?
Matt
May 22, 2008 at 5:10 am
Yes am using SSMS .Am using SQL authentication not windows
May 22, 2008 at 5:27 am
How are you restarting it?
Are you a domain/local administrator on the server?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 22, 2008 at 5:52 am
I tried using a new login with only datareader and datawriter database roles and access to only one DB.
May 22, 2008 at 5:56 am
Ratheesh.K.Nair (5/22/2008)
I tried using a new login with only datareader and datawriter database roles and access to only one DB.
Not what I asked.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 22, 2008 at 6:28 am
No am not local admin ...I dont have administrative privileages .The user which am using is a SQL login and its not a domain user.
May 22, 2008 at 6:36 am
How are you restarting the service? (registered servers, object explorer, xp_cmdshell, shutdown)?
The user which am using is a SQL login and its not a domain user.
I'm not talking about the SQL user that you're connecting to SQL server as. I'm asking about the windows user that you are logged into the domain as. Is that user (the one you are running management studio as) a local admin on that server or a domain admin?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 22, 2008 at 7:52 am
Thanks Gila..:D
Ya my user is a local admin.I tried using another login which is not a local admin and am not able to restart the server.
Once again thanks
May 22, 2008 at 11:17 am
I assume you're using object explore or registered servers then. The step/start/restart there uses the currently logged in windows user and net commands to do the requested operation. It doesn't use the SQL permissions at all.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply