"Tom Murphy" <temurphy@nospam.demisoft.com> wrote in message
news:OX1aIcCLHHA.5016@TK2MSFTNGP04.phx.gbl...
> SSIS won't start, and  this causes the installation of Team Foundation
> Server RTM to fail.
> I'm getting pretty desperate and have found no info about this on any of
> several web searches.
>
> Sql Server 2005 SP 2 is running on Windows Server 2003, SP 1.
> When I installed SQL Server 2005 SP 2, all installations succeeded
> including
> SSIS.
>
> When I try to start SSIS, it fails with a message that it started and then
> stopped immediately.
>
> I have tried running the service under the NETWORK SERVICE account, and
> also
> with several domain accounts, all with local Admin privs on the server and
> also with Domain Admin group membership. These make no difference.
>
> In the Application event log, I have an error with the following text:
> Event Type: Error
> Event Source: SQLISService
> Event Category: Service Control
> Event ID: 260
> Date:  12/29/2006
> Time:  4:20:21 PM
> User:  N/A
> Computer: <servername>
> Description:
> Microsoft SSIS Service failed to start.
> Error: Method 'GetTaskInfos' in type
> 'Microsoft.SqlServer.Dts.Server.DtsServer'
> from assembly 'MsDtsSrvr, Version=9.0.242.0, Culture=neutral,
> PublicKeyToken=89845dcd8080cc91'
> does not have an implementation.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
> [Clicking the link leads to a page apologizing for the absence of any KB
> info or explanation.]
>
>
>
> ALSO:
>
> SQL Server 2005 Management studio produces an error when trying to
> establish
> an Integration Services connection, with the following detail:
>
>
> ===================================
>
> Cannot connect to <servername>.
>
> ===================================
>
> Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
>
> ------------------------------
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
>
> ------------------------------
> Program Location:
>
>   at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object
> connectionInfo, Request request)
>   at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo
> ci, IServerType server)
>   at
> Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
>
> ===================================
>
> Connect to SSIS Service on machine "<servername>" failed:
> Server execution failed
> .
>
>
> ------------------------------
> Program Location:
>
>   at Microsoft.SqlServer.Dts.Runtime.Application.GetServerInfo(String
> server, String& serverVersion)
>   at Microsoft.SqlServer.Dts.SmoEnum.DTSEnum.GetData(EnumResult erParent)
>   at Microsoft.SqlServer.Management.Smo.Environment.GetData()
>   at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req,
> Object ci)
>   at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object
> connectionInfo, Request request)
>   at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object
> connectionInfo, Request request)
>
> ===================================
>
> Connect to SSIS Service on machine "<servername>" failed:
> Server execution failed
> .
>
>
> ------------------------------
> Program Location:
>
>   at
> Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.GetServerInfo(String
> bstrMachineName, String& serverVersion)
>   at Microsoft.SqlServer.Dts.Runtime.Application.GetServerInfo(String
> server, String& serverVersion)
>
>
>
>

"Mark Yudkin" <DoNotContac***@boingboing.org> wrote in message
news:Or4H3aaLHHA.5016@TK2MSFTNGP04.phx.gbl...
> SQL Server 2005 SP2 is currently a "Community Technology Preview". Report
> your problems using the CTP channels so that MS can address the issues in
> time for the official SP2 release. Contact information is towards the
> bottom of http://www.microsoft.com/sql/ctp.mspx.
>
> I do not understand why you're getting desparate though. SP2 CTP is for
> testing purposes only, so you can hardly have applied it to a critical
> system.
>
> "Tom Murphy" <temurphy@nospam.demisoft.com> wrote in message
> news:OX1aIcCLHHA.5016@TK2MSFTNGP04.phx.gbl...
>> SSIS won't start, and  this causes the installation of Team Foundation
>> Server RTM to fail.
>> I'm getting pretty desperate and have found no info about this on any of
>> several web searches.
>>
>> Sql Server 2005 SP 2 is running on Windows Server 2003, SP 1.
>> When I installed SQL Server 2005 SP 2, all installations succeeded
>> including
>> SSIS.
>>
>> When I try to start SSIS, it fails with a message that it started and
>> then stopped immediately.
>>
>> I have tried running the service under the NETWORK SERVICE account, and
>> also
>> with several domain accounts, all with local Admin privs on the server
>> and
>> also with Domain Admin group membership. These make no difference.
>>
>> In the Application event log, I have an error with the following text:
>> Event Type: Error
>> Event Source: SQLISService
>> Event Category: Service Control
>> Event ID: 260
>> Date:  12/29/2006
>> Time:  4:20:21 PM
>> User:  N/A
>> Computer: <servername>
>> Description:
>> Microsoft SSIS Service failed to start.
>> Error: Method 'GetTaskInfos' in type
>> 'Microsoft.SqlServer.Dts.Server.DtsServer'
>> from assembly 'MsDtsSrvr, Version=9.0.242.0, Culture=neutral,
>> PublicKeyToken=89845dcd8080cc91'
>> does not have an implementation.
>> For more information, see Help and Support Center at
>> http://go.microsoft.com/fwlink/events.asp.
>>
>> [Clicking the link leads to a page apologizing for the absence of any KB
>> info or explanation.]
>>
>>
>>
>> ALSO:
>>
>> SQL Server 2005 Management studio produces an error when trying to
>> establish
>> an Integration Services connection, with the following detail:
>>
>>
>> ===================================
>>
>> Cannot connect to <servername>.
>>
>> ===================================
>>
>> Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
>>
>> ------------------------------
>> For help, click:
>> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
>>
>> ------------------------------
>> Program Location:
>>
>>   at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object
>> connectionInfo, Request request)
>>   at
>> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo
>> ci, IServerType server)
>>   at
>> Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
>>
>> ===================================
>>
>> Connect to SSIS Service on machine "<servername>" failed:
>> Server execution failed
>> .
>>
>>
>> ------------------------------
>> Program Location:
>>
>>   at Microsoft.SqlServer.Dts.Runtime.Application.GetServerInfo(String
>> server, String& serverVersion)
>>   at Microsoft.SqlServer.Dts.SmoEnum.DTSEnum.GetData(EnumResult erParent)
>>   at Microsoft.SqlServer.Management.Smo.Environment.GetData()
>>   at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req,
>> Object ci)
>>   at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object
>> connectionInfo, Request request)
>>   at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object
>> connectionInfo, Request request)
>>
>> ===================================
>>
>> Connect to SSIS Service on machine "<servername>" failed:
>> Server execution failed
>> .
>>
>>
>> ------------------------------
>> Program Location:
>>
>>   at
>> Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.GetServerInfo(String
>> bstrMachineName, String& serverVersion)
>>   at Microsoft.SqlServer.Dts.Runtime.Application.GetServerInfo(String
>> server, String& serverVersion)
>>
>>
>>
>>
>
>