Category: SQL

Installing SQL Server 2005 on Windows Server 2008

by ucinfo, posted in Flaphead, SQL, Windows

Just a reference to my me as I have forgotten it too many times ;-)

http://blogs.technet.com/seanearp/archive/2008/07/01/installing-sql-server-2005-on-windows-server-2008.aspx and http://support.microsoft.com/kb/920201

If you want to install SQL bits, including reporting services you need some IIS 7.0 components that maybe missing if you just all the web server role.

Component Folder
Static Content Common HTTP Features
Default Document Common HTTP Features
HTTP Redirection Common HTTP Features
Directory Browsing Common HTTP Features
ASP.Net Application Development
ISAPI Extension Application Development
ISAPI Filters Application Development
Windows Authentication Security
IIS Metabase Management Tools
IIS 6 WMI Management Tools

Microsoft Releases SQL Server 2005 Service Pack 2

by ucinfo, posted in Flaphead, SQL

SQL? I must me mad!

Source: http://www.microsoft.com/presspass/press/2007/Feb07/02-19SQLSP2PR.mspx

REDMOND, Wash. — Feb. 19, 2007 — Microsoft Corp. today released Microsoft® SQL Server™ 2005 SP2, an update to its award-winning data management and analysis platform. Customers can now take advantage of enhancements in the familiar and easy-to-use Windows Vista™ operating system and 2007 Microsoft Office system to easily connect and integrate with the power, security and reliability of SQL Server 2005. In addition, Microsoft announced that it is expanding virtualization use rights to allow unlimited virtual instances on servers that are fully licensed for SQL Server 2005 Enterprise Edition. For customers who want maximum flexibility in their use of virtualization technology, now or in the future, SQL Server 2005 Enterprise Edition is the ideal choice.