upgrade domain w/SQL servers to AD

  • Thread starter Thread starter Laura
  • Start date Start date
L

Laura

We are preparing to upgrade our NT4 domain, containing several
very important SQL servers, to AD. Having heard a few horror
stories, I am seeking information on how these servers will
interact with (and be acted upon by) the AD tree, with a focus on
discovering any truly potential problems ahead of time. I have
not been able to find the information I seek. Is this because
the horror stories are bogus, or because I'm looking in the wrong
places???

I understand AD integrates with the SQL installs??? If this is
accurate information, is this automatic, or optional???
 
While you can publish a sql server instance to AD, you don't _have_ to. I
personally don't. We have 5 SQL Server instances and 4 MSDE instances.
Your SQL install won't get hosed. There is no SQL forrest prep tool. You
of course will have good backups of your SQL data because you are a good
admin. And a very cool thing about SQL Server is it installs extremely
easily and restores properly backed-up databases very easily. Incidentally,
is your SQL properly service packed?

http://www.sqlsecurity.com/DesktopDefault.aspx?tabindex=3&tabid=4

hth
Eric
 
Eric said:
While you can publish a sql server instance to AD, you don't _have_ to. I
personally don't. We have 5 SQL Server instances and 4 MSDE instances.
Your SQL install won't get hosed. There is no SQL forrest prep tool. You
of course will have good backups of your SQL data because you are a good
admin.
Click to expand...

Thanks!!! This is very reasuring. So those horror stories
(first hand account from a reliable source) were likely the
result of the SQL servers being published to AD? and that is
what resulted in the sa user having no rights to it's own files,
not the AD upgrade itself? We are a small (approx 200 users)
primarily Novell shop. This domain exists solely to accomodate
these and other app servers, and to provide any needed access.

And a very cool thing about SQL Server is it installs extremely
easily and restores properly backed-up databases very easily. Incidentally,
is your SQL properly service packed?
Click to expand...

Knowing the people responsible for service packing the servers, I
am certain they are service packed/patched to the hilt. Patch
levels will of course be double-checked before the upgrade.
 
Back
Top