Page 1 of 4

Is there a fix for the Services Privilleges problem with SQL

PostPosted: Mon May 26, 2008 7:41 am
by mrpinkmcpink
I noticed that a few other people with XP are getting the error message when stating services that you have insufficient privileges.

Has anyone been able to find a way round this yet?

Re: Is there a fix for the Services Privilleges problem with SQL

PostPosted: Tue May 27, 2008 1:42 am
by APerfect10
Still searching. I know how to resolve the issue with every WinXP version except Home. :(

-Derek

Re: Is there a fix for the Services Privilleges problem with SQL

PostPosted: Thu Jun 26, 2008 1:38 pm
by mrpinkmcpink
Any news on this? :-(

Re: Is there a fix for the Services Privilleges problem with SQL

PostPosted: Thu Jun 26, 2008 2:55 pm
by keggler
You've both probably got a permissions problem that another piece of software has set on a file folder or a registry key that is stopping the postgres service get going.

Get procmon (from sysinternals), restart the install, when it gets to the error, don't dismiss the dialog box, launch procmon, make a note of the postgres process ID (PID) from windows task manager, filter the procmon to this PID, scroll down to the bottom and look for any folders/registry keys this PID is trying to access.

The path and result columns in procmon should give you the clue as to the offending item...

If it turns out to be the path of a completely different app, this is the culprit that's holding the lock that's preventing postgres from starting - that app needs to be disabled, uninstalled or updated so it does not conflict with the postgres service.


susan

Re: Is there a fix for the Services Privilleges problem with SQL

PostPosted: Thu Jun 26, 2008 5:24 pm
by kraada
So far the known culprit list includes:
Norton Antivirus, F-Secure Antivirus, and Spampal
(edit: plus Internet Explorer 8 beta 2 IIRC)

If you are using one of these, please disable it and make sure it is not running in resident memory and attempt to reinstall and it may resolve your issue.

If you find out it was another program, please send me a PM and let me know I'm trying to keep a list of known offenders (and while I'm going to keep checking in on this thread, a PM is faster :)

Re: Is there a fix for the Services Privilleges problem with SQL

PostPosted: Thu Jun 26, 2008 5:39 pm
by bugsbunny
Note that any anti-virus should be disabled while installing postgres (or almost any other software - especially if it's a complex package) - and that the postgres folders should be excluded from antivirus checking even once your anti-virus is started again.

Re: Is there a fix for the Services Privilleges problem with SQL

PostPosted: Tue Aug 26, 2008 3:26 pm
by Lawrence
Unfortunately I have got the same problem. Interestingly in my first few sessions, it worked without problems and suddendly i got the above explained error. I tried all the hints posted in the FAQ but nothing helped so I cant use PT now :(

Any help for me?

I'm using Vista. And the imporant thing is that it already worked!

Thanks a lot!

Re: Is there a fix for the Services Privilleges problem with SQL

PostPosted: Tue Aug 26, 2008 6:13 pm
by WhiteRider
Have you installed anything else since?
Had an update to your anti-virus software, etc?

Re: Is there a fix for the Services Privilleges problem with SQL

PostPosted: Wed Aug 27, 2008 1:37 pm
by Lawrence
No

Re: Is there a fix for the Services Privilleges problem with SQL

PostPosted: Thu Aug 28, 2008 4:02 am
by WhiteRider
Did you do the search for postmaster.pid? Did the file exist?

highfalutin