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 Serve
r
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 serv
er
> 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 Ser
ver
> 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 serve
rs.
> Each server should be dedicated to a SINGLE role, or function.
> Lastly, this is a huge potential security issue. A SQL Server installatio
n,
> 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 wou
ld
> 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:
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment