CE 9 Installation Problems - Job Server & APS

[waydaws]

Weird. I know I posted on Friday, but my post can't be found. Not sure what subject I used. Well here's a more detailed entry anyway.

IIS 6, Win 2K3, CE 9 (5 named users).

I installed CE. At first I tried multi-tier but had a problem connecting my APS to a SQL 2000 db on a backend data tier, and gave up and went with a install to a single dedicated machine.

When I did this first the APS wouldn't start up. I got it started by switching to a access driver. I don't know what happened to the SQL MSDE, but it doesn't look like it got installed.

Next problem was it complained about 1 unlicensed user when the only person logged in was the Administrator. Looked and saw that the key code I entered during install wasn't listed. I added it, but got the same message. Finally figured out that it was because it installs the users as concurrent and I had named users. Deleted the guest and switched the Administrator, and it was fine.

Next I went to configure the Job Server. I set up a DSN to the SQL Database that I want to use for the source, but I don't see any way of configuring the Report Job Server to use it. Is this how it works?

 

[waydaws]

OK, I found out why the MSDE SQL 7 didn't install correctly. However, I'd like to know about the other question about how do I get the job server to get info from the database -- or do I? If it's done solely in the report itself I suppose I don't have to. Since I haven't seen this product before I don't know. Can any one answer this?
Oh and can I install more than one webconnector, and have them both talk to the same wcs?

What was the problem with the APS? It was due to SQL 2000 (tools only) being installed on this Win2k3 machine.

To get it installed I had to do this B.S. workaround. Note that first I tried just running from the CD \win322\redist\en\msdex86.exe. That reported that setup.iss doesn't exist in c:\temp\pft5~tmp. This folder is created when I run msdxx86, but disappears when I click ok on the error message dialog. Reran it and this time made a copy of the folder. I sawa that it extracts a batch file to create the db from a bunch of sql scripts. I ran the batch and the msde was created. This promptly broke the SQL 2000 tools I had installed. I ran a SQL 2000 MSDE and this fixed the tools (and I hope upgraded the sql 7 msde). Yeah, maybe I could have just run this in the first place. Don't know.
I was then able to set up a DSN, and redo the APS (re-entering all the info, including license keys and etc.)

 

[KingfisherINC]

The Job Server only need to be logged on using an account that has rights to access the database(s) - The actual Db connection info is stored per report template, it defaults to whatever the report was published with (there is a Database tab in CMC per report where you can reset this, or force the user to enter each time).

RE: Web connector - Technically you can, but I don't see the point of connecting to the same WCS? - The idea of multiple WC is to point to multiple WCS, having two point to the same WCS is just redundant.

 

[waydaws]

Thanks, Kingfisher.

The Job Server is logged on as local system account. Which is why I'm wondering. Since the database is on another machine, the system account wouldn't have access accross the network. That's why I thought I'd need a odbc connection for it. However, if the db login info is in the report template, and since the report template would be accessible via the repository server (which _is_ on the same machine as the the Job server) -- I think it would have access to the db then. I think that's what you're telling me. Correct?

About the Web Connector, originally I envisioned it to be on another machine (actually two a load balanced webfarm) runnining iis 6. When I went to install it, it added the extension correctly, but the virtual directories weren't created for some reason. I thought maybe it was because I already had installed the the webconnector on the same machine as the WCS. If I was able to get it installed on the remote nodes, I would just delete the local site. However, I'm not sure if I can at this point, and if not, I leave it all on one server.

Right now I have everything running on the middle tier an not split logically over a presentation, business logic and data tier.

But it's a small implementation anyway being 5 named users, so I guess it doesn't really have to be split, but I wanted to do it right in the first place instead of having to expand it later if we decided to go with it as an enterprise reporting intelligence solution.

Anyway, I hope I read your post correctly, and thanks again for your help.