SQL Server Enterprise Edition

Question

Good Afternoon ALL,

Is the SQL Server Enterprise Edition installed on a workstation (Client Desktop, not Server) paid?

If yes, is the Developer edition paid? Is the Developer Edition the recommended version for a client that is going to connect to a Enterprise Edition on a Server for querying?

How the Enterprise Edition works in terms of making a SQL Server Service available or not? It looks at the Operating System and if it is a Windows Server then it installs the database?

Thanks a lot for the help.

Answer 1

Hi,

This MSDN article about SQL Server Editions should help answer some of your questions - http://msdn.microsoft.com/en-us/library/ms144275.aspx , http://msdn.microsoft.com/en-us/library/cc645993.aspx

Both the Enterprise and Developer version cost you, but you dont have to pay upfront. you can use the trail version of both until the trial period expires. There are several components that are availbale in the Enterprise Edition ONLY.

I am not sure i understand your last question. What do you mean by "How the Enterprise Edition works in terms of making a SQL Server Service available or not?" . All SQL Server Editions are designed for Windows OS. Depending on which SQL Server EDITION you install, availablility of certatain featutes/services/components will be decided.

Please refer to the above links, they will help you find out which features are available in which edition.

Hope this helps!

---

Sanil Mhatre | Database Developer | MCTS | If you find my reply useful in any way, please vote it as helpful. If it has helped answer your question, please mark it as Answer. www.sqlwithsanil.com

Answer 2

If I install the Enterprise version on Windows XP, 7, etc, it does not install a database. If I install it on Windows Server 2003, 2008, etc, it will install a database. I assume it looks at the OS right?

I will review the links u sent... But even if I install the "client SQL Server" I have to pay? U don't pay for Oracle SQL Plus Client, for example... You pay for what u install on the Server box...

Answer 3

I marked as an answer but I would like someone to respond to the question about the different behavior of the Enterprise Edition installation on different OSs.

Thanks.

Answer 4

Hi,

i am not sure what you mean by "it does/ does not install database" ? When you install SQL Server ( no matter what Edition), you are installing an instance. so what you get is a set of Services and system database. These system database ( master, msdb, tempdb) will always get created.

Are you talking about these system databases ? or are you talking about demo database like AdventureWorks ?

For you second question, as far as i know, you can install and use the SQL Server management Studio, which is the client , for free.

Hope this helps !

---

Sanil Mhatre | Database Developer | MCTS | If you find my reply useful in any way, please vote it as helpful. If it has helped answer your question, please mark it as Answer. www.sqlwithsanil.com

Answer 5

Hi Sanil,

Thanks for taking time to answer. If you install Enterprise Edition on Windows XP, 7, etc, it will NOT install a database. It will just install an instance DB if you install it on Windows Server. Have u ever tried that?