I have SQL server login with sysadmin role, but I cannot stop and start SQL server when I connect from remote management studio, just from local server management studio. How can I enable it? I use windows server 2008r2, SQL server 2008r2.
2
-
Are you trying to start/stop from SSMS ?– ShankyApr 22, 2020 at 9:51
-
yes, the start/stop option enabled just from local server machine, not from remote ssms.– MichalApr 22, 2020 at 9:55
Add a comment
|
1 Answer
If you connect to SQL Server from a Machine M which has SSMS installed but your account is not local admin on Machine M you would find the option of start/stop to be disabled or greyed out. OTOH if you are local admin on the Machine M you would find the option to be enabled. When you do this from server on which SQL Server is installed, you are administrator there and hence you see the option. It does not matter whether your account is admin in SQL Server or not when you connect from machine where you do not have local admin privileges you would see the option disabled, however you would still be able to perform all sysadmin activities in SQL Server. This is not a complete statement their could be other reasons as well, this is what mostly I have observed, please check and let me know. Please also refer to SQL Server agent start stop and restart disabled blog to know more about reasons why this could happen
-
How can I check which domain\local user is behind my sql server login?– MichalApr 26, 2020 at 5:06
-
You mean to say which login is used to connect to SQL Server ?. First check whether your login is local admin on machine from where you are connecting SQL Server, please read the answer and let me know if that works.– ShankyApr 26, 2020 at 5:26