SQL Server 2005 management studio connect to SQL Server 2008

The SQL Server 2005 management studio need to be at least SP1 or above. Recommend to upgrade to SP3 (by running SQL Server 2005 SP3 installer) Because there are common issue fixed by CU5 for SP2.

You can use Cumulative update package 5 for SQL Server 2005 Service Pack 2 to upgrade SQL Server 2005 management studio to fix the connection problem of connect to SQL Server 2008.

Reference:

FIX: 50002151 946127 (http://support.microsoft.com/kb/946127/) FIX: You may experience problems when you use SQL Server Management Studio in SQL Server 2005 to connect to an instance of SQL Server 2008

Remark:

One of the problem of using 2005 management studio to connect to SQL Server 2008

http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/3fb29035-9f58-49ee-b6ef-6cd12a76bb59

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=335534&wa=wsignin1

SQL Server 2005 management studio connect to SQL Server 2008

How to use the SQLIOSim utility to simulate SQL Server activity on a disk subsystem

http://support.microsoft.com/kb/231619

How to use the SQLIOSim utility to simulate SQL Server activity on a disk subsystem

Creating SQL Server password protected backups and cleanup tasks

http://www.mssqltips.com/tip.asp?tip=1984&utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+MSSQLTips-LatestSqlServerTips+%28MSSQLTips+-+Latest+SQL+Server+Tips%29

Creating SQL Server password protected backups and cleanup tasks

SQL Server 2005/2008 Installation Checklist

SQL Server Setup Checklist Part 1: Before The Install

http://www.brentozar.com/archive/2008/03/sql-server-2005-setup-checklist-part-1-before-the-install/

SQL Server 2005 Setup Checklist Part 2: After The Install

http://www.brentozar.com/archive/2008/03/sql-server-2005-setup-checklist-part-2-after-the-install/

SQL Server 2005/2008 Installation Checklist

SharePoint & SQL Patches With KB Articles & Download Links

http://blogs.technet.com/mbiswas/archive/2010/03/23/sharepoint-sql-patches-with-kb-articles-download-link.aspx

SharePoint & SQL Patches With KB Articles & Download Links

(Freeware) SQL Heartbeat

Monitor activity on your server for FREE!

• Monitor server wait categories
• Monitor IO activity
• Check your current Cache Hits ratio
• Analyze your I/O system performance
• Get details about active processes
• Display locks and deadlocks

http://www.sqlsolutions.com/products/Heartbeat/index.html

(Freeware) SQL Heartbeat

Disk Partition Alignment Best Practices for SQL Server

Disk partition alignment is a powerful tool for improving SQL Server performance. Configuring optimal disk performance is often viewed as much art as science. A best practice that is essential yet often overlooked is disk partition alignment. Windows Server 2008 attempts to align new partitions out-of-the-box, yet disk partition alignment remains a relevant technology for partitions created on prior versions of Windows. This paper documents performance for aligned and nonaligned storage and why nonaligned partitions can negatively impact I/O performance; it explains disk partition alignment for storage configured on Windows Server 2003, including analysis, diagnosis, and remediation; and it describes how Windows Server 2008 attempts to remedy challenges related to partition alignment for new partitions yet does not correct the configuration of preexisting partitions. The following topics are also included: background information, implementation, vendor considerations, two essential correlations, valid starting partition offsets, and the simple protocol to align partitions, define file allocation unit size, and assign drive letters. It includes results from tests that show how partition alignment can affect performance for SQL Server 2008.

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=5b343389-f7c9-43d0-9892-ddcf55890529

Disk Partition Alignment Best Practices for SQL Server