473,695 Members | 2,405 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Service stop/start/restart questions 2005 SP2

aj
A few service stop/start/restart questions on SQL Server 2005 SP2, which
I'll call SQLS.

It looks as if there are *potentially* 6 ways to start/stop SQLS
Services like the engine itself, integration services, reporting
service, Agent..

-SQLS Configuration Manager
-SQLS Surface Area Configuration (for Services and Connections)
-Mgmt Studio Local (on server)
-Mgmt Studio Remote (on client)
-Windows Control Panel->Admin Tools->Services
-Command Prompt (ala net start MSSQLSERVER)

By policy, I am /not/ Administrator on the server. But I am SysAdmin
role in SQLS. I have had various levels of success starting/stopping
services in the ways listed above. In some I get Access denied, and in
others I get no msg and it simply doesn't work.

Is there some special non-Admin OS group I need to be in to start/stop
services? Is this handled differently in the different interfaces
listed above?

It seems like my best success for starting/stopping the engine and Agent
is in /local/ Mgmt Studio, but /not/ remote Mgmt Studio - the options
are greyed out on a remote client. Is this by design? Is it a SQLS
bug?

I'm sure I'm not the only SQLS DBA who does not have Admin rights on his
server who wants to start/stop services. Generally speaking, how is
this intended to work?

Any help appreciated.

Allen Jantzen
A freshly minted DQLS DBA
Oct 15 '07 #1
1 5658
aj (ro****@mcdonal ds.com) writes:
It looks as if there are *potentially* 6 ways to start/stop SQLS
Services like the engine itself, integration services, reporting
service, Agent..

-SQLS Configuration Manager
-SQLS Surface Area Configuration (for Services and Connections)
-Mgmt Studio Local (on server)
-Mgmt Studio Remote (on client)
-Windows Control Panel->Admin Tools->Services
-Command Prompt (ala net start MSSQLSERVER)
There is a recommendation that you should not start/stop SQL Server
through the Services applet, although I don't know exactly what's
behind it. You are supposed to use any of the SQL tools. (So that
rules out NET START MSSQLSERVER as well.)

By the way, there is a seventh way: you can start SQL Server directly
from the command line. Then again, then it does not run as a service.
Is there some special non-Admin OS group I need to be in to start/stop
services? Is this handled differently in the different interfaces
listed above?
That's more a Windows question, and I don't know the answer.
It seems like my best success for starting/stopping the engine and Agent
is in /local/ Mgmt Studio, but /not/ remote Mgmt Studio - the options
are greyed out on a remote client. Is this by design? Is it a SQLS
bug?
I guess it's by design. Overall, I don't know if you can start and
stop Windows services remotely.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Oct 15 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
2765
by: Russ McDaniel | last post by:
Originally posted to microsoft.public.dotnet.distributed_apps with no response. Reposted here with additional thoughts. --- Hello, I'm writing a Windows service which performs some potentially long-running, uninterruptable processes. When the service starts, I create a separate worker thread to perform the work so as to not block the service control manager upon startup. The design quandry I'm running into though is how best
4
2385
by: Mrinal Kamboj | last post by:
Hi , Doubt may be bit trivial , but i wanted to know , what are the exact benefits derived while we run a background process as an NT service in windows , we can as well achieve the functionality using standalone exe , which will keep on running in a loop and do the job till been messaged to stop . Essentially , i want the key advantages of implementing process daemons as an NT Service in windows .
14
25123
by: iceman | last post by:
Hello, I have a windows service. I want to restart it after every 24 hour. Is it possible to restart the service programmatically(from the service itself) using the sercvice controller object? Or should i chose some other approach? Any ideas? Thanx for all help. - Iceman
6
3801
by: Leonardo Curros | last post by:
Hello, I would like to know what's the best way to restart one service. I would like to do it from the service itself. Is this possible? I try it with ServiceController.stop() ServiceController.WaitForStatus(ServiceControllerStatus.Stopped) ServiceController.start() but doesn´t works. It seems waitforstatus instruction is the last
3
2604
by: zxo102 | last post by:
Hi there, I have a python application (many python scripts) and I start the application like this python myServer.py start in window. It is running in dos window. Now I would like to put it in background as NT service. I got a example code: SmallestService.py from chapter 18 of the book "Python Programming On Win32" by Mark Hammond etc. The code is as follows and runs well as an NT service.
4
3177
by: kkt49 | last post by:
# vim: et sw=4 ts=8 sts from wxPython.wx import * import sys, os, time import pywintypes import win32serviceutil import win32service import win32event import win32process
7
7229
by: shai | last post by:
I am working at .net 1.1, writing in c#. I have windows service with a COM object. Every unexpected time The COM object throw an error that make my service get stuck (do not respond). I can catch this error. I want to restart my windows service every time the COM object throws an error. I use System.ServiceProcess.ServiceController to stop and start my service. But there is one thing I do not understand:
6
9341
by: sergio.calleja | last post by:
Hi Everybody, i need to restart a windows service made with c# when an fixed event is raised. So to test it, I've added a servicecontroller to my service, and in the creation method, i've created a new thread to try to stop it. This is my code: public Service1() { // This call is required by the Windows.Forms Component Designer.
4
21737
by: carson | last post by:
I have written two windows services: - service A does some crunching of local data files and uploads them to a central processing computer via http. - service B monitors a manifest file on a webserver to see if service A needs to be updated. What service B does if it sees their is an update for service A is to download a new copy of the service A executable, stop service A, replace the executable with the new copy, and start service B...
0
8586
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9137
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9004
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8864
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
4351
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4592
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3025
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2289
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
1986
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.