Stopping Server using 6.5 Enterprise Manager


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 9 of 9

Thread: Stopping Server using 6.5 Enterprise Manager

  1. #1
    Ted Young Guest

    Stopping Server using 6.5 Enterprise Manager


    I am new to SQL Server 6.5

    While trying to create a connection to a SQL Server DB I accidently stopped
    a Server using SQL Server Enterprise Manager 6.5.

    The DB Administrator was surprised I was able to do this since I was not
    set up with admin rights.

    It seems though ANY user of SQL Server Enterprise Manager can stop a server.

    Is there a way to disable this ability?

    Any ideas/suggestions would be greatly appreciated.

    Thanks!

    Ted

  2. #2
    DaveSatz Guest

    Re: Stopping Server using 6.5 Enterprise Manager

    this is all I found - point 3 might help
    http://www.mssqlserver.com/faq/gener...tstartstop.asp

    "Ted Young" <tedyoung@connecticare.com> wrote in message
    news:39fecf38$1@news.devx.com...
    >
    > I am new to SQL Server 6.5
    >
    > While trying to create a connection to a SQL Server DB I accidently

    stopped
    > a Server using SQL Server Enterprise Manager 6.5.
    >
    > The DB Administrator was surprised I was able to do this since I was not
    > set up with admin rights.
    >
    > It seems though ANY user of SQL Server Enterprise Manager can stop a

    server.
    >
    > Is there a way to disable this ability?
    >
    > Any ideas/suggestions would be greatly appreciated.
    >
    > Thanks!
    >
    > Ted




  3. #3
    Trayce Jordan Guest

    Re: Stopping Server using 6.5 Enterprise Manager

    If you are an NT administrator on the SQL server, then no matter how you
    connect to the SQL Server you will always have administrative privileges
    within SQL Server. I don't know why Microsoft does this, but it is by
    design. Perhaps you are either a Domain Admin, or at least a local
    Administrator on the SQL Server machine itself.

    Hope this helps.


    "Ted Young" <tedyoung@connecticare.com> wrote in message
    news:39fecf38$1@news.devx.com...
    >
    > I am new to SQL Server 6.5
    >
    > While trying to create a connection to a SQL Server DB I accidently

    stopped
    > a Server using SQL Server Enterprise Manager 6.5.
    >
    > The DB Administrator was surprised I was able to do this since I was not
    > set up with admin rights.
    >
    > It seems though ANY user of SQL Server Enterprise Manager can stop a

    server.
    >
    > Is there a way to disable this ability?
    >
    > Any ideas/suggestions would be greatly appreciated.
    >
    > Thanks!
    >
    > Ted




  4. #4
    Ted Young Guest

    Re: Stopping Server using 6.5 Enterprise Manager


    Thanks for getting back to me.

    You mention that perhaps I am either a Domain Admin or at least a local administrator
    on the SQL Server Machine itself.

    Is there a way to check this?

    I want to be able to create/modify tables and stored procedures but DO NOT
    WANT the ability to STOP a Server. What sort of rights should I have for
    this?

    Thanks!



    "Trayce Jordan" <trayce@jordanhome.net> wrote:
    >If you are an NT administrator on the SQL server, then no matter how you
    >connect to the SQL Server you will always have administrative privileges
    >within SQL Server. I don't know why Microsoft does this, but it is by
    >design. Perhaps you are either a Domain Admin, or at least a local
    >Administrator on the SQL Server machine itself.
    >
    >Hope this helps.
    >
    >
    >"Ted Young" <tedyoung@connecticare.com> wrote in message
    >news:39fecf38$1@news.devx.com...
    >>
    >> I am new to SQL Server 6.5
    >>
    >> While trying to create a connection to a SQL Server DB I accidently

    >stopped
    >> a Server using SQL Server Enterprise Manager 6.5.
    >>
    >> The DB Administrator was surprised I was able to do this since I was not
    >> set up with admin rights.
    >>
    >> It seems though ANY user of SQL Server Enterprise Manager can stop a

    >server.
    >>
    >> Is there a way to disable this ability?
    >>
    >> Any ideas/suggestions would be greatly appreciated.
    >>
    >> Thanks!
    >>
    >> Ted

    >
    >



  5. #5
    DaveSatz Guest

    Re: Stopping Server using 6.5 Enterprise Manager

    Is there a way to check this? Ask the the DB Administrator to check. They
    s/b able to check.

    What sort of rights should I have for this? you s/b aliased to dbo


    "Ted Young" <tedyoung@connecticare.com> wrote in message
    news:3a000eed$1@news.devx.com...
    >
    > Thanks for getting back to me.
    >
    > You mention that perhaps I am either a Domain Admin or at least a local

    administrator
    > on the SQL Server Machine itself.
    >
    > Is there a way to check this?
    >
    > I want to be able to create/modify tables and stored procedures but DO NOT
    > WANT the ability to STOP a Server. What sort of rights should I have for
    > this?
    >
    > Thanks!
    >
    >
    >
    > "Trayce Jordan" <trayce@jordanhome.net> wrote:
    > >If you are an NT administrator on the SQL server, then no matter how you
    > >connect to the SQL Server you will always have administrative privileges
    > >within SQL Server. I don't know why Microsoft does this, but it is by
    > >design. Perhaps you are either a Domain Admin, or at least a local
    > >Administrator on the SQL Server machine itself.
    > >
    > >Hope this helps.
    > >
    > >
    > >"Ted Young" <tedyoung@connecticare.com> wrote in message
    > >news:39fecf38$1@news.devx.com...
    > >>
    > >> I am new to SQL Server 6.5
    > >>
    > >> While trying to create a connection to a SQL Server DB I accidently

    > >stopped
    > >> a Server using SQL Server Enterprise Manager 6.5.
    > >>
    > >> The DB Administrator was surprised I was able to do this since I was

    not
    > >> set up with admin rights.
    > >>
    > >> It seems though ANY user of SQL Server Enterprise Manager can stop a

    > >server.
    > >>
    > >> Is there a way to disable this ability?
    > >>
    > >> Any ideas/suggestions would be greatly appreciated.
    > >>
    > >> Thanks!
    > >>
    > >> Ted

    > >
    > >

    >




  6. #6
    Michael Levy Guest

    Re: Stopping Server using 6.5 Enterprise Manager

    What type of authentication are you using to connect to the server? You
    wouldn't be using SQL Server authentication with the SA login would you?

    -Mike



  7. #7
    Ted Young Guest

    Re: Stopping Server using 6.5 Enterprise Manager


    I'm using NT authentication.

    From what I can gather it seems to be because SQL Server is running as a
    Service on my machine so therefore I can start/stop it like any other service.



    "Michael Levy" <michaell@gasullivan.com> wrote:
    >What type of authentication are you using to connect to the server? You
    >wouldn't be using SQL Server authentication with the SA login would you?
    >
    >-Mike
    >
    >



  8. #8
    Michael Levy Guest

    Re: Stopping Server using 6.5 Enterprise Manager

    If your NT login is a member of the Local Administrators group, then yes,
    you would be able to start and stop the service.

    -Mike
    --
    Michael Levy MCDBA, MCSD, MCT
    michaell@gasullivan.com



  9. #9
    Cedric McGee Guest

    Re: Stopping Server using 6.5 Enterprise Manager


    Trayce,
    There are a couple was you can stop SQL Server from the Enterprise Manager

    1. If that server is registered with the SA account.
    2. If you are at the local box and you are logged in as Administrator.

    They way to fix that problem
    1.Have Non-DBAs to login with there own accounts.
    2.Give users access to just what they need.








    "Trayce Jordan" <trayce@jordanhome.net> wrote:
    >If you are an NT administrator on the SQL server, then no matter how you
    >connect to the SQL Server you will always have administrative privileges
    >within SQL Server. I don't know why Microsoft does this, but it is by
    >design. Perhaps you are either a Domain Admin, or at least a local
    >Administrator on the SQL Server machine itself.
    >
    >Hope this helps.
    >
    >
    >"Ted Young" <tedyoung@connecticare.com> wrote in message
    >news:39fecf38$1@news.devx.com...
    >>
    >> I am new to SQL Server 6.5
    >>
    >> While trying to create a connection to a SQL Server DB I accidently

    >stopped
    >> a Server using SQL Server Enterprise Manager 6.5.
    >>
    >> The DB Administrator was surprised I was able to do this since I was not
    >> set up with admin rights.
    >>
    >> It seems though ANY user of SQL Server Enterprise Manager can stop a

    >server.
    >>
    >> Is there a way to disable this ability?
    >>
    >> Any ideas/suggestions would be greatly appreciated.
    >>
    >> Thanks!
    >>
    >> Ted

    >
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center