Hello - We have been unable to successfully install Integration Services with an instance of SQL 2005 running on a Windows Small Business Server 2003. Installation proceeds with no errors, but when you attempt to connect to the Integrations Services and browse to where it apparently exists, the SQL Server Managment Studio returns the following error:
TITLE: Connect to Server
Cannot connect to ABDI04.
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 "ABDI04" failed:
The specified service does not exist as an installed service.
.
Connect to SSIS Service on machine "ABDI04" failed:
The specified service does not exist as an installed service.
.
BUTTONS:
OK
We have tried uninstalling the Integration Services, then reinstalling it and again applying SP2 with the same results.
Thank you.
did you check in the sql server configuration manager? were you able to view the SSIS service there?if yes, is the service started ? ? ?if not just start the services and try to logon
also did you check in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt file if the installation was successful ? ? ?
|||Hello Deepak -
I am not able to view SSIS in configuration manager and the service is not present with the other system services. Using your suggestion, I also verified the Summary txt file:
Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Microsoft Windows Server 2003 family, Service Pack 2 (Build 3790)
Time : Sat Jul 14 15:57:47 2007
ABDI04 : To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter.
Machine : ABDI04
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0016_ABDI04_SQLSupport_1.log
--
Machine : ABDI04
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0016_ABDI04_SQLNCLI_1.log
--
Machine : ABDI04
Product : Microsoft Office 2003 Web Components
Product Version : 11.0.6558.0
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0016_ABDI04_OWC11_1.log
--
Machine : ABDI04
Product : Microsoft SQL Server 2005 Backward compatibility
Product Version : 8.05.2004
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0016_ABDI04_BackwardsCompat_1.log
--
Machine : ABDI04
Product : MSXML 6.0 Parser
Product Version : 6.10.1129.0
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0016_ABDI04_MSXML6_1.log
--
Machine : ABDI04
Product : Microsoft SQL Server 2005 Integration Services
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0016_ABDI04_DTS.log
--
Setup succeeded with the installation, inspect the log file completely for status on all the components.Time : Sat Jul 14 16:03:43 2007
and it seems to confirm that the installation proceeded to a successful conclusion.
Do you have any other suggestions? Thank you very much - Bryan
|||Hi,look if the "SQL Server Integration Services" is installed. If not, which version of SQL Server are you running on the machine (Therefore examine the "SQL Server (InstanceNamehere)" services mentioned in the SCM.
Jens K. Suessmeyer.
-
http:://www.sqlserver2005.de
-|||Hello,
we have exactly the same problem. We installed completely new installation of SQL 2005 Server to a new installation of Small Business 2003. We ensured that the "Integration Services" option in the installation was set to "install entirely" mark. After no error reported installation we found out that the "SSIS Service" is not present among the system services, not even in the SQL configuration manager services.
However, the installation log file reports:
Product : Microsoft SQL Server 2005 Integration Services
Product Version : 9.00.1399.06
Install : Successful
Of course, we are not able to connect or using the Integration services. So, the question is, how can we install the Integration Service into the system?
Can anyone help?
|||Is the service started ? Can be found in the Service control manager (SCM) in Windows.
Jens K. Suessmeyer
http://www.sqlserver2005.de
|||Well, as I said, the service did NOT install into the system. (We checked both the Windows System Services and SQL Service control manager). So the answer is NO, the service is not started (because is not installed).
Jonas
|||One more thing: could anyone provide us the information, what executable file is related to SSIS servise to launch (with the the proper command line switches, if any)?
We would like to locate this executable on the drive and try to launch it manually.
thanks
No comments:
Post a Comment