Re: Help with cost and additional software
- From: "Mike Walsh" <englantilainen@xxxxxxxxxxx>
- Date: Tue, 20 Mar 2007 07:26:15 +0200
Let's get our terms right.
WMSDE is the built-in (free) database system for WSS 2.0. It is as I said a
version of MSDE 2.0 and using it you don't have search.
"Windows Internal Database" (earlier "embedded SQL Server 2005 Express
(Windows)") is the built-in (free) database for WSS 3.0. It is (naturally) a
version of SQL Server 2005 Express but does not have any restrictions in the
size of the database (not 2GB; not 4GB). You also get search with WSS 3.0
when using it.
Neither of these products (unlike the version of MSDE 1.0 used in SharePoint
team Services) have any throttling due to a certain number of concurrent
users.
[Note that the version of "Windows Internal database" used with MOSS 2007
*has* the 4GB limit]
My own conclusion is that in a WSS 3.0 single-server enivronment there is
little reason to use a "real" SQL Server 2005. But also that that single
server environment is all you can use with Windows Internal Database and you
can't use the database system for any other of your (non-Windows components)
applications' databases, so as soon as you move to multi-use of the database
system or a separate server for the database you need to go to SQL Server2K
or 2005.
Mike Walsh
WSS FAQ: www.wssv3faq.com / wss.collutions.com
No private questions please (additions to FAQ welcome)
"LB" <LB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:91151C76-2193-4669-8A85-E4878382FFF3@xxxxxxxxxxxxxxxx
Thanks for somewhat clarifying the WMSDE v. SQL Express.
I plan on using stand alone server running WSS3.0 and use the built in
WMSDE. I understood that the d/b size restriction of 2g had been lifted.
Is
it increased to 4g like SQL Express or is it removed all together?
Also, are you saying that WMSDE does not have any search capabilities?
Is there an authoratative document on using WMSDE with WSS3.0. Best
practices, limitations, concurrent users situations, etc......
"Engelbert" wrote:
Actually it ISN'T !
WMSDE is MSDE 2.0 with most of the restrictions removed (2GB size limit;
throttling after more than 5 concurrent users) with only the restriction
that you use it for WSS databases only (and for MS web components))
SQL Server 2005 Express (which might work with WSS but I haven't tried
it)
has similar restrictions to MSDE 2.0 only now the database size limit is
4GB. It still has performance throttling however. For your proposed
numbers
this might not matter but it depends how many of them are accessing the
system at the same time.
Engelbert
"GVB" <GVB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:70EDA24A-A4CD-4567-B991-8E8C3025F51D@xxxxxxxxxxxxxxxx
Nevermind, I just found out that WMSDE IS SQL Server 2005 Express.
Forgive
my
ignorance. ;^)
"GVB" wrote:
MSDE I figured would work, but I don't like losing the text search
function.
Would SQL Server 2005 Express work for that? I haven't looked into
that
new
product at all, so i have no idea what it does. Thanks for the
excellent
response.
"Engelbert" wrote:
1. Provided you run WSS (not SWS!) on the Intranet *it* is fre.
2. You still need to pay licenses for the Operating System. (in your
case no
doubt OS + CALs rather than enterprise.)
3. You can use the built-in WMSDE for the database for nothing. You
then
don't have Full-Text Search. For that you need SQL Server 2K and
that
costs
normal SQL Server 2K license costs.
4. You can't use MySQL or any other database system that isn't SQL
Server 2K
or something (MSDE 2.0 WMSDE) based on that.
5. Templates can be downloaded. Which "those" are I don't know.
Engelbert
"GVB" <GVB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C0BEAD38-73B3-4C2C-9E02-60CFCF6A5193@xxxxxxxxxxxxxxxx
I am in charge of building a small intranet solution for our
startup
bank
of
14 employees. We are running WS3. I am using the free trial of
Sharepoint
Services, but will host it locally once we implement it. My
questions
are:
1. Is there any hidden cost to this? If we have SWS on WS3 already
and are
licensed for WS3, do we need additional licensing for using
Services
(not
portal)?
2. Do we need anything else like MySQL to run this?
3. Can we download those templates on MS's site for Sharepoint
Services?
Thank you for any input.
.
- References:
- Prev by Date: Re: Help with cost and additional software
- Next by Date: Re: Custom EditForm.aspx broken
- Previous by thread: Re: Help with cost and additional software
- Index(es):
Relevant Pages
|
