| Author |
Topic |
|
cognos79
Posting Yak Master
241 Posts |
 Posted - 2008-06-18 : 17:50:49
|
| I want to learn about developing SSIS packages. I have installed trial version of SQL Server 2005 Express Edition. what additional software do I need to install to develop SSIS packages??? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-18 : 21:02:00
|
| I think Express edition doesn't come with BIDS.Why not install SQL 2005 Enterprise Edition from Microsoft? |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-18 : 22:19:07
|
| Should be trial version of enterprise edition. Or get developer edition for $50. |
|
|
|
cognos79
Posting Yak Master
241 Posts |
Posted - 2008-06-19 : 00:10:06
|
| on the trail version page for enterprise edition there are 3 exectuable files. which one should I download? I have windows vista Home premium edition OS.https://www.microsoft.com/downloads/details.aspx?FamilyId=6931FA7F-C094-49A2-A050-2D07993566EC&displaylang=en&hash=u33w1oyhkFy7ccphLu3vw99JmBI0%2bJ5brXSqnBeeIzf01WzyWt5mcG6K0P5DmewhvkVvYznKRPfn0j4MLEBejg%3d%3d#filelist |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-19 : 23:14:22
|
| x86 |
|
|
|
cognos79
Posting Yak Master
241 Posts |
Posted - 2008-06-20 : 22:25:06
|
| Thanks...I installed it successfully...But the Reporting services is disabled when I was installing. I was thinking I can even install reporting services through sql server enterprise edition. Is there a way I can install reporting services too? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-20 : 22:47:09
|
| You need to have IIS installed before installing Reporting Services. |
|
|
|
cognos79
Posting Yak Master
241 Posts |
Posted - 2008-06-21 : 11:09:26
|
| I am using windows vista and I enabled IIS 7.0 already. In the browser when I type http://localhost/ i get the IIS web page. I guess that means IIS is working. But still when I run the sql server installation exe file reporting services is disabled. Any ideas??? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-21 : 11:36:48
|
| http://support.microsoft.com/kb/934164 |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-21 : 12:48:26
|
| What error exactly do you get in Configuration page while installing for SSRS? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-21 : 16:07:53
|
| Did you go through RS configuration manager after installation? |
|
|
|
cognos79
Posting Yak Master
241 Posts |
Posted - 2008-06-25 : 08:12:39
|
| visakh...I tried the prequesites mentioned in the document. Still I have no luck. It says to check "windows authentication" under security. I dont see windows authentication option at all. |
|
|
|
cognos79
Posting Yak Master
241 Posts |
Posted - 2008-06-25 : 09:13:42
|
| I guess the cuplrit is with IIS...even after I check all the options mentioned in the microsoft document...I still get IIS warning message when I run the SQL server set up package. Warning message indicates that IIS is not enabled or not installed. But when I do http://localhost/ i get the iis screen without errors. any ideas??? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-27 : 23:34:45
|
| What's IIS version? |
|
|
|
cognos79
Posting Yak Master
241 Posts |
Posted - 2008-06-28 : 12:19:45
|
| IIS 7.0. I am using vista home premium edition. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-28 : 22:03:18
|
| You may try with SSRS2k8. |
|
|
|
|
installing SSIS