GPO overriding local policy SQL service credentials

-

i have several networked domain pc's (win 7) running proprietary application requires use of sql express instances communicate central database.  i have local sql services (sql server (sqlexpress)) logging on account:  nt service\mssql$sqlexpress secure credentials particular database.  when freshly enter credentials service, start service , start application, works fine.  i can reboot, shut down (for short period, 30 minutes), log off etc.no problem  but when leave pc alone overnight (without use of application) or application freezes forcing pc shut down (for com port resets), user gets error due service not starting.  when check event viewer, says service failed start due logon failure.  when open services start service, error service not start due incorrect credentials.  i have re-enter credentials @ time service has popup says "the account nt service\mssql$sqlexpress has been granted log on service right." , fine (for while).  i've come conclusion there gpo setting changing credentials (for reasons yet unknown) overriding local policy settings , either obliterating password (because have change) or corrupting it.  help!!!  i have no idea such policy change or when see it.

grb

> gpo changing in local policy?  on local machine, it
> has nt service\mssql$sqlexpress.  cannot find local service in
> gpoto able enable in gpo.  or how make local
> policy on ride gpo?
 
local policy cannot override domain gpos :-) can create/edit
domain gpo, navigate security settings - local policies - user rights
assignment. edit "logon service" privilege , type
in above name (do not use "browse" button).
 
be aware user rights not cumulative - must have other
accounts need priv in winning gpo.
 
martin

mal ein gutes buch über gpos lesen?

no not evil, if know doing: or bad gpos?
, if bothers me - coke bottle design refreshment :))


Windows Server  >  Group Policy



Comments

Post a Comment

Popular posts from this blog

CRL Revocation always failed

-
hi all, i try configure radius server nps, somehow certificate authentication client failed with reason: reason = revocation function unable check revocation because revocation server offline. then check certificate client, certutil -f -urlfetch -verify client7.cer, result follow: issuer:     cn=entca     dc=intra     dc=domain     dc=co     dc=sg subject:     cn=computer.intra.domain.co.sg cert serial number: 1c5b00de000000000041 dwflags = ca_verify_flags_allow_untrusted_root (0x1) dwflags = ca_verify_flags_ignore_offline (0x2) dwflags = ca_verify_flags_full_chain_revocation (0x8) dwflags = ca_verify_flags_console_trace (0x20000000) dwflags = ca_verify_flags_dump_chain (0x40000000) chainflags = cert_chain_revocation_check_chain (0x20000000) hcce_local_machine cert_chain_policy_base -------- cert_chain_context -------- chaincontext.dwinfostatus = cert_trust_has_preferred_issuer (0x100) chaincontext.dwerrorstatus = cert_trust_revocation_sta
Read more

Failed to query the results of bpa xpath

-
Image
i have new server installed hyper v, iis , domain services roles on it.  i checking event log , see warning multiple times, idea how rid of it?? failed query results of bpa xpath: microsoft/windows/fileservices:$reports$\*\result.xml:/resultdatabase/result. error: device attached system not functioning., last error: system cannot find path specified.. follow me on twitter <<< levalencia blog <<< hi, similar issue discussed in forum: to rid of warnings: 1. go dashboard 2. click on add roles , features 3. click next "before begin step" 4. select "role based or feature based installation" , click next 5. select given server server pool , click next 6. in server roles step make sure following checked:   file , storage services > file , iscsi services > file server, click next 7.click next through rest of steps , install server role 8. rerun bpa scan described earlier for more information please refer following ms
Read more

0x300000d errors in Microsoft Remote Desktop client

-
we use rd connect home users office. @ server side remote desktop gateway configured on 2008r2 server. experience following:   for years worked fine, starting last year users apple macbook experienced connection errors after new version of microsoft remote desktop in app store , automatic update. after couple of weeks error disappaered when new updates released. since 6 8 weeks problem again. because don’t have macbook cannot reproduce problem.   starting couple of weeks samsung s6 experiencing problems, here version 8.1.37.135 installed, error displayed is: can’t connect tot remote pc because remote desktop gateway server temporaraily unavailable. try connecting later or contact network administrator assistance. error code  0x300000d   because has worked fine years expect issues on client can configuration error on gateway server.   who pin point real cause?   however, testing other rd gateway server works ok settings identically. hi ruud, as works rd
Read more