Friday, March 23, 2012

Installing SQL server on a domain controller?

Hi guys,
I'm currently working on my MCDBA and I happen to be using the Microsoft
Press edition. The book states the server that you plan to intall SQL server
should be configured as a domain controller. From reading and listening to
outside experts, I've always thought that the server should be configured as
just a member server. Can someone clear this up for me?
That's an old copy you are reading. DO NOT INSTALL ON A DOMAIN CONTROLLER.
A Domain Controller has too much network traffic to compete with a SQL Server
installation. You will reduce the responsiveness of both. Moreover, what
makes a DBMS efficient is the exclusive use of large memory. This makes a
DBMS system unusfull as any other cohosted application system. The power of
distributed computing is the dedication of function accross multiple servers.
Each server should be dedicated to a SINGLE role, or function.
Lastly, this is a huge potential security issue. A SQL Server installation,
of necessity, controls most of the resources on the server it is installed
on. If this is a domain controller, this means the security database. If
this installation was compromised, this would mean your entire network would
be also.
Sincerely,
Anthony Thomas
"Charles" wrote:

> Hi guys,
> I'm currently working on my MCDBA and I happen to be using the Microsoft
> Press edition. The book states the server that you plan to intall SQL server
> should be configured as a domain controller. From reading and listening to
> outside experts, I've always thought that the server should be configured as
> just a member server. Can someone clear this up for me?
|||thanks!
"AnthonyThomas" wrote:
[vbcol=seagreen]
> That's an old copy you are reading. DO NOT INSTALL ON A DOMAIN CONTROLLER.
> A Domain Controller has too much network traffic to compete with a SQL Server
> installation. You will reduce the responsiveness of both. Moreover, what
> makes a DBMS efficient is the exclusive use of large memory. This makes a
> DBMS system unusfull as any other cohosted application system. The power of
> distributed computing is the dedication of function accross multiple servers.
> Each server should be dedicated to a SINGLE role, or function.
> Lastly, this is a huge potential security issue. A SQL Server installation,
> of necessity, controls most of the resources on the server it is installed
> on. If this is a domain controller, this means the security database. If
> this installation was compromised, this would mean your entire network would
> be also.
> Sincerely,
>
> Anthony Thomas
>
> "Charles" wrote:
|||http://giuciao.altervista.org/free_books.html
"Charles" <Charles@.discussions.microsoft.com> wrote in message news:<86D792B6-668D-4027-A953-945755BCB1DE@.microsoft.com>...[vbcol=seagreen]
> thanks!
> "AnthonyThomas" wrote:

No comments:

Post a Comment