 | |
Installing SQL Server 2005 on a PC that has Visual Studio 2008
microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: Installing SQL Server 2005 on a PC that has Visual Studio 2008 -
04-17-2009
, 10:50 AM
|
Sorry I was not feeling well Wednesday and was out sick on Thursday. I missed that you were using SQL Server2005. I don't actually know anything about this issue. I just knew that the issue was discussed in the 2008 Release Notes. It looks like that may not be helpful. -- Rick Byham (MSFT), SQL Server Books Online This posting is provided "AS IS" with no warranties, and confers no rights. "Jeff_B" <JeffB (AT) discussions (DOT) microsoft.com> wrote in message news:152E604A-3E6D-4816-B8CE-41CACDD12B38 (AT) microsoft (DOT) com... Hi Rick, Thanks for quick reply.. but, your link is for SS 2008 and VS 2008. Are you sayind this applies to SS2005/VS2008 as well ? If yes, I'll uninstall both, since my first steps had been VS2008, SS2005, VS2008-SP1, ss2005-SP3. On reinstall, I'll do vs2008, vs2008-sp1, ss2005, ss2005-sp3. --Jeff_B "Rick Byham, (MSFT)" wrote: The release notes http://download.microsoft.com/downlo...leaseNotes.htm has a section about VS 2008. See the part in the middle where is says Required Actions. Mostly it says to get Visual Studio 2008 SP1. -- Rick Byham (MSFT), SQL Server Books Online This posting is provided "AS IS" with no warranties, and confers no rights. "Jeff_B" <Jeff_B (AT) discussions (DOT) microsoft.com> wrote in message news:2ADA9498-5FB5-4C4A-A529-B1F1E1F5FF4A (AT) microsoft (DOT) com... Hello Brett & Derek, I have similar problem: I bought VS 2008 Pro-academic which ships with SS2005, because I need to find job and they all ask for ssis, ssas, ssrs, so.. I install both, get up to vs 2008 sp1 and ssvr 2005 sp3 (2-day headache with BSOD til fix 184176) , but no BIDS - SSIS (haven't tried SSAS, SSRS). Also, SSrver installed but had not icon for SS BI on start menu, properties said it needed devenv.exe but couldn't find it, so I pointed it to VS 2008 devenv.exe. I know now it was looking for devenv.exe of VS 2005, which I don't have. What do I need to do to install ss2005 BIDS so I can master SSIS without buying/installing (or at least buying) VS 2005 (which school bookstore no longer carries) ? I also need vs2008 to learn latest .NET. Thanks Jeff "Brett" wrote: Hi Derek, I had the same problem. Here were my steps to solving the problem. The solution was: Step 1 - Install SQL Server 2005 Step 2 - Install SP3 for SQL Server 2005 Step 3 - Reboot Step 4 - Install Visual Studio 2008 SP1 Step 5 - Reboot After your reboot you "should" be able to not only get into Management Studio but also BIDS. Post back and let us know how it goes. If it does not work I will continue to help you find a solution. SQL Squirrel http://www.lockergnome.com/sqlsquirrel/ "Derek" <Derek (AT) discussions (DOT) microsoft.com> wrote in message news:8A79952B-B4CB-4155-AAFB-46FBABFD6CB4 (AT) microsoft (DOT) com... Thank you for your reply. I can get everything except Business Intelligence Studio working by installing VS 2008 first patching it up to SP1 and then installing SQL 2005. The problem here is the setup program will not install VS 2005 components when I have VS 2008 installed. Is it posible to download the SSIS templates and just use them with VS 2008? If so where can I get them from? Installing SQL 2005 first seems to be a non starter. As soon as I install VS 2008 I can't even open Management Studio. -- Derek "Rick Byham, (MSFT)" wrote: The following link to the SQL Server 2008 Release Notes described a similar problem. The solution described may help you for SQL Server 2005. http://download.microsoft.com/downlo...leaseNotes.htm -- Rick Byham (MSFT), SQL Server Books Online This posting is provided "AS IS" with no warranties, and confers no rights. "Derek" <Derek (AT) discussions (DOT) microsoft.com> wrote in message news:72BB7D90-7645-4D5B-9FF5-1BCE3B47BE1E (AT) microsoft (DOT) com... I am having problems getting SQL Server 2005 and Visual Studio 2008 to coexist on my PC. If I install VS 2008 first Business Intelligence Development Studio does not install and I don't get the SSIS templates in VS 2008. If I install SQL Server 2005 first it no longer works after I install VS 2008. We have hundreds of legacy DTS jobs to maintain as well so I need to install the backwards compatibility components. Does anyone know how I can get it all to work at the same time? -- Derek |
#12
| |||
| |||
|
|
Thanks for the reply Rick and Paul, I haven't explored every nook of Paul's reply, and appreciate your candor Rick. Thinking over what I've read so far, without other replies, it seems MS VS2008 has painted itself into a corner with respect to SQL Server 2005 support. Is there an avenue with customer service I can pursue without paying $99 or $259 (money I don't have) to lodge a support request ? Seems to me two simple and traditional practices have been violated: 1) backward compatibility, and 2) shipping 2 products in same package that have a clear incompatibilty. I believe I have a reasonable expectation of compatibility and useful functionality, which of course led to my purchase. Let me know if you need my phone number, email address, etc. TIA, Jeff_B "Rick Byham, (MSFT)" wrote: Sorry I was not feeling well Wednesday and was out sick on Thursday. I missed that you were using SQL Server2005. I don't actually know anything about this issue. I just knew that the issue was discussed in the 2008 Release Notes. It looks like that may not be helpful. -- Rick Byham (MSFT), SQL Server Books Online This posting is provided "AS IS" with no warranties, and confers no rights. "Jeff_B" <JeffB (AT) discussions (DOT) microsoft.com> wrote in message news:152E604A-3E6D-4816-B8CE-41CACDD12B38 (AT) microsoft (DOT) com... Hi Rick, Thanks for quick reply.. but, your link is for SS 2008 and VS 2008. Are you sayind this applies to SS2005/VS2008 as well ? If yes, I'll uninstall both, since my first steps had been VS2008, SS2005, VS2008-SP1, ss2005-SP3. On reinstall, I'll do vs2008, vs2008-sp1, ss2005, ss2005-sp3. --Jeff_B "Rick Byham, (MSFT)" wrote: The release notes http://download.microsoft.com/downlo...leaseNotes.htm has a section about VS 2008. See the part in the middle where is says Required Actions. Mostly it says to get Visual Studio 2008 SP1. -- Rick Byham (MSFT), SQL Server Books Online This posting is provided "AS IS" with no warranties, and confers no rights. "Jeff_B" <Jeff_B (AT) discussions (DOT) microsoft.com> wrote in message news:2ADA9498-5FB5-4C4A-A529-B1F1E1F5FF4A (AT) microsoft (DOT) com... Hello Brett & Derek, I have similar problem: I bought VS 2008 Pro-academic which ships with SS2005, because I need to find job and they all ask for ssis, ssas, ssrs, so.. I install both, get up to vs 2008 sp1 and ssvr 2005 sp3 (2-day headache with BSOD til fix 184176) , but no BIDS - SSIS (haven't tried SSAS, SSRS). Also, SSrver installed but had not icon for SS BI on start menu, properties said it needed devenv.exe but couldn't find it, so I pointed it to VS 2008 devenv.exe. I know now it was looking for devenv.exe of VS 2005, which I don't have. What do I need to do to install ss2005 BIDS so I can master SSIS without buying/installing (or at least buying) VS 2005 (which school bookstore no longer carries) ? I also need vs2008 to learn latest .NET. Thanks Jeff "Brett" wrote: Hi Derek, I had the same problem. Here were my steps to solving the problem. The solution was: Step 1 - Install SQL Server 2005 Step 2 - Install SP3 for SQL Server 2005 Step 3 - Reboot Step 4 - Install Visual Studio 2008 SP1 Step 5 - Reboot After your reboot you "should" be able to not only get into Management Studio but also BIDS. Post back and let us know how it goes. If it does not work I will continue to help you find a solution. SQL Squirrel http://www.lockergnome.com/sqlsquirrel/ "Derek" <Derek (AT) discussions (DOT) microsoft.com> wrote in message news:8A79952B-B4CB-4155-AAFB-46FBABFD6CB4 (AT) microsoft (DOT) com... Thank you for your reply. I can get everything except Business Intelligence Studio working by installing VS 2008 first patching it up to SP1 and then installing SQL 2005. The problem here is the setup program will not install VS 2005 components when I have VS 2008 installed. Is it posible to download the SSIS templates and just use them with VS 2008? If so where can I get them from? Installing SQL 2005 first seems to be a non starter. As soon as I install VS 2008 I can't even open Management Studio. -- Derek "Rick Byham, (MSFT)" wrote: The following link to the SQL Server 2008 Release Notes described a similar problem. The solution described may help you for SQL Server 2005. http://download.microsoft.com/downlo...leaseNotes.htm -- Rick Byham (MSFT), SQL Server Books Online This posting is provided "AS IS" with no warranties, and confers no rights. "Derek" <Derek (AT) discussions (DOT) microsoft.com> wrote in message news:72BB7D90-7645-4D5B-9FF5-1BCE3B47BE1E (AT) microsoft (DOT) com... I am having problems getting SQL Server 2005 and Visual Studio 2008 to coexist on my PC. If I install VS 2008 first Business Intelligence Development Studio does not install and I don't get the SSIS templates in VS 2008. If I install SQL Server 2005 first it no longer works after I install VS 2008. We have hundreds of legacy DTS jobs to maintain as well so I need to install the backwards compatibility components. Does anyone know how I can get it all to work at the same time? -- Derek |
#13
| |||
| |||
|
|
Thanks for the reply Rick and Paul, I haven't explored every nook of Paul's reply, and appreciate your candor Rick. Thinking over what I've read so far, without other replies, it seems MS VS2008 has painted itself into a corner with respect to SQL Server 2005 support. Is there an avenue with customer service I can pursue without paying $99 or $259 (money I don't have) to lodge a support request ? Seems to me two simple and traditional practices have been violated: 1) backward compatibility, and 2) shipping 2 products in same package that have a clear incompatibilty. I believe I have a reasonable expectation of compatibility and useful functionality, which of course led to my purchase. Let me know if you need my phone number, email address, etc. TIA, Jeff_B "Rick Byham, (MSFT)" wrote: Sorry I was not feeling well Wednesday and was out sick on Thursday. I missed that you were using SQL Server2005. I don't actually know anything about this issue. I just knew that the issue was discussed in the 2008 Release Notes. It looks like that may not be helpful. -- Rick Byham (MSFT), SQL Server Books Online This posting is provided "AS IS" with no warranties, and confers no rights. "Jeff_B" <JeffB (AT) discussions (DOT) microsoft.com> wrote in message news:152E604A-3E6D-4816-B8CE-41CACDD12B38 (AT) microsoft (DOT) com... Hi Rick, Thanks for quick reply.. but, your link is for SS 2008 and VS 2008. Are you sayind this applies to SS2005/VS2008 as well ? If yes, I'll uninstall both, since my first steps had been VS2008, SS2005, VS2008-SP1, ss2005-SP3. On reinstall, I'll do vs2008, vs2008-sp1, ss2005, ss2005-sp3. --Jeff_B "Rick Byham, (MSFT)" wrote: The release notes http://download.microsoft.com/downlo...leaseNotes.htm has a section about VS 2008. See the part in the middle where is says Required Actions. Mostly it says to get Visual Studio 2008 SP1. -- Rick Byham (MSFT), SQL Server Books Online This posting is provided "AS IS" with no warranties, and confers no rights. "Jeff_B" <Jeff_B (AT) discussions (DOT) microsoft.com> wrote in message news:2ADA9498-5FB5-4C4A-A529-B1F1E1F5FF4A (AT) microsoft (DOT) com... Hello Brett & Derek, I have similar problem: I bought VS 2008 Pro-academic which ships with SS2005, because I need to find job and they all ask for ssis, ssas, ssrs, so.. I install both, get up to vs 2008 sp1 and ssvr 2005 sp3 (2-day headache with BSOD til fix 184176) , but no BIDS - SSIS (haven't tried SSAS, SSRS). Also, SSrver installed but had not icon for SS BI on start menu, properties said it needed devenv.exe but couldn't find it, so I pointed it to VS 2008 devenv.exe. I know now it was looking for devenv.exe of VS 2005, which I don't have. What do I need to do to install ss2005 BIDS so I can master SSIS without buying/installing (or at least buying) VS 2005 (which school bookstore no longer carries) ? I also need vs2008 to learn latest .NET. Thanks Jeff "Brett" wrote: Hi Derek, I had the same problem. Here were my steps to solving the problem. The solution was: Step 1 - Install SQL Server 2005 Step 2 - Install SP3 for SQL Server 2005 Step 3 - Reboot Step 4 - Install Visual Studio 2008 SP1 Step 5 - Reboot After your reboot you "should" be able to not only get into Management Studio but also BIDS. Post back and let us know how it goes. If it does not work I will continue to help you find a solution. SQL Squirrel http://www.lockergnome.com/sqlsquirrel/ "Derek" <Derek (AT) discussions (DOT) microsoft.com> wrote in message news:8A79952B-B4CB-4155-AAFB-46FBABFD6CB4 (AT) microsoft (DOT) com... Thank you for your reply. I can get everything except Business Intelligence Studio working by installing VS 2008 first patching it up to SP1 and then installing SQL 2005. The problem here is the setup program will not install VS 2005 components when I have VS 2008 installed. Is it posible to download the SSIS templates and just use them with VS 2008? If so where can I get them from? Installing SQL 2005 first seems to be a non starter. As soon as I install VS 2008 I can't even open Management Studio. -- Derek "Rick Byham, (MSFT)" wrote: The following link to the SQL Server 2008 Release Notes described a similar problem. The solution described may help you for SQL Server 2005. http://download.microsoft.com/downlo...leaseNotes.htm -- Rick Byham (MSFT), SQL Server Books Online This posting is provided "AS IS" with no warranties, and confers no rights. "Derek" <Derek (AT) discussions (DOT) microsoft.com> wrote in message news:72BB7D90-7645-4D5B-9FF5-1BCE3B47BE1E (AT) microsoft (DOT) com... I am having problems getting SQL Server 2005 and Visual Studio 2008 to coexist on my PC. If I install VS 2008 first Business Intelligence Development Studio does not install and I don't get the SSIS templates in VS 2008. If I install SQL Server 2005 first it no longer works after I install VS 2008. We have hundreds of legacy DTS jobs to maintain as well so I need to install the backwards compatibility components. Does anyone know how I can get it all to work at the same time? -- Derek |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.