Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
edimen
Starting Member
12 Posts |
 Posted - 2011-03-25 : 12:07:41
|
| Hello,We have several SQL 2005 servers in an NT4 domain that is being upgraded to Windows 2003 AD domain. Authentication mode is mixed, SQL service account is a domain account. Production application access to most databases also uses a few domain accounts. Initial W2K3 domain functional level will be 'Windows 2003 Interim' for a while, and new domain controllers will be running as NT4 Emulators. Eventually it will be raised to 'Windows 2003' level and NT4 Emulation removed. My questions are:- Can the upgrade affect SQL 2005 servers in any way, and if anything needs to be done on them before/during/after the domain upgrade?- Any concerns/changes that are needed for when the domain functional level is raised to Windows 2003?Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2011-03-25 : 12:13:22
|
| 1. Sure it can be affect you, but it shouldn't if they do things properly. We've upgraded the OS on the DC's in the past without even noticing anything on the SQL side. I've been at my company 9 years, and they've upgraded twice in a mission critical domain (from 2000 to 2003 and then 2003 to 2008) and we didn't even realize it until weeks after the work had been completed. It was transparent to the database servers. Why aren't they upgrading to 2008? 2003 is soooo old at this point, although any upgrade from NT4 will be an improvement.2. No.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
edimen
Starting Member
12 Posts |
Posted - 2011-03-25 : 13:44:32
|
| Tara, thanks for replying right away!Eventually it will be upgraded to 2008, 2003 is the first step...Going from NT4 to any W2x is a big change (at least with NTLM to Kerberos, and SAM to AD), not sure if SQL may complain in any way, if authentication methods may possibly need to be changed or any other settings, etc.Thanks again! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
SQL 2005 servers - NT4 domain upgrade