July 5, 2008 at 10:03 am
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.
July 7, 2008 at 12:35 pm
Hey I have nothing better to do than download CU's
July 21, 2008 at 12:04 pm
Good voting everyone. Microsoft told me today that SP3 is due August patch tuesday, provided there are no unexpected bugs.
July 21, 2008 at 12:29 pm
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
August 7, 2008 at 2:48 am
when SQL Server 2008 SP 1 launched. 🙂
Abhijit - http://abhijitmore.wordpress.com
August 8, 2008 at 8:35 am
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
August 8, 2008 at 10:02 am
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"
August 22, 2008 at 3:48 am
i think we should have SP3 before release of 2008.
Regards
Manoj
August 25, 2008 at 10:43 am
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?
August 28, 2008 at 9:21 am
Keep it going....great work 🙂
August 28, 2008 at 10:34 am
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
September 30, 2008 at 8:19 am
Yes.. thats what I heard too. SP3 will be out sometime in December this year, definitely before the end of the year.
September 30, 2008 at 10:06 pm
Lets Hope For December
October 17, 2008 at 2:55 pm
sql2008 is sql2005 sp3
October 17, 2008 at 3:57 pm
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
Viewing 15 posts - 46 through 60 (of 178 total)
You must be logged in to reply to this topic. Login to reply