This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 63%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPJ%3C/text%3E%3C/svg%3E)
I have a MSSQL server that I am running and have an instance that I need to allow a non admin to be able to administer. This user is using SSMS from his PC to manage the SQL Databases. He is able to do anything he needs to do except it has the question mark and is not allowed to right click on it and restart the services. I have made sure WMI is enabled and allowed remote enable for this user to this. I have enabled DCOM component to allow this user to access it remotely. I have gave permissions to the user to the MSSQL service and the SQLAgent using subinacl. I have ensured WMI and DCOM are enabled for in on the firewall. The user can use powershell and get into the sql server using enter-pssession then he can stop, start, or restart the service using cmdlets. When the user goes into SSMS however it shows a question mark on the server and agent. I can put that user in the Local Administrators group and it goes to the green arrow so I know it is a permissions issue but am unsure of what else is left to do to allow SSMS to be able to restart these services from a remote pc. Any help on this would be appreciated.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 89%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Hi @Phillip Johnson
I found this link for you about Setting up Management Studio for remote SQL Server: https://www.sqlservercentral.com/articles/setting-up-management-studio-for-remote-sql-server.
You can check if there are any missing steps.
Best regards,
Aniya
I have done all of these steps. The only difference is the instance that the user is connecting to is not the default instance. The port that is configured is set to 0 so it is dynamic. The thing that gets me is if I put the user in the local administrators group then he can open SSMS without the question mark and can restart the services from SSMS without an issue but when I take him out of that group it goes back to the question and then if I right click on the server the start, stop, restart is greyed out. I feel confident that the issue is with permissions as it works fine as a domain admin or a local admin to that box.
Hi @Phillip Johnson
Please have a look at Olaf's answer maybe it will give you some help.
Best regards,
Aniya
and restart the services
SQL Server is a Windows Service and restarting a service requeries admin on Windows level, not on SQL Server.