SQL Server 2005 SP3

  • Not sure what you mean about support for RC0 we are installing SQL 2005 EE x64 on a Windows 2008 EE cluster....

    More trials and tribulations...

    After installing 2005 EE x64 (again) with SP2 + SP2 CU8 AND Visual Studio 2005 SP1 + hotfix we are still experiencing the Database Mail (Activation Failure) and Maintenance Plan issues. A case with Micorosft will be opened next week to determine if these issues are related to this particualr SQL install on Windows 2008.

  • Hey I have nothing better to do than download CU's

  • Good voting everyone. Microsoft told me today that SP3 is due August patch tuesday, provided there are no unexpected bugs.

  • That would be nice, but a significant departure from what I got just a few months ago which was late 4th quarter. They weren't going to really start working it until the large number of resources allocated to getting 2008 RTM were cut loose after that rollout. Whenever it IS released however, I sure hope it is BULLET PROOF!! Getting a bit tired of update failures/issues...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • when SQL Server 2008 SP 1 launched. 🙂

    Abhijit - http://abhijitmore.wordpress.com

  • Not sure what you mean about support for RC0 we are installing SQL 2005 EE x64 on a Windows 2008 EE cluster....

    More trials and tribulations...

    After installing 2005 EE x64 (again) with SP2 + SP2 CU8 AND Visual Studio 2005 SP1 + hotfix we are still experiencing the Database Mail (Activation Failure) and Maintenance Plan issues. A case with Microsoft will be opened next week to determine if these issues are related to this particualr SQL install on Windows 2008.

    Just wanted to check on the status of your case with microsoft since we are considering setting up something similar next month

    thanks

    David Weil

  • I finally had all my issues resolved with SQL 2005 on a Windows 2008 Cluster.

    There were several issues:

    1) Issues with SSPI handshakes when the service account was trying to use Kerberos over TCP/IP registering SPN(s) when bringing SQL service online in 'Failover Cluster Management'

    This was resolved by granting write and read access for the SQL startup account to add and remove SPN(s) (Server Principal Names) from AD.

    2) Problems with SP2 update. The service pack would install properly but when creating a maintenance plan it would fail.

    This was resolved by manually running the query sysdbupg.sql located in the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install folder.

    3) Problems with Database Mail using Basic Authentication.

    Remove mail profile and account. Add the Mail profile and account back using the option 'Windows Authentication using Database Engine Service Credentials'.

    4) Removal of the BUILTIN\Administrators will cause the SQL Service not to start via Failover Cluster Management even though the SQL Startup account is a system admin on the SQL Server.

    This was resolved by adding NT AUTHORITY\SYSTEM as a 'sysadmin' to SQL Server.

    I have come up with a standard build sheet for installing SQL 2005 on Windows 2008 Cluster: (This only works if you have granted your SQL startup accounts the ability to read and write SPN(s) in Active Directory).

    1) Verify Cryptographic service, Remote registry, & Task Schedule are running on both nodes.

    2) Verify no connections on passive node.

    3) Configure Network Transactions for local MSDTC on each node. (http://technet2.microsoft.com/windowsserver2008/en/library/4532d3d5-a406-492e-9e74-daa70c6591461033.mspx?mfr=true)

    4) Create 'Empty Service or Application' in Failover Cluster Management console rename to SQL Virtual name.

    5) Assign appropriate LUN(s) to newly created Service/Application.

    6) Install SQL Server 2005 (RTM).

    7) Install SQL Service Pack 2.

    8) Post SP 2 Hotfix (Build 3050).

    9) Install Visual Studio SP1.

    10) Visual Studio Post SP1 Hotfix.

    11) Install SQL Performance Dashboard add-in.

    12) Add SQL Startup account to 'Lock Pages in Memory' Local Security Policy.

    13) Add NT AUTHORITY\SYSTEM as a 'sysadmin' to SQL Server.

    14) Remove Builtin\Administrators from SQL Server.

    Microsoft provides a great webcast on the topic "Microsoft SQL Server 2005 Failover Clustering on Windows Server 2008"

    http://support.microsoft.com/kb/953170/en-us

  • i think we should have SP3 before release of 2008.

    Regards

    Manoj

  • So, when is August patch Tuesday? Tomorrow, August 25th, is the last chance. Has anyone heard any news about SP3 release? Maybe I missed it while on vacation?

  • Keep it going....great work 🙂

  • SP3 is being worked on, no dates yet, but the last guidance in June or July was that it would be out before 12/31/08

  • Yes.. thats what I heard too. SP3 will be out sometime in December this year, definitely before the end of the year.

  • Lets Hope For December

  • sql2008 is sql2005 sp3

  • danschl (10/17/2008)


    sql2008 is sql2005 sp3

    There definitely is a SP3 for SQL 2005 on its way

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 15 posts - 46 through 60 (of 178 total)

You must be logged in to reply to this topic. Login to reply