Re: SQL Server and MSDE in same box

When you install SQL Server, it will find the MSDE installation and ask you
if you want to 'upgrade'. If you respond 'NO' (which you should), you will
then be asked for a 'name' for the SQL Server 'instance'.

Assuming your computer name is 'MyComputer', the MSDE will be 'MyComputer'
and the SQL Server will be 'MyComputer\Name' -using whatever name you gave
it.

You may need to adjust the memory allocations, or even add memory to the
server. But first get a handle on the type of use, and if there are any
issues with the 'plain vanilla' setup.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"June" <june_1198_sp@xxxxxxxxxxx> wrote in message
news:uXa06Bf3GHA.5024@xxxxxxxxxxxxxxxxxxxxxxx
Hi all,
I'm just curious, can MSDE and SQL Server exist together on the same box?

I'm using MSDE now and want to add a SQL Server onto that same box. MSDE
db
is in use.

Many thanks,
Cheers.




.

Relevant Pages

  • RE: MSDE, Access, SharePoint... I am not sure where to ask this qu
    ... 1.>> What is the difference between MSDE and WMSDE? ... MSDE that is targeted for use by Windows components only. ... isn't SQL Server Express replacing MSDE and WMSDE? ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Re: Put database on Internet
    ... > Once you will be able to connect to MSDE or to SQL-Server, ... > and ADP in the same time as frontends to your database. ... >> will be able to serve as SQL server. ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Need help & support regarding MBSA 2.1 beta 2
    ... Issue: Local Account Password Test ... Check is skipped on Windows XP Home Edition computers. ... SQL Server and/or MSDE authentication mode is set to Windows ...
    (microsoft.public.security)
  • Need help & support regarding MBSA 2.1 beta 2
    ... Issue: Local Account Password Test ... Check is skipped on Windows XP Home Edition computers. ... SQL Server and/or MSDE authentication mode is set to Windows Only. ...
    (microsoft.public.security)
  • Re: Client Tools?
    ... MSDE Manager SQL Tools ... >>> Anyone know if it is legal to install SQL Server Client ... >> Andrea Montanari ...
    (microsoft.public.sqlserver.msde)
Loading