Re: SQL Server and MSDE in same box



Hi Arnie and June,
Thank you very much for the tips and infos. I'm in the process of testing
out several scenarios on my virtual lab just to understand better their
coexistence.

Cheers.
June.

"Arnie Rowland" <arnie@xxxxxxxx> wrote in message
news:%2371bRgf3GHA.1256@xxxxxxxxxxxxxxxxxxxxxxx
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: MSDE, Access, SharePoint... I am not sure where to ask this qu
    ... I has been announced that MSDE is being replaced by SQL Server 2005 Express ... Also I found a document that talks about Migrating from WMSDE to SQL Server ... > Thank you for posting in the SBS newsgroup. ...
    (microsoft.public.windows.server.sbs)

Loading