July 14, 2009 at 3:48 am
in our environment it is going to upgrade the windows version from 2000 to 2003.
so will it impact the sql server installed on it.Will All SQL editions runs on windows server 2003? What SQL service pack is required when we instal windows 2003?Please help me
July 14, 2009 at 7:05 am
Duplicate post. Avoid dupliation please.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 15, 2009 at 6:43 am
The biggest issue I remember when upgrading to Windows 2003 was with linked servers. Windows Server 2003 has tighter security, and it requires Kerberos authentication to allow multiple hops with linked servers in SQL connections using Windows logins. Other network resources may be affected.
You can still connect to your SQL server using NTLM authentication, but the Windows 2003 doesn't completly trust you. It will not connect to other servers using your Windows credentials without Kerberos authentication.
http://www.sqlservercentral.com/articles/Security/65169/
http://msdn.microsoft.com/en-us/library/ms189580(SQL.90).aspx
http://blogs.msdn.com/sql_protocols/archive/2006/08/10/694657.aspx
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply