Is there a fix for the Services Privilleges problem with SQL

[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?

[APerfect10]

Still searching. I know how to resolve the issue with every WinXP version except Home.

-Derek

[mrpinkmcpink]

Any news on this?

[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

[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

[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.

[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!

[WhiteRider]

Have you installed anything else since?
Had an update to your anti-virus software, etc?

[Lawrence]

No

[WhiteRider]

Did you do the search for postmaster.pid? Did the file exist?