SQL Server 2005 Enterprise Edition

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

SQL Server 2005 Enterprise Edition

Author

Topic

sqlslick
Yak Posting Veteran

83 Posts

Posted - 2009-06-24 : 08:29:35

Hey guys,

I got my hands on Microsoft SQL Server 2005 Enterprise Edition. I meet all the system requirements except the OS. I have Windows XP Professional Version 2002 SP2. What are the consequences of installing Enterprise Edition on XP? Would the installation even succeed? Should I just get the Standard Edition? I just need SQL Server 2005 to build some tables and play around with some queries using the Query Analyzer.

Thank you in advanced for your prompt feedback!
John

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-24 : 09:09:49

No, it won't.
You can use either Express Edition (which is free of charge) or Developer Edition (about $50) if you just want to play around...

E 12°55'05.63"
N 56°04'39.26"

sqlslick
Yak Posting Veteran

83 Posts

Posted - 2009-06-24 : 09:43:50

What about the Standard Edition? It lists Windows XP Prefessional in the OS section of System Requirements.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-24 : 09:50:43

Do you refer to this page?
http://www.microsoft.com/Sqlserver/2005/en/us/system-requirements.aspx

It lists SQL Mobile Edition as compatible with Windows XP.

E 12°55'05.63"
N 56°04'39.26"

sqlslick
Yak Posting Veteran

83 Posts

Posted - 2009-06-24 : 11:47:10

I got the info from this page:

http://www.serverintellect.com/support/sqlserver/sql-standard-req.aspx

Maybe I am better off with the Express Edition, but apparently it does not have Query Analyzer. Does the Developers Edition have Query Analyzer?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-24 : 15:03:58

Yes, you can install the Tools either as standalone package, or bundled with Express.
See http://www.microsoft.com/sqlserver/2008/en/us/express.aspx

quote:
* SQL Server 2008 Express with Tools
Core edition of Express that supports development. Includes SQL Server 2008 Database Engine and SQL Server Management Studio Express

* SQL Server 2008 Express with Advanced Services
Extends SQL Server 2008 Express with tools to include support for Integrated Full-text Search and Reporting Services

* SQL Server 2008 Express (Runtime Only)
Includes the SQL Database Engine only and is designed for deployments and ISV redistribution

E 12°55'05.63"
N 56°04'39.26"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources