Gustav Brock
Gustav at cactus.dk
Mon Sep 17 12:38:36 CDT 2012
Hi Rusty and Robert OK, thanks. Got the message. I'll go for an SQL Server 2008 Express install and keep things separated. /gustav >>> rusty.hammond at cpiqpc.com 17-09-12 18:29 >>> 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