July 24, 2008 at 4:18 am
Hi All,
Having problems with Vista and sql management studio 2005, while running visual studio 2008 on the machine as well. Was wondering if i install the 2008 management studio will i be able to create and deploy ssis packages to sql server 2005? is the management studio backwards compatible? or do i have to have the client tools for 2005 installed?
N.
July 24, 2008 at 7:16 am
If you're creating the SSIS packages in 2008, you won't be able to deploy them to 2005. I also strongly recommend you DO NOT install 2008 alongside 2005 just yet. There have been a lot of issues with this over the last several months.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 24, 2008 at 7:27 am
From what i read, if you create an ssis package in 2008 and set the framework version to 2.0 it is suppose to be deployable to 2005. Is this a theory that it works and just doesnt work in practice yet?
N.
July 24, 2008 at 7:50 am
I haven't tried that yet. I suppose it will work if documentation says so. It's not one of these places I like to take chances with.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 25, 2008 at 5:34 am
I just tried. I was unsuccessful running the package. It deployed, but it errors. My SQL 2005 machine is running sp2 and CU 6.
The documentation suggests it will work, but I think they have some compatibility issues to work out that you will find involving having your 2008 tools and 2005 server running very specific service packs.
And yes, the side-by-side thing is still not working quite right. As well as the uninstall, so don't do the side-by-side install on a machine you cannot reload the OS on later. Hopefully they will release some kind of malicious software removal tool for SQL 2008 RC 0.
July 25, 2008 at 6:44 am
Ok. cheers for the information. Rebuild and scrap 2008 for the moment then..
N.
June 16, 2010 at 8:38 am
I had a problem installing SQL Server 2008 Management studio on Windows XP, with an error (http://cid-b712073b3513eb8e.office.live.com/self.aspx/.Public/SQLManagementStudio%5E_x86%5E_ENU.exe-setup%20error.JPG) appearing as soon as I ran the setup program.
Since I had Visual Studio 2008 and Visual Studio 2010 installed side-by-side, both SQL Server 2008 and SQL Server 2005 are installed on the same machine and I am going to uninstall both Visual Studio 2008 and SQL Server 2005 to avoid the issues purported in this thread.
Any ideas how to go about installing SQL Server 2008 Management Studio, please? Has anyone else encountered similar issues?
:hehe:
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
