[AccessD] SQL Server 2005 Embedded Edition

Gustav,

I've done this very thing with an SBS 2003 server.  Left the embedded
stuff alone and installed SQL Server 2005 Express.  Have no issues and
been running for 3-4 years.

Rusty



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Monday, September 17, 2012 11:35 AM
To: accessd at databaseadvisors.com; dba-sqlserver at databaseadvisors.com
Subject: Re: [AccessD] SQL Server 2005 Embedded Edition

Hi all

I located this page:
http://technet.microsoft.com/en-us/library/cc794697(v=WS.10).aspx

and the answer to my question seems to be a no-no.

Would I be better off by just installing an instance of SQL Server 2008
Express? This, I guess, can't disturb the 2005 instances.

Any traps here? The server is not very busy.

/gustav


>>> gustav at cactus.dk 17-09-12 18:02 >>>
Hi all

A client runs a Small Business 2008 server.
I need to establish a tiny SQL database which her Access application can
attach via ODBC.

But can I use the "SQL Server 2005 Embedded Edition" that is running on
the server? 
It has two instances running, SBSMONITORING and Microsoft##SSEE. Can I
safely create a new database in either of these?

I have full admin rights to the server.

/gustav

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc.
corporate e-mail system and is subject to archival, monitoring or review 
by, and/or disclosure to, someone other than the recipient.
**********************************************************************