SQL Server?

[Mervin Williams]

I am trying to install MS Project Server 2003 on my Windows Small Business
Server 2003 Premium server. However, I am not seeing a SQL Server program
group from which I can call Enterprise Manager or any of the other tools and
utilities.

How can I verify that SQL Server is installed on the server?

Thanks in advance,

Mervin Williams

 

[Kevin Weilbacher [SBS-MVP]]

Keep in mind that neither SQL nor ISA is automatically installed when
SBS2003 Premium is installed. You have to manually install it via the last
(fith) CD. If you do not have SQL's Service Manager or Enterprise Manager
apps available, I doubt that SQL is installed.

 

[Gary L. Chefetz [MVP]]

Contrary to your popular belief, there are quite a few folks using SBS
Premium with Project Server without problems.

 

[Robert Simmons]

I'm trying to set up an SBS 2003 - Project Server 2003 box (also has
Exchange running on the box). I realize that SQL Server Analysis Services
is not included with the SQL Server install that comes with SBS, but can I
add this on as well? I really need to emulate my production environment as
much as possible, which I've set up on W2K3 with all Project Server 2003
Enterprise features enabled.

-rws

 

[Gary L. Chefetz [MVP]]

Robert:

I'm not an SBS user.

I'm trying to set up an SBS 2003 - Project Server 2003 box (also has
Exchange running on the box). I realize that SQL Server Analysis Services
is not included with the SQL Server install that comes with SBS, but can I
add this on as well? I really need to emulate my production environment
as much as possible, which I've set up on W2K3 with all Project Server
2003 Enterprise features enabled.

-rws

 

[Rod Gill]

I don't think you can buy Analysis Services separately, so SBS is unlikely
to support it. If you want a test environment to emulate production, SBS's
setup is different from vanilla Windows 2003 so makes a poor test box.


--

Rod Gill
Project MVP

 

[Steve Foster [SBS MVP]]

I don't think you can buy Analysis Services separately, so SBS is unlikely
to support it. If you want a test environment to emulate production, SBS's
setup is different from vanilla Windows 2003 so makes a poor test box.

SBS Premium includes SQL Server Standard, and qualifies us to obtain
Reporting Services. It should run just fine on SBS, assuming sufficient
hardware (given that SBS is already quite busy).

 

[Rod Gill]

But I thought Analysis services was different from Reporting services or has
everything been renamed?

Certainly SBS can get busy and if Analysis services (Reporting Services?)
can be run, then make sure to schedule cube building over-night.

--

Rod Gill
Project MVP

 

[otabari]

Hi,
I have a rather serious problem, it seems that everyone that is assigned
a task can view, change or even delete a project! I dont recall
configuring anything that allows such an action in the project server
2003, I thought the default is to disallow team members to do such
things, also all managers can see all projects in project view, which
also as i understand shouldnt be like that.
Can anyone help me find out what i configured wrong.
We're using MS project 2003, with MS project professional 2003, and
Microsoft web access.
Thanks.

 

[Robert Simmons]

Thanks for the responses, I found my answer after all:

While Microsoft does not recommend installing Analysis Services on SBS for
using with project server, it is supported. The reason for not being
recommended is that SBS must be configured as a domain controller, and the
OLAP processing is capable of fully occupying all CPU's on a given server.
That being the case, the entire domain may become unresponsive at this time
(for example, Exchange will seem to be down temporarily.) While Analysis
Services does ship with SBS, the install is apparently hidden in a folder on
the Premium Technologies CD. However, the full enterprise features are not
available with this edition of SQL Server, and you're basically forced to
purchase and create a fresh instance of SQL Server Enterprise-- to the tune
of about $1500. I'll follow up later with how the hardware responds, but
I'm confident that dual Xeon processors should be sufficient for a devt
environment with less than 5 users.

Yes, Reporting Services is a different add-on from Analysis Services. The
former being a BI competitor with Crystal Reports or Business Objects.

But I thought Analysis services was different from Reporting services or
has everything been renamed?

Certainly SBS can get busy and if Analysis services (Reporting Services?)
can be run, then make sure to schedule cube building over-night.

--

Rod Gill
Project MVP

 

[Steve Foster [SBS MVP]]

But I thought Analysis services was different from Reporting services or has
everything been renamed?

Certainly SBS can get busy and if Analysis services (Reporting Services?)
can be run, then make sure to schedule cube building over-night.

Sorry, I saw the bit about buying separately, and misread "Analysis" as
"Reporting".

Analysis Services is part of SQL Server Standard, so is included with
SBS2003 Premium.

Although, IIRC, Analysis Services is not selected for install by default
during SQL Server Setup.