Everytime I went throught the express Toolkit install and I chose, all components, it just responded with "nothing to do."
I installed the BIDS by just executing vs_setup.msi. as mentioned above.
This seems to have worked partially. Visual Studio is now there.
However, no templates are available except "Blank Solution"
The case seems some Report Builder/Model Builder templates should exist?
What am I doing wrong?
What can I do to fix the problem?
Where can I find the "report building templates?"
Thanks.
AIMDBA
Hi AIMDBA,
I split this post into a new thread since it seemed like a distinct problem from the thread that you added it to. It's usually not a good idea to add new questions onto the bottom of a thread that has been marked as answered since not everyone reads the Answered threads unless they are looking for an answer.
Onto your issue...
vs_setup.msi is not BIDS, which is why your are not seeing the Reporting projects. What other SQL and VS products do you have installed on your computer when you are installing the Toolkit? Could you take a look at the setup logs (C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG) to see if there is any additional information about what went wrong?
Regards,
Mike Wachal
SQL Express team
Mark the best posts as Answers!
|||Basically,
I installed the following, in the following order:
(1) Net Framework 2.0
(2) SQL Server Express 2005 with Advanced services.
I installed all components. This includes the report server.
I tested the report server. This works!
This install included SQL Server Management Studio.
(3) I tried next to install
SQL Server 2005 Tookit SP1.
I chose all components including Business Intelligence Studio.
I message came back saying somethin similar to "Nothing to do."
I tried other variations. I tried X'ing out the the other components, then tried instaling the Business Intelligence Studio. Again, I recieved the message back saying "Nothing to do."
My general impression is that since Management Studio Express is already installed, the installer thinks that Business Intelligence Studio is also installed? Is this true?
About the log directory, man /files logs exist in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files.
Is there any particular log I should be looking at? Like *tools.log?
Is there a good keyword to "search" on? E.g. "error" or similary
Thank you very much.
AIMDBA
|||I'm was having the same problem. The log file you mention says, "SQL Server Setup was interrupted. For more information, review the Setup log file in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt." Cute - that's the file I was reading.
I looked at the files in the LOG\Files directory but they didn't help. I have VS2003 and VS2005 (Enterprise Edition) on my desktop. At least I hope it's still the Enterprise Edition after installing SQL Server 2005 Express, I hope I didn't mess up my VS2005 install.
The DTS directory was not in the /90 directory or the /90/Tools directory.
I FINALLY tried downloading the software, rather than just running it from the internet. I used WinZip to extract the files, then ran the setup.exe and THIS time it worked. BTW the DTS directory is there now.
Carol
|||
Carol,
The DTS directory has nothing to do with the Business Intellegence Development Studio. I'm not sure where you're going with this.
Regards,
Mike Wachal
SQL Express team
-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1
AIMDBA wrote:
My general impression is that since Management Studio Express is already installed, the installer thinks that Business Intelligence Studio is also installed? Is this true?
No, Management Studio Express and BIDS don't interact and don't impact each others installation.
I just performed this same action of only installing BIDS on a computer that had everything else from Express Advanced and it seemed to work fine. I'm not sure what's going on here. I'd say as a next step, try Carol's method of extracting all the file and install from a flat. You can either use WinZip, or you should just be able to run <path>\SQLEXPR_TOOLKIT.EXE /x and then pick a directory to extract to.
Let us know if that works.
Regards,
Mike Wachal
SQL Express team
-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1
The laptop I was using, ended up being inadequate for my project. I am getting a newer and better laptop.
I will try to do the installs again.
Maybe, next time, I will do the installs backwards.
(1) Install the optional Windows XP IIS server.
(2) Install Windows Installer
(3) Install .Net 2.0 Framework.
(4) Install ALL components of the Express toolkit. (Perhaps this will include SQL Server Express itself.)
(5) Install SQL Server Advanced Services ((SQLExpress if not already installed AND the report server in particular.)
I will try this order next time (maybe next week some time).
Mike Wachal what do you think about that?
It may be a while before I get the other laptop.
I will post back when I get the other laptop and try the install.
Does anyone else have any other comments?
Thanks.
AIMDBA
|||Hi Aimdba,
I would reverse steps 4 & 5. SQL Express Toolkit does not contain the SQL database engine, it only contains the shared SQL Tools. So...
1 - 3. Yes, install the prerequisites first.
4. Install SQL Express with Advanced Services
5. Install the SQL Express Toolkit
Granted, it sounds like you've done this and it wasn't working, but this is the way that I install them and it has worked several times. I've never tried installing in the order that you suggest, but I don't see any reason that it wouldn't work.
Regards,
Mike
|||Mike,
I did as you recommended.
I did "5. Install the SQL Express Toolkit"
Next, I did "4. Install SQL Express with Advanced Services"
All installs worked correctly.
Thanks.
AIMDBA
|||Hi Mike,I might have the same problem (or I just might be totally clueless).
If I:
1) install 2005 Express with Advanced Services, selecting all available options.
2) install the Toolkit
The toolkit won't install, it says it has nothing to do. If I ask for details it says that the only available option is "upgrade"
So I:
1) Reverted back (This is all taking place on a VM).
2) Installed the Toolkit, selecting all options.
3) Installed Express Advanced Services, selecting Everything from all the options except Client Tools. For Client Tools I only select "Software Development Kit" (because the Management Studio Express and Connectivity Components were installed by the Toolkit"
It tells me it can't install the Client Tools (specifically "Workstation components and development tools 9.1.2047.00".
So, it seems to me, if you install any "Client Tools" with the Express install, you won't be able to install "Client Tools" from the Toolkit, even though the Client Tools don't match up 100%.
I think, in the end, by installing backwards I got all the things I will need, but I;m not sure I got the Software Development Kit. I'm also not sure what that is, or if I will need it, or how to know if I got it (this is the clueless part I mentioned earlier).
Any thoughts?
No comments:
Post a Comment