Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  start/stop SQL service by non-admin account?

Author  Topic  cgmoore Starting Member 1 Post Posted - 2005-05-16 : 14:17:57 I have a .Net windows forms app that uses an MSDE database for the backend. I'd like the SQL service to run only when my app is running, so I don't leave a big resource hog running on the user's machines all the time. I can start and stop the service programmatically with no problems, as long as the user on the desktop is a member of the local administrators group. If they are not, then I cannot control the service. Does anyone know a way around this? I tried looking at service accounts and came up confused and empty. Are my concerns about hogging resources overblown? Thanks, Gerald