Re: What version of SQL is on SBS R2 Standard and can I use it?
- From: Daveinfla <Daveinfla@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 2 Dec 2007 17:32:00 -0800
I followed your instructions and successfully installed SQL Express, however
I have a couple questions now that it's up and running.
During the application install the applicaton didn't reconize the default
instance (SQLEXPRESS) which was created so he had me re-run the setup
selecting the acutal radial labeled "Default Instance". This created one
called MSSQLSERVER which the application not only found, but now found the
SQLEXPRESS and two MSDE instances.
The question is since I'm not using the SQLEXPRESS instance can I get rid of
it? If so, HOW? It's currently using 107,300K of memory.
Next question..as soon as I configured monitoring it started complaining
about something using to much memory. A check indicated the the MSSQLSERVER
instance is using 530,064K of memory! How do I adjust this and what should it
be adjusted to?
Surprisingly the MSDE (Sharepoint and Monitoring) are using less then
60,000K each.
Thanks,
Dave
"bass_player [SBS-MVP]" wrote:
Just accept the Default instance called SQLEXPRESS (it actually is called a.
named instance but default for SQL Express). A user level account works
fine. This is something new for 2005 as you need to have an account with
administrative privileges in prior versions. The "sa" account is used for
super administrative purposed within SQL Server and is not the same as the
user-level account you've mentioned. That one is a service account. Mixed
mode authentication has something to do with connection settings when
connecting to SQL Server - whether you would like to use a Windows account
or a SQL Server acount. Collation settings have something to do with storing
data in your database and it even affects case-sensitivity of data. Just
use the default collation setting (Latin1_General) for your case. User
instances can be used so you can name your SQL Server/MSDE installations and
manage them independent of the other. If you are installing SQL Server
Express and you are using the same instance name as an existing one, it will
prompt you for an upgrade. Otherwise, you can have MSDE and 2005 Express
instances on your SBS machine. For built-in SBS applications like
SBSMONITORING, upgrading to SQL Server 2005 is not supported
Hope this helps.
"Daveinfla" <Daveinfla@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7C459752-CF28-4E8F-80EE-E0E18DDC6248@xxxxxxxxxxxxxxxx
Found a doc that steps me thru a typical install but have a couple
specific
question, one was the authentication but my vendor already specified using
sql authentication and the document kind of leans towards that.
Do I install SQL Express as a "Default instance"? I assume this is OK
since
I believe this calls it SQLExpress and shouldn't interfere with anything.
This doc suggests using a user level account, i.e. sqlexpressuser for
security reasons. yes/no?
The author also suggested Mixed mode (SQL authentication), which requires
the assignment of a password to the sa account (duh!). Already covered
above.
What about Collation Settings? SQL collations for compatibly with previous
versions or the default Latin1_General? Does the fact that I'm upgrading
from
MSDE on one application and MS Access on another have any bearing on this
choice?
Can I Enable User Instances?
Last does this replace/upgrades the MSDE on SBS 2003 STD or is it a
parallel
install which will require moving the SBS instances manually. I believe I
read the later was the case but I can't find it now.
Thanks,
Dave
"Daveinfla" wrote:
Thanks for the answers guy...I did some further investigating, called the
vendor, and it's recommend I go with SQL2005 Express as it allows for up
to a
4GB database vs. MSDE which only supports 2GB. There no where near that,
but
nothing like planing ahead.
Two questions:
1. Can someone point me to a white paper explaining step by step on how
to
install SQL2005 Express on an existing SBS 2003 Standard server?
2. There are two versions listed for download, one with and one without
advanced services, and a toolkit. From what I can tell, running as a
backend
server I should use the advanced services version, it this correct? Do I
need
the tools?
Thanks,
Dave
"Steve Foster [SBS MVP]" wrote:
Daveinfla wrote:
OK I'm a bit light on the SQL training, OK a lot; I use the paint by
number
method!
I'm setting up a new server for a client which was ordered with SBS
2003 R2
Standard, of course as luck would have it we discovered after the fact
they
have two applications that use SQL databases. Actually one is
currently
configured to use MSDE 2000 and the other is using Access but will
support
SQL and we will be migrating that to SQL in the near future.
If the application vendor supports MSDE, then you're fine with MSDE.
If I'm not mistaken SBS 2003 R2 ships with MSDE installed for running
monitoring, SharePoint and one other instance. What version of MSDE is
it
and
can it support 2 more instances? Keep in mind the two applications
will
only
have 2 users accessing them at any given time; it's a very small
office.
You cannot legally use the MSDE that ships with SBS for hosting
anything
but the existing applications. That's a licencing restriction on MSDE.
However, you _can_ install another instance of MSDE if the application
vendor is shipping their product with MSDE, since that's licenced
independently to the application vendor (MSDE licencing is a bit weird,
even by MS standards).
Take the following into consideration when making recommendations.
I've been supplied instructions from the vendor on how to move the
application from the current server (desktop) running MSDE 2000 to a
new
server with the following options:
Option 1: Install on a full version of SQL Server 2005
Option 2: Move from MSDE to MSDE (old server to new server)
Option 3: Move from EXPRESS to EXPRESS
Option 4: Move from MSDE to EXPRESS
From what I've read EXPESS ships on SBS 2003 R2 Premium, silly me I
thought
SBS Premium shipped with a full version of SQL, but $500 extra is a
lot to
pay for Premium just to get SQL EXPRESS and since it's a very small
office
I'd like to avoid that option if possible.
SBS2003 R2 Premium includes SQL2005 Workgroup. This is not the same as
SQL2005 Express. Express is the 2005 equivalent of MSDE.
What further confuses me is the fact that I've read EXPRESS is a free
download. Can it be installed on SBS Standard and used at the same
time
MSDE
is running? If so, doesn't that just leave ISA at a $500 price tag?
SQL2005 Express is indeed a free download.
It would be a possibility for the Access migration you're planning.
Since your application vendor appears to support SQL2005 Express as
well
as MSDE, you can choose whichever suits you better for that (I'd simply
go
with the vendors preferred choice).
--
Steve Foster [SBS MVP]
---------------------------------------
MVPs do not work for Microsoft. Please reply only to the newsgroups.
- Follow-Ups:
- Re: What version of SQL is on SBS R2 Standard and can I use it?
- From: Robert Li [MSFT]
- Re: What version of SQL is on SBS R2 Standard and can I use it?
- Prev by Date: Re: Master Browser on MultiHomed SBS 2003 with multiple subnets ?
- Next by Date: Re: file access to sbs 2003 within outlook and out -insufficient resou
- Previous by thread: Re: Fax services install
- Next by thread: Re: What version of SQL is on SBS R2 Standard and can I use it?
- Index(es):
Relevant Pages
|
