Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Snedker
Starting Member
2 Posts |
 Posted - 2007-02-26 : 06:05:43
|
SQL 2005 running on 2003 Server:When trying to connect to Integration Services from Management Studio, I retrieve the following error:***TITLE: Connect to Server------------------------------Cannot connect to DAVINCI.------------------------------ADDITIONAL INFORMATION:Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476------------------------------Connect to SSIS Service on machine "DAVINCI" failed: The specified service does not exist as an installed service.***I see a ton of people having the same problem, but as for now I still haven't found a solution.We have SP1 installed and have installed cumulative fix from [url]http://support.microsoft.com/kb/918644[/url], and been by the DCOM settings regarding local/remote access. The SSIS service is not running. It is not shown in the list of services. Any ideas before a total re-install?  Regards /Snedker |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-02-26 : 06:12:46
|
| Did you install integration services?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Snedker
Starting Member
2 Posts |
Posted - 2007-02-26 : 06:17:24
|
| Yes. I ran SQL Server 2005 from the Add/Remove programs, and Integration Services was on the list. |
|
|
|
DMcCallie
Yak Posting Veteran
62 Posts |
Posted - 2007-02-27 : 15:57:58
|
| Have you re-applied SP1 and the Hot Fixes (KB918222) after installing SSIS? Have you checked the SQL Server Surface Area Configuration and the SQL Server Configuration Manager (Start, Programs, Microsoft SQL Server 2005, Configuration Tools)? DeWayne |
|
|
|
|
|
|
Can't find SSIS service