• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 282
  • Last Modified:

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

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.
0
STOCRIC
Asked:
STOCRIC
1 Solution
 
BrandonGalderisiCommented:
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.

0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now