Installing Server 2003

Posted on 2004-11-14
Last Modified: 2010-04-19
I currently use Windows XP on my desktop. Is there a way I can keep XP as my client OS and also install Server 2003 so I can use MS SQL Server.
If this is possible, is there a way I can link my desktop containing the server build to a laptop.

Sorry if this is unclear!

Question by:majeeka
    LVL 11

    Expert Comment

    to run the server on XP, you can use Virtual Server from Microsoft or VMWare.
    i do not understand your 2nd question. can you explain, what you want to do?
    LVL 6

    Expert Comment

    If you have the equipment available, I would build a second system. While it is possible to run server under a virtual machine emulator as suggested, a seperate machine is a better solution. Your question indicates you are intending to use SQL server. You are not limited to a server implementation; you can install a desktop version that should suffice for most SQL needs. If you are needing the more robust features provided by the server version, then you will need the server version. I assume if you are needing the more robust setup, part of the need would be ability to connect to it reliably. WHile the Virtual path will work, it's usually used for test environments, for short durations.
    I'm not knocking VMWare/VPC, or any other offering, just pointing out that setting up a server is a little more complex than a client, with higher hardware needs. The virtual offerings can only emulate the hardware required, and while it does this very well, you might not have enough resources to support both a client and a server implementation running simultaneously, and that a seperate computer for the server would be better.
    Good Luck!
    LVL 104

    Accepted Solution

    What do you want to do with SQL? You can install MSDE on to the machine then put the Client Tools from a SQL Server CD to manage the database. If it is just for development or something like that then MSDE will be fine.

    MSDE is a free download from MS, and you have a license to use it with some editions of Office.


    Author Comment


    I'm about to start developing my first pocket pc application for my final year project.  
    The application is going to be a stock taking (inventory) tool.
    The user will have a desktop interface (pc 1) where they will perform most of the work
    Also there will be a handheld (Pocket PC and scanner) device for actually performing the stock take  
    I will mimic a till system by using a simple gui on another desktop (pc 2).

    I hope to sort out a server later on to connect the 2 pcs but in the meantime is there anything I could do to get going?

    I'll be using SQL and for development.  I will be able to get either windows server 2000 or window server 2003.

    LVL 104

    Expert Comment

    For development purposes MSDE will be fine. It acts like SQL, does the same as SQL just has restrictions on how much data you can put through it, number of connections etc. It is in effect MSSQL for desktop machines.

    LVL 1

    Expert Comment

    Yeah I believe the limit on MSDE is 4gb database, 1 processor, etc - nothing that should hurt a small project (Hell, our database here is only 1.7gb)

    However MSSQL may install on XP - have you tried it? I know Oracle will install, I would imagine MSSQL would at least try :\
    LVL 6

    Expert Comment

    ANd for handhelds or laptop connections to the desktop you can use serial, usb, crossover (laptop), wireless... Etc.
    No need to anything other than the developers addition.
    If you have a handheld, consider using wireless, if possible. You can do some amazing things with handhelds and wireless.
    I worked for a large beverage company where I live, and they had implemented wireless networking and were running thier entire warehouse operation with it; Handheld scanners attached to tablets, and all product coded. Talk about a smooth operation. THey could track a single case from the time it was built until it arrived at the store.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    by Batuhan Cetin Within the dynamic life of an IT administrator, we hold many information in our minds like user names, passwords, IDs, phone numbers, incomes, service tags, bills and the order from our wives to buy milk when coming back to home.…
    Recently, I had the need to build a standalone system to run a point-of-sale system. I’m running this on a low-voltage Atom processor, so I wanted a light-weight operating system, but still needed Windows. I chose to use Microsoft Windows Server 200…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    755 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

    21 Experts available now in Live!

    Get 1:1 Help Now