Avatar of b1dupree
b1dupree asked on

Install a trial version of SQL Server 2005 Workgroup Edition?

I am looking to install a trial version of SQL Server 2005 Workgroup Edition on a SBS 2003 Server (NOT R2).

The only trial that I can find for SQL 2005 is the Enterprise Edition.

1. Is there a SQL 2005 Workgroup Edition trial available?

2. Is there any difference in OVERHEAD on the server installing Enterprise Edition?  I'm concerned because the SBS Server is (obviously) an Exchange 2003 Server as well as a file server (ISA Sever is NOT installed).
Thanks.
Microsoft SQL Server 2005SBS

Avatar of undefined
Last Comment
Brian Pierce

8/22/2022 - Mon
Brian Pierce

While SQL and Exchnage *CAN* co-exist, SQL is best NOT installed on an Exchange server, both compete for memory and run better the more memory they have. If they are both on the same machine the performance of BOTH may suffer
ASKER
b1dupree

That's definitely my concern and I  understand that.   Thanks for the info.  I will set up a separate Server.  Until I am able to do that, I woulld set up the database temporarily on the SBS Server and then move it.

Is the migration from one SQL Server to another difficult?

Are you aware of trial download of SQL 2005 Workgroup Eiditon?  If not would the Enterprise Edition use more resources than the Workgroup Edition?
elimesika

HI

If you are just evaluating the software, you can use the enterprise edition, I also found no workgroup trial,
 I think that the Q of to put it on the Exchange server is basically a matter of resources, if it is a strong machine, it is possiblle that they both co-exist.

Main differences between Enterprise & Workgroup edition are in http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Enterprise  edition will consume more resources, but you still can minimize it by stopping the services you don't need and set them to be started manually instead of automatically.

Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
ASKER
b1dupree

From your own experiences, can you tell me WHICH services you stopped that you found unnecessary for your needs?
elimesika

Haa

You have bunch of SQL services , just right click on My Computer --> manage --> services and browse for all services started with SQL server.

If you are using no agents , reporting, active directory etc. you can run only the Sql Server service.
Brian Pierce

Why not put SQL in a virtual machine for testing purposes, you can download MS Virtual PC free from
http://www.microsoft.com/downloads/details.aspx?FamilyId=04D26402-3199-48A3-AFA2-2DC0B40A73B6&displaylang=en

Only the SQLSERVER service is required for the BASIC SQL server functionality - if you don't want any jobs to run and even this is not started automatically.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
b1dupree

Good idea on the virtual machine but I am concerned about running Virtual PC on the SBS Server since in all actuality, while the installation of SQL on that server would be temporary based on concerns about available resources,

Right now, the important point that I didn't really make before in posting this request/concern is that I need to run SQL in production ONLY for data entry by just a few users on the network.  (Eventually it will be a full production database.)  So, there won't be any intense usage of the database if that makes a difference.  I think just 2 or 3 users at the most will be inputting data.  Queries will be limited or non-existent for right now.
ASKER CERTIFIED SOLUTION
Brian Pierce

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question