Sign in
 
HomeWindows Server 2012Windows Server 2008 R2Windows Server 2003LibraryForums
Windows Server TechCenter >
> 
> 
DBMS on a Primary Domain Controller

Answered DBMS on a Primary Domain Controller

  • Wednesday, March 06, 2013 4:38 PM
     
     
    Sign In to Vote
    0

    Hi everybody,

    I know that is not reccomended to install SQL Server on a Primary domain controller but what about compatibility with other DBMS like PostgreSQL, Pervasive or Firebird?

    Are there any issues with Primary domain conroller role and these or other DMBS ? I'm referring particular on a PDC over Windows Server 2008 R2.

    Many thanks!

     

All Replies

  • Wednesday, March 06, 2013 5:11 PM
     
     Answered
    Sign In to Vote
    0

    Hello,

    on a Dc should NEVER run anything else the AD/DNS/GC and sometimes, if not to avoid DHCP, THAT'S it. A DC is not to use as application server or anything else. In case the server must be restored from backup this may result in a crash from the application or the application may not be to restore that way the DC requires.

    Applications or other server roles have NOT to run on a DC!!!

    Best regards

    Meinolf Weber
    MVP, MCP, MCTS
    Microsoft MVP - Directory Services
    My Blog: http://msmvps.com/blogs/mweber/

    Disclaimer: This posting is provided AS IS with no warranties or guarantees and confers no rights.

    • Marked As Answer by Tecnologie Snc Monday, March 11, 2013 8:14 AM
    •  
     
  • Monday, March 11, 2013 8:17 AM
     
     
    Sign In to Vote
    0

    Thank you very much for your reply!

    I understand issue with security and performance but, just for curiosity, why the applications should not work properly after a server restore from backup?

    Thank you!

     
  • Monday, March 11, 2013 10:32 AM
     
     Answered
    Sign In to Vote
    0

    Hello,

    on a DC the restore MUST be AD aware and it may result in problems with installed applications. Of course the server can run correct after restore but to prevent any kind of problem on other databases(especially if the database requires username/password which may be reset to an older one) a DC should always run for its main services.

    Best regards

    Meinolf Weber
    MVP, MCP, MCTS
    Microsoft MVP - Directory Services
    My Blog: http://msmvps.com/blogs/mweber/

    Disclaimer: This posting is provided AS IS with no warranties or guarantees and confers no rights.