March 27, 2012 at 9:51 am
Hi
I plan to upgrade a trail version of VS2008 on one of live sql server(2008R2). trial version has already expired and hence I can't use SSIS on this machine. I have no clue who had this idea of installing Trial version on a live server, but it is there for me.
Now some questions I have:
1.Will I need to take a downtime for this?
2. What are the precautions I should take?
3.I hope messing around with VS have no impact on my sql engine and my users will stay connected. Am I hoping correct?
Thanks
Suresh
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
March 27, 2012 at 9:57 am
S_Kumar_S (3/27/2012)
HiI plan to upgrade a trail version of VS2008 on one of live sql server(2008R2). trial version has already expired and hence I can't use SSIS on this machine. I have no clue who had this idea of installing Trial version on a live server, but it is there for me.
Now some questions I have:
1.Will I need to take a downtime for this?
2. What are the precautions I should take?
3.I hope messing around with VS have no impact on my sql engine and my users will stay connected. Am I hoping correct?
Thanks
Suresh
Are you sure that you do not have SSIS installed on your live server? Most people do, but some don't for good reasons (Ihave yet to have a good reason to not install it). Did you install Business Intelligence Studio with SQL? If you did, then you already have the pre-req's for SSIS.
Jared
CE - Microsoft
March 27, 2012 at 10:21 am
Hi
BIDS and SSIS are already installed. But when I try to open BIDS, I get the message that trail version of VS2008 is already expired. Thats why I was planning to upgrade it.
I can't see the SSIS dev environment without that.
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
March 27, 2012 at 10:29 am
Why are you trying to open that? The maintenance plan can be edited in SSMS.
Are you trying to do this on a client computer or the server? Your statements are very inconsistent...
Jared
CE - Microsoft
March 28, 2012 at 6:18 am
Sorry for confusion.
I got it working. Here is how it worked:
My live server had Both VS2008 and SSIS. VS2008 was trial version and expired also.
My domain ID didn't have rights to see the maintenance plan if I login to live server. So I was thinking if it can be done using SSIS instead of SSMS. But for SSIS to work, VS2008 should be working fine else it's environment won't work.
I also tried to modify maintenance plan from client, but looks like because of SSMS being express edition(which I am still not sure if it is express), nothing was happening when I clicked "modify".
How it worked??? I got administrator credentials on live server and I can modify the plan from SSMS 🙂
Thanks for listening.....
SQLKnowItAll (3/27/2012)
Why are you trying to open that? The maintenance plan can be edited in SSMS.Are you trying to do this on a client computer or the server? Your statements are very inconsistent...
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
March 28, 2012 at 7:19 am
Glad to hear! Thanks for the update!
Jared
CE - Microsoft
March 28, 2012 at 7:49 am
But that shouldn't close this thread. I still need answers to my original question.
I still want to updagrade from trial version of VS2008 on live server and I should be sure of the answers for questions I posted originally......
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
March 28, 2012 at 8:09 am
Can you be more clear as to how these were installed; i.e. if you install BIDS from the original SQL Server licensed install, it is not trial.
1. Is this a server or a client?
2. Is SQL Server Express edition, trial version, Standard, etc.
3. What was installed when SQL Server was installed and what was installed later?
Jared
CE - Microsoft
March 29, 2012 at 2:19 am
Hi
Here are the answers:
1.BIDS is from original SQL Server licensed install. It is no trial version.
2.This is a server.
3.Edition: 2008 R2 (SP1) - Enterprise Edition on Windows NT 5.2 <X64>
4.Not sure if VS2008 (trail version which I plan to upgrade) was installed earlier than sql server. I think it should have been installed later because if it was installed earlier and then SQL Server 2008R2 was installed, then seerver installation should have upgraded it, isn't it?
When we install sql server, VS components also gets installed, correct?
Thanks
SQLKnowItAll (3/28/2012)
Can you be more clear as to how these were installed; i.e. if you install BIDS from the original SQL Server licensed install, it is not trial.1. Is this a server or a client?
2. Is SQL Server Express edition, trial version, Standard, etc.
3. What was installed when SQL Server was installed and what was installed later?
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
March 29, 2012 at 5:49 am
VS2008 has many varieties. BIDS is essentially VS2008, but the "version" that comes with SQL Server; i.e. you don't code C# or asp.net with it. So, when you create an SSIS package, you don't open up "Visual Studio" you open "SQL Server Business Intelligence Development Studio." I am not sure what upgrading VS2008 or Uninstalling it will do to BIDS (maybe it will affect some components). You should test this on another server, even if information given online or by others says it will not affect it and you should have a plan to rollback in case your testing differs from production.
Jared
CE - Microsoft
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply