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 |
|
madhav20
Starting Member
6 Posts |
 Posted - 2012-03-26 : 14:29:41
|
| Hello,We have a production box with Windows 2003 Server edition. The server has SSIS 2008 only.I wanted to install Business intelligence Development studio(BIDS) on this server. My question is, Do I need to restart the Box after installing BIDS?Thanks in Advance. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-26 : 14:36:32
|
| why should you install client tool on production box? you should be using client tool installed in your machine to logon to production box. dont run client tools in productipon box itself.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
madhav20
Starting Member
6 Posts |
Posted - 2012-03-26 : 14:48:49
|
quote:
Originally posted by visakh16
why should you install client tool on production box? you should be using client tool installed in your machine to logon to production box. dont run client tools in productipon box itself.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
Thank you for your Quick reply. We have developed SSIS packages for Datawarehouse purpose. The packages uses oracle DB connection. We have access to remote oracle dbs from this server only. I wanted to modify packages using BIDS on this server, literally I will be using prod box for Dev purpose and Im ok with this, Please answer my initial question, "Do I need to restart the Box after installing BIDS?" |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-26 : 14:55:53
|
| literally I will be using prod box for Dev purpose and Im ok with thisthis is not at all recommended neither safe. For pointing to oracle live dbs why should you reopen the packages and edit? Have you heard of package configurations? you should be setting up configurations to solve. In dev box use some local dev/test server instead.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-26 : 15:03:49
|
| to answer your original question installing BIDS doesnt require restart but its higly recommended to make sure all service packs etc are getting applied correctly------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
madhav20
Starting Member
6 Posts |
Posted - 2012-03-26 : 15:11:35
|
quote:
Originally posted by visakh16
to answer your original question installing BIDS doesnt require restart but its higly recommended to make sure all service packs etc are getting applied correctly------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
Thank you for clarifying my question quickly. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-26 : 15:51:06
|
quote:
Originally posted by madhav20
quote:
Originally posted by visakh16
to answer your original question installing BIDS doesnt require restart but its higly recommended to make sure all service packs etc are getting applied correctly------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
Thank you for clarifying my question quickly.
Still I want to reiterate the point of refrain from using production box for development.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Restart needed after installing BIDS?