Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    29

    Unanswered: msde and sql server on the same pc.

    i have app's that connect to a msde database and i have app's that connect to an sql data base. presently i have sql installed on one pc and msde installed on another pc can i install both msde and sql server on the same pc with out effecting the 2 data bases.

    Thank You,
    Thomas

  2. #2
    Join Date
    Aug 2003
    Location
    Andover, MA
    Posts
    256
    My guess is no. But you should be able to use the MSDE database with SQL Server, as MSDE is simply a stipped down version of the SQL Server Engine. Try detaching the MSDE database, copying the files to your SQL Server machine, and attaching them there. Should work.

    Don't forget that you may need to recreate any user accounts from the MSDE side that your app might be looking to use.
    -bpd

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •