SQL License for Groove

[Steve V]

Hi,

Can anyone tell me which version of SQL 2005 I need to purchase so I can legally run Groove Server 2007?

I will have approx 100 Groove Clients.

Thank you.

Steve.

 

[c1sbc]

As per the Groove Specs at -
http://office.microsoft.com/en-us/grooveserver/HA101945381033.aspx

SQL 2000 (or later) server would suffice. I would presume that these are the
'regular' servers (either Standard or Enterprise) and not the MSDE (desktop)
nor the SQL Express editions.

SBC

--
weblog:
http://weblogs.asp.net/sbchatterjee

Pickup Groove Developer workspaces:
http://www.ctdotnet.org (bottom of page)

 

[robr]

I could be wrong, but I don't believe SQL is a prerequisite for Groove
Server 2007.
It's not mentioned in the requirements here:
http://office.microsoft.com/en-us/help/HA101945381033.aspx

and I can't imagine what you'd need such a database for when all the
info is stored on the desktop.

 

[robr]

My mistake, I was looking at the client piece at the top of that URL,
scrolling down shows SQL 2000 or later.

Other 128 kilobits per second (Kbps) for download and activation of
products. SQL Server 2000 or later. Microsoft Office Groove Server
2007 Groove Relay or Microsoft Office Groove Enterprise Services. IIS
6.0 for Windows Server 2003. SMTP virtual server. Microsoft .NET
Framework 2.0 including ASP.NET. LDAP 3.0-based software for directory
integration (optional).

 

[c1sbc]

this is from the GrooveManagerServerAdministratorsGuide.pdf guide-

Setting Up the SQL Server
The Groove Manager stores most of its data, including user information and
certificates, on an SQL server machine. Set up an SQL server to support the
Groove Manager installation as follows:
Groove Manager - SQL
server
• Windows Server 2003 Standard Edition or Windows Server 2003
Enterprise Edition, with the latest Service Pack required
• Microsoft SQL Server 2000 Service Pack 2 (or later)
Browser on administrative
PC
Internet Explorer (IE) 6.0 or later is running on the administrative
PC, with the following settings in place:
• JavaScript, Cookies, and Forms are enabled
• Minimum Screen Resolution: 1024 by 768 pixels
• Maximum Display DPI Setting: Normal size (96 DPI)
Directory server (optional) • LDAP 3.0-based software
• Microsoft Active Directory, Lotus Domino R5 or later, and Sun
One supported
Groove Relay server • Microsoft® Office Groove® Server 2007 Relay
• Groove Enterprise Relay Server 3.0 or later supported
Microsoft Office Groove
client
• Microsoft Office Groove 2007 recommended, to utilize the full set
of Groove Manager features
• Groove Workspace 2.5, Groove Virtual Office 3.0, or later
supported
For this Machine You Need this Software
Groove Manager System Administrator’s Guide Installing and Configuring the
Groove Manager 20
1. Install an SQL Server on a Windows server machine using your company’s
standard practices for SQL server configuration.
2. In an environment of approximately 5 transactions per user per hour,
configure disk
storage to allow 6 MB of storage per managed Groove user, including space for
account backup.
3. Make sure that the MS-SQL port (usually 1433) is open for incoming
transmissions
from the Groove Manager.
4. Define a unique SQL server host name, preferably a fully qualified Domain
Name
System (DNS) or Internet Corporation for Assigned Names and Numbers (ICANN)
name, such as gmssql.contoso.com.
5. Select an authentication system for the SQL server: native SQL or
NT-based. When
setting up the authentication system, select the ‘Mixed mode’ option.
6. Once the Groove Manager is running with your SQL server, as described in
the
following sections, be sure to back up the Groove Manager databases and log
files
on the SQL server each day to ensure that sufficient space is maintained on
the SQL
server for the Groove Manager database and transaction log.
Note: If the SQL server cannot accommodate the Groove Manager database and
transaction log, Groove Manager operations may cease.
When you are finished configuring the SQL storage, communications, and
authentication
settings, proceed to “Setting Up the Groove Manager IIS Serverâ€.

--
weblog:
http://weblogs.asp.net/sbchatterjee

Pickup Groove Developer workspaces:
http://www.ctdotnet.org (bottom of page)

 

[Steve V]

ok I suppose what I meant to ask was:

do I purchase SQL 2005 Standard 1 CPU

or SQL 2005 Standard 5 User?

As I have 100 Groove clients which is the correct legal requirement?

thanks again.

steve.


this is from the GrooveManagerServerAdministratorsGuide.pdf guide-

Setting Up the SQL Server
The Groove Manager stores most of its data, including user information and
certificates, on an SQL server machine. Set up an SQL server to support the
Groove Manager installation as follows:
Groove Manager - SQL
server
• Windows Server 2003 Standard Edition or Windows Server 2003
Enterprise Edition, with the latest Service Pack required
• Microsoft SQL Server 2000 Service Pack 2 (or later)
Browser on administrative
PC
Internet Explorer (IE) 6.0 or later is running on the administrative
PC, with the following settings in place:
• JavaScript, Cookies, and Forms are enabled
• Minimum Screen Resolution: 1024 by 768 pixels
• Maximum Display DPI Setting: Normal size (96 DPI)
Directory server (optional) • LDAP 3.0-based software
• Microsoft Active Directory, Lotus Domino R5 or later, and Sun
One supported
Groove Relay server • Microsoft® Office Groove® Server 2007 Relay
• Groove Enterprise Relay Server 3.0 or later supported
Microsoft Office Groove
client
• Microsoft Office Groove 2007 recommended, to utilize the full set
of Groove Manager features
• Groove Workspace 2.5, Groove Virtual Office 3.0, or later
supported
For this Machine You Need this Software
Groove Manager System Administrator’s Guide Installing and Configuring the
Groove Manager 20
1. Install an SQL Server on a Windows server machine using your company’s
standard practices for SQL server configuration.
2. In an environment of approximately 5 transactions per user per hour,
configure disk
storage to allow 6 MB of storage per managed Groove user, including space for
account backup.
3. Make sure that the MS-SQL port (usually 1433) is open for incoming
transmissions
from the Groove Manager.
4. Define a unique SQL server host name, preferably a fully qualified Domain
Name
System (DNS) or Internet Corporation for Assigned Names and Numbers (ICANN)
name, such as gmssql.contoso.com.
5. Select an authentication system for the SQL server: native SQL or
NT-based. When
setting up the authentication system, select the ‘Mixed mode’ option.
6. Once the Groove Manager is running with your SQL server, as described in
the
following sections, be sure to back up the Groove Manager databases and log
files
on the SQL server each day to ensure that sufficient space is maintained on
the SQL
server for the Groove Manager database and transaction log.
Note: If the SQL server cannot accommodate the Groove Manager database and
transaction log, Groove Manager operations may cease.
When you are finished configuring the SQL storage, communications, and
authentication
settings, proceed to “Setting Up the Groove Manager IIS Server”.

--
weblog:
http://weblogs.asp.net/sbchatterjee

Pickup Groove Developer workspaces:
http://www.ctdotnet.org (bottom of page)

 

[Tom]

Steve,

I would opt for the 5 CAL edition. The Groove server should "Pool" client
requests for you.

 

[Frances Selkirk [MSFT]]

The Groove clients do not access the SQL server -- only Groove Server Manager
needs access to the SQL server. You do not need SQL Server CALs for the
Groove clients.

 

[Steve V]

ah I see! that clears it up for me then. I can opt for the cheaper SQL 2005 Standard 5 User.

Thanks for the help guys!

steve.

Frances Selkirk [MSFT]<[email protected]> 13/07/2007 20:04 >>>

The Groove clients do not access the SQL server -- only Groove Server Manager
needs access to the SQL server. You do not need SQL Server CALs for the
Groove clients.