February 26, 2009 at 6:09 am
Afternoon all.
Hoping for some advice.
Have an SQL 2005 Sp3 server in a separate domain from my where my management studio tools are located.
I have created SQL login on remote server so can register servers via SQL auth within management studio.
SQL account is sysadmin.
However I can not stop , start , or see green icon when have remote server logged in SSMS.
is this because the SQL account does not have permissions on the remote box to stop start services etc remotley ? , hence no option to stop or start with remote connection.
Is this possible to fix when using SQL logins ?
Many thanks for any advice.
February 26, 2009 at 11:06 pm
To stop and start SQL Services, the user must belong to the "System Administrators" group. Is your SQL login part of that group?
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
February 27, 2009 at 1:02 am
Hi thanks for reply.
Yes SQL login is part of sysadmin group.
February 27, 2009 at 12:45 pm
The question isn't is your login part of the sql server sysadmin group. What matters if is the login is part of the actual windows System Administrator group, or atleast part of the group that has rights to administer the SQL Server Service.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply