Question about running a Domain Controller and SQL on same server ?? - tom

-

we have new dell windows 2008 server running sql 2008 workgroup.  runs accounting apps , considered lightly used.  nothing else other run acct software.  want know if ok use server backup domain controller, dns, dhcp, etc.  our network has approx 60 users , has 2 domain contollers both running windows server 2003 sp2.  wanting to move ad one of current 2003 servers new dell server running windows 2008 , decommission old server.      thanks - tom 

in past i dealing sql server 2005 express , windows server 2005. 1 of documents read in research:

http://support.microsoft.com/kb/910229

note following section. assume same applies sql server 2008, wrong:

2.10 installing sql server express on windows domain controller


security note recommend against running sql server express on domain controller.
possible install sql server express on windows domain controller; however, cannot run on windows server 2003 domain controller local service or network service. sql server service accounts should run windows domain user accounts. possible install sql server service accounts run local system, option not recommended.

not change role of server after install sql server express. example, if install sql server express on member server, not use dcpromo tool promote server domain controller. or, if install sql server express on domain controller, not use dcpromo demote server member server. changing role of server after install sql server express can result in loss of functionality , not supported.

i found article (again regarding w2k3) implies problem dacl's removed.

http://support.microsoft.com/kb/929665

i should add if sql server database not accessed client computers, option install app , sql server on workstation, , remove server before running dcpromo.

richard mueller

mvp adsi


Windows Server  >  Directory Services



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 = ce...
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 foll...
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....
Read more