Running SQL 2005 server service with 'limited privilage' account?

StuntMonkeh · 14 Jan 2009 at 20:38

I have some software that needs to run with windows admin privilages so that it can start an SQL 2005 database as it uses a database in conjunction with the program. The user of the PC needs to have 'limited user' privilages.

I have serached high and low and tried using the cacls command on the folders for the program and the MS SQL directories. I have also tried giving users permission to modify the keys in the registry for the program and SQL but when I try to start the program under a limited account it indicates to me that it was unable to start the SQL server service.

It works if I right click the program and run it under an admin account and type in the admin password but thats not much use as I need it to run without having to type the admin password everytime the user needs to run the program.

Any suggestions?

P.S. O/S is WinXP

Confused · 15 Jan 2009 at 09:31

Would it be better to just install SQL2005 as a service, and have the SQL Server service running all the time?

StuntMonkeh · 15 Jan 2009 at 09:49

Confused said:
Would it be better to just install SQL2005 as a service, and have the SQL Server service running all the time?

Yes if I knew what I was doing. When I installed the software which utilises it automatically installs SQL2005 with it so I'm not sure how to install it as a service.... Is it pretty straight forward?

Confused · 15 Jan 2009 at 10:43

Check in Computer Management\Services to see if MSSQLServer is listed, and is set to Automatic.

StuntMonkeh · 16 Jan 2009 at 20:35

Yes all services are running as automatic, what does the Log On As actually do, I played with some of the settings but it doesn't seem to make any difference.