Solved app using SQL Server

Posted on 2005-05-02
Last Modified: 2010-04-23
I'm working on a app that uses SQL Server 2000 as it storage utility.  If I wanted to distribute this application to PC's as a single user application and they(the user) did not have an instance of SQL Server, what would I need to do?   Is there a way to include an "instance" of SQL Server?  

I hope I've explained this well enough...
Question by:tobin46
    LVL 9

    Assisted Solution

    Hi tobin46,

      Look at the MSDE 2000 which is the MS Database Engine for desktops... MS website has all the information as does the MSDN for setting and deploying this with applications to desktops, and is what I would recommend doing.

    LVL 9

    Accepted Solution

    MSDE is the right product for you.

    check out the details at the following location

    register for distribution rights of MSDE at


    create MSDE setup project;en-us;325004
    LVL 44

    Assisted Solution

    in answer to your original question, NO you cannot distribute an 'Instance" of SQL Server.  MSDE is the correct alternative, as it is a FREE desktoip version of SQL Server, so you can load ALL of your stored procedures, and Tables from YOUR instance of full SQL Server, into the local instance of MSDE, and all will be right with the world.


    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
    The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now