Currently I am managing three production SQL Servers:
SQL 2000 on Windows 2003 with Workgroup security.
SQL 2005 on Windows 2003 with Workgroup security.
SQL 2005 on Windows 2003 with Domain/AD security.
We just spent the weekend moving all the PC's to a brand new Domain controller with a new Active Directory. The servers are next.
I have been surprised at how little is on the web about joining an existing SQL Server installation to a domain, presumably because most people start on one or never move to one. There is a little more on changing domains, but it still seems a little sketchy.
So sometime in the next week, all three servers will be members of the new domain. These servers use IIS, heavy Reporting Services, heavy Integration Services, and extensive cross server connectivity.
Hopefully I will have a good report, but either way I will let you know the good, bad, and ugly.
[Video] Office Hours in Osaka, Japan
3 days ago
No comments:
Post a Comment