Is it practical to run SQL Server on a non Server (XP Pro)PC?

Posted on 2009-04-16
Last Modified: 2012-05-06
I wonder if it is practical to run SQL 2008 Std on a very powerful desktop or laptop? running Windows XP? Is anyone out there doing it? I know it's possible, but why do you need server licenses and CAL's to run a dB which won't be accessed directly by users, (only by a ODBC link)
Am I completely off beam here?
The volume of data isn't huge.
Where would the bottlenecks be?
Dual 2.2 processors
1gb NIC
16gb RAM
Forgive my ignorance.
Question by:STOCRIC
    1 Comment
    LVL 39

    Accepted Solution

    You cannot run SQL Standard edition on a non-server operating system.  You can only run express, desktop or workgroup editions.

    "but why do you need server licenses and CAL's to run a dB which won't be accessed directly by users, (only by a ODBC link)"
    Accessing via ODBC is still accessing the database.  You need CAL's because SQL Server is a licensed product and you have to buy the product, and license each client or user to use it.


    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

    This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
    When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
    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!
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    754 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

    20 Experts available now in Live!

    Get 1:1 Help Now