October 21, 2010 at 5:39 am
I'm trying to learn about SQL server and reporting services, using free editions etc.
I've installed SQL server 2005 express, then Visual Studio 2005. I've used the BI Development Studio to build some code, and now I want to deploy some reports....
but I can't figure out where to.
When I add a new data source, I have to put server name = ".\SqlExpress", then I can attach to database files no problem. (Though I can never make these "shared", that always fails).
I think there's a report server UI that I should be able to get to, but can't work out the URL to get to it e.g. no success with "http://localhost/reportserver" , or with substituting my computer name for "localhost".
I thought maybe I need IIS but I ran the MS "web platform installer" which reports that IIS is already installed (part of VS 2005 maybe?)
How do I work out how to get to this server (or whatever the heck it is)?
October 22, 2010 at 12:35 pm
Not too many helpful suggestions then!
Here's an update in case anyone else has this problem and finds this thread.
Simple answer - the o/s is XP Home Edition, and it won't support what I was trying to do.
BIDS needs the IIS web server, and although the MS "web platform installer" reported that IIS was present, it wasn't. XP Home doesn't support IIS, and although there are instructions on the web of how to install IIS anyway, it all sounded a bit risky to me.
Second attempt was to use SQL Server 2008 Express (the "special extras" edition) plus BIDS from Visual Studio 2008 Express. (First make sure you've installed .NET 2.0, 3.0, 3.5 and Windows Installer 4.1).
I don't know why this works on XP Home, but it does. I now have reporting services with Report Manager and Report Server available. Neat!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply