January 6, 2009 at 7:26 am
Hi Team,
I am relatively new to SQL Server Database Administration. I have an SQL Server Database with the following details,
Product Version : 9.00.3042.00
Product Level : SP2
Product Edition : Standard Edition
At the moment SSIS is not on the server and I've a request to add SSIS. I have gone into Control Pannel --> Microsoft SQL Server 2005 --> Change --> To Install a New Component, click here --> Browse to get the setup.exe file for SQL Server 2005 Standard Edition --> OK --> Accept Licence Agreement --> Next --> Next --> System Configuration Check --> SQL Server Installation Wizard --> Next
then I am getting 14 successes and a Warning. The Warning is on Edition Change Check with the following message,
Edition Change Check (Warning)
Messages
* Edition Change Check
* To change an existing instance of SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 setup fro,m the command prompt and include the SKUUPGRADE=1 parameter.
I assume that the issue is due to the installation of SP2. Does anyone know how this can be fixed?
Thanks,
Philip.
January 6, 2009 at 7:37 am
The warning can be ignored. It is there to warn (funnily enough) that if you are attempting to change the edition of an existing install your have to go through a different method. However you are only adding a component that is available in your current edition.
Cheers
Chris
January 7, 2009 at 6:10 am
Hi Chris,
Thanks a lot for your reply. I will try it out and update the forum.
Thanks,
Philip
January 9, 2009 at 5:35 am
Hi Team,
I have decided to perform the installation ignoring the warning. I was able to install SSIS and can see the service appeared along with the list of services. But I am not able to start up the service as it says the following error,
I have the SQL Server Integration Services with Startup Type as Automatic but when ever I start it it gives me the error,
Could not start the SQL Server Integration Service on Local Computer
Error 1053: The service did not respond to start or control request in a timely fashion.
On Event Viewer I've found the following error,
Event Type:Error
Event Source:Service Control Manager
Event Category:None
Event ID:7000
Date:1/9/2009
Time:12:20:26 PM
User:N/A
Computer:ABCD01
Description:
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.
Event Type:Error
Event Source:Service Control Manager
Event Category:None
Event ID:7009
Date:1/9/2009
Time:12:20:26 PM
User:N/A
Computer:ABCD01
Description:
Timeout (30000 milliseconds) waiting for the SQL Server Integration Services service to connect
I have googled this but couldn't find a solution to resolve this problem. Any help appreciated?
Thanks,
Philip
March 3, 2009 at 3:15 am
Hi Philip,
Did you get any solution for this problem. even i am facing same problem. Please share the solution if you have.
Thanks & Rgds
Prakash C S
March 3, 2009 at 3:23 am
Hi, have you re-installed SP2 to upgrade your newly installed SSIS installation?
March 11, 2009 at 12:15 pm
I've seen the same thing. You should be okay if you apply SP2 and any additional hotfixes to bring the version level of SSIS up to that of the Database Engine. Also, make sure the account you are using to run the service is an Admministrator on the server. Otherwise it will not be able to start the service it is supposed to control.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply