Answered by:. Archived Forums. Getting started with SQL Server. Beginners just getting started - here's the place for help with simple questions. For installation or setup questions, refer to the Setup Forum.
Sign in to vote. This is a domain controller for a small branch that only will have around users. You must uninstall SQL Server before you change the host computer to a domain controller. You must uninstall SQL Server before you change the host computer to a domain member. Has anyone had any experience with this or have any recommendations for me? Thanks for your help! Monday, January 12, AM. SQL Server Setup will not block installation on a computer that is a domain controller , but the following limitations apply: On Windows Server , SQL Server services can run under a domain account or a local system account.
You cannot run SQL Server services on a domain controller under a local service account or a network service account. Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. Feedback will be sent to Microsoft: By pressing the submit button, your feedback will be used to improve Microsoft products and services. Privacy policy. Security is important for every product and every business.
By following simple best practices, you can avoid many security vulnerabilities. Security guidance for specific features is included in the reference articles for those features. Physical and logical isolation make up the foundation of SQL Server security. To enhance the physical security of the SQL Server installation, do the following tasks:.
Place computers that host a database in a physically protected location, ideally a locked computer room with monitored flood detection and fire detection or suppression systems. Install databases in the secure zone of the corporate intranet and do not connect your SQL Servers directly to the Internet.
Firewalls are important to help secure the SQL Server installation. Firewalls will be most effective if you follow these guidelines:. Put a firewall between the server and the Internet. Enable your firewall. If your firewall is turned off, turn it on. If your firewall is turned on, do not turn it off. To fully enjoy this site, please enable your JavaScript. When configuring your data environment and planning servers and installs, it is important to understand that Microsoft does not recommend that you install SQL Server on a Domain Controller.
While you technically CAN, there are some dangers involved that you should be aware of before you do this. This poses problems with running services that require higher access such as SQL Server Agent services. In short, you will be able to access data to a point but not have full Administrative functionality of SQL Server.
0コメント