Add Integration Services to an Existing Instance of SQL Server 2005
-
Hello friends,
Can I add Integration Services to an Existing Instance of SQL Server 2005 while its in use. I dont want to have to schedule a down-time of the server if i dont need to.
Cheers,
Remember
Without Change something sleeps inside of us that seldom awakens, the sleeper must awaken!! -
If it were me I would not take the advice of anyone on a forum for this one. If you have a dev environment, try it there first and find out for yourself.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato -
opc.three (6/27/2012)
If it were me I would not take the advice of anyone on a forum for this one. If you have a dev environment, try it there first and find out for yourself.+1
I would think you don't have to restart the database engine, as the SSIS service only monitors folders and package executions, but don't take my word on it.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
For the record and to those who are interested.
You can installed SSIS components to SQL without interupting the normal service.
Cheers
Remember
Without Change something sleeps inside of us that seldom awakens, the sleeper must awaken!! -
Mr J (7/4/2012)
For the record and to those who are interested.You can installed SSIS components to SQL without interupting the normal service.
Cheers
Good to know. Thanks for posting back.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply