Re: SQLDMO user stop server, windows user can't

From: Steve (steve_at_somewhere.invalid.com)
Date: 08/11/04 

Date: Wed, 11 Aug 2004 11:25:20 GMT

Peri wrote:
> I have an application using SQLDMO and C#. The application
> will always use windows authentication to sql servers. The
> problems is why does an account which is connected through
> sqldmo can stop/start/pause a server in which that account
> has no privilege in stopping/starting....the server....
> Can anybody tell me why does this happened?

Starting, stopping and pausing the server is a Windows function, not SQL
server itself. Any user with administrator access to the box can start and
stop Windows services, and that includes SQL server. 

-- 
Steve Mayne

Relevant Pages

  • List SQL servers in a network
    ... Most of the solutions use SQLDMO to list all sql servers in the network like ... public static string[] GetAvailableSQLServers ... - this does not work with Windows XP (see SQLDMO documentation: ...
    (microsoft.public.dotnet.general)
  • MS03-031 Problems
    ... I manage several SQL Servers (2000 Enterprise Edition ... default instance and two or more named instances ... These servers run in a Windows NT4 ... I have found that if I configure the service accounts to ...
    (microsoft.public.sqlserver.security)
  • SQLDMO user stop server, windows user cant
    ... I have an application using SQLDMO and C#. ... will always use windows authentication to sql servers. ... problems is why does an account which is connected through ...
    (microsoft.public.sqlserver.programming)
  • RE: Cross domain authentication in SQL 2005
    ... SQL Server Windows authentication works fine when the two domains trust each ... My concern is that if we add the SQL servers to domain B, ...
    (microsoft.public.sqlserver.setup)
  • Re: connection string
    ... First I want to move all our SQL servers to Windows only mode. ... "Aaron Weiker" wrote: ... The same goes for Windows Authentication. ...
    (microsoft.public.sqlserver.programming)