Windows Essential Business Server 2008 Premiuminc SQL

jannestig

Has anyone implemented nav on the Windows Essential Business Server 2008 Premium edition which includes the free the sql small business edition?

Any positivies or negatives about doing so ?

Alex_Chow

I can't remember where I heard this, but the minimum recommendation is at least SQL Server Standard in a production environment.

But it really depends on the number of transactions and the number of users in your implementation.

jannestig

This page provides the summary

http://www.microsoft.com/sqlserver/2008 ... iness.aspx

The site is quite small and is currently classic DB with 10 users so transactions and posting is not an issue.

Was more curious to see if anyone had experiance with it. and is there any potential risk with the listed limitations

This edition of SQL Server is an entry level edition that is intended for use in small single-server office environments with a small user base. SQL Server Standard for Small Business provides the capabilities of SQL Server Standard Edition, however it is limited to 75 users and has the following additional restrictions for its operating environment:

This version of SQL can only be installed on:
Windows Server 2008 Standard

Windows Server 2008 Standard without Hyper-V

Windows Small Business Server 2008

Windows Server 2008 for Windows Essential Server Solutions

Windows Server 2008 without Hyper-V for Windows Essential Server Solutions

It must be joined to a domain where a single server in the domain must contain all the flexible single master operations (FSMO) roles and is the root of the Active Directory forest,

The domain cannot have trust relationships with any other domains,

The domain cannot have any child domains, and

The sum of users and devices in the domain cannot exceed 75.

The customer may not run instances of the server software, separately licensed or otherwise, at the same time in another operating system environment within the same domain.

Please note that this edition of SQL Server is only licensed by CALs and not per processor, and therefore can only be used to host applications and websites that are accessed by users covered with a CAL.

If this edition of SQL Server does not meet your needs, please see our edition summary page available here. This edition of SQL Server is also available with Windows Small Business Server 2008 Premium.

David_Singleton

Its just a licensing option, not a technology option. It states that its the same software as Standard edition except for the run time conditions, but there is no additional limits on ram or cpu etc.

I can't see why it would be a problem. The problems will come when the client wants to upgrade and find that they can't.