Kath Pelletti
kp at sdsonline.net
Thu Apr 20 05:23:21 CDT 2006
Not having tried it,thanks for the warning... Kath ----- Original Message ----- From: Michael Maddison To: Access Developers discussion and problem solving Sent: Thursday, April 20, 2006 6:01 PM Subject: Re: [AccessD] SQL Server 2005 SP1 released today Take care people... >From another list... First impression ... this is the worst sql service pack for years. After installing and testing the CTP-SP1 build 2040 on 4 development and test servers for 4 weeks with no errors, we decided to test the official SP1 build 2047. http://www.microsoft.com/downloads/details.aspx?FamilyID=cb6c71ea-d649-4 7ff-9176-e7cac58fd4bc&DisplayLang=en The details: Server A (32bit Win2003 and 32bit SQL2005): Installation runs smoothly, no errors on first sight. But then discovered, that sql is still reporting to be build 2040 (CTP-SP1) and we believe it, because it's the only test server which is fully functional (Integration Services) at the moment. But installer said SP1 Installation successful ... ??? Server B (32bit Win2000 and 32bit SQL2005): Aborted with Client Components installation. Found out that 630MB free on drive C isn't enough. After clearing 800MB on C, installation runs with no errors. After rebooting can't connect to Integration Services (HRESULT: 0x8002801D, TYPE_E_LIBNOTREGISTERED Microsoft.SqlServer.DTSRuntimeWrap) :-( Server C (64bit Win2003 and 64bit SQL2005): First installation aborted with a failure on Integration Services, second try after a reboot says everything ok, no errors. But after a second reboot Integration Services service can't start. (The SQL Server Integration Services service failed to start due to the following error: The service did not respond to the start or control request in a timely fashion.) :-( Server D (32bit Win2003 and 32bit SQL2005): Same as Server B, aborted with Client Components installation. But even after the successful second install has now a mixture installation with SP1 (build 2047) and CTP-SP1 (build 2040). After rebooting can't connect to Integration Services (HRESULT: 0x8002801D, TYPE_E_LIBNOTREGISTERED Microsoft.SqlServer.DTSRuntimeWrap) :-( Well, after this experience we will stay on CTP-SP1 (build 2040) until there's a usable SP1. Does anybody else tried the SP1 already? What are your experiences? Peter cheers Michael M -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bobby Heid Sent: Thursday, 20 April 2006 3:35 AM To: 'Access Developers discussion and problem solving'; ACCESS-L at PEACH.EASE.LSOFT.COM Subject: [AccessD] SQL Server 2005 SP1 released today SQL Server 2005 SP1 The SQL Server 2005 SP1 is finally out and what interests me the most is the management studio for SQL Express which is finally released not as a CTP. Here are some links: SP1 Readme http://tinyurl.com/n6fca http://www.microsoft.com/downloads/details.aspx?FamilyID=b0167129-5ac8-4 9c4- 90bd-0493f3773081&DisplayLang=en SP1 http://tinyurl.com/qnkzb http://www.microsoft.com/downloads/details.aspx?FamilyID=cb6c71ea-d649-4 7ff- 9176-e7cac58fd4bc&DisplayLang=en Express Edition http://tinyurl.com/syv6w http://www.microsoft.com/downloads/details.aspx?FamilyID=11350b1f-8f44-4 db6- b542-4a4b869c2ff1&DisplayLang=en (Note: this is the full download of Express @ the SP1 level. If you want to patch Express, download just SP1) Express Edition with Advanced Services http://tinyurl.com/q29o5 http://www.microsoft.com/downloads/details.aspx?FamilyID=4c6ba9fd-319a-4 887- bc75-3b02b5e48a40&DisplayLang=en Management Studio Express http://tinyurl.com/mw5lz http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4 e3d- 94b8-5a0f62bf7796&DisplayLang=en Express Edition Toolkit http://tinyurl.com/oohdk http://www.microsoft.com/downloads/details.aspx?FamilyID=3c856b93-369f-4 c6f- 9357-c35384179543&DisplayLang=en -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com