Home | Site Map | Cisco How ToNet How To | Wireless |Search | Forums | Services | Donations | Careers | About Us | Contact Us|

How to install SQl on Domain Controller

Network Sharing , TCP/IP, Internet, Wireless, Exchange, IIS, ISA and Print

How to install SQl on Domain Controller

Postby chicagotech » Tue Jun 20, 2017 11:03 am

Microsoft doesn't recommends to install SQL Server on a domain controller and you cannot run SQL Server services on a domain controller under a local service account or a network service account. If you do want to install sql on a DC, you may recreate a new user account that will run the SQL services.

In our case, we created a account called sqlexpress. Then change the account from default network service account to sqlexpress when install/configure the sql server.
Image

Please refer to this article:
You may encounter problems when installing SQL Server on a domain ...
https://support.microsoft.com/.../you-m ... -sql-ser...
It is not recommended to install SQL Server on a domain controller. ... The SQL Server 2012 Best Practice Analyzer (SQL Server 2012 BPA) provides a rule to ...
Networking, Internet, Routing, VPN Troubleshooting on http://www.ChicagoTech.net
How to Setup Windows, Network, VPN & Remote Access on http://www.HowToNetworking.com
chicagotech
Site Admin
 
Posts: 6934
Joined: Mon Nov 27, 2006 1:24 pm
Location: Chicago USA

Return to Networking

Your Ad Here

Who is online

Users browsing this forum: Yahoo [Bot] and 9 guests