Currently, I'm running SQL Server 2000 on Windows 2000
Advanced Server. I created a new Windows user who is not
in the Administrators group. Then, I entered into the SQL
instance's properties and changed the startup account to
be this new user's credentials. As a result, SQL created a
login for this new user and added him to the System
Administrators server role. When I log into the system as
this new user, I'm able to start the instance but I'm not
able to stop it. I don't understand this behavior since a
System administrator has SHUTDOWN privileges. Any
assistance is greatly appreciated.
Sincerely,
ABG