Enterprise or not?

Dear ALL,
I'm going to install a new cluster (2 X HP DL380 , MSA1000 Storage) based on
Win 2003 R2 Enterprise and I 'd like to know if I have to install SQL SERVER
2005 Enterprise or standard version could be fine.
Regards
Alberto BrivioStandard will work on a two node cluster but you may loose some other
features you need. Check out the feature comparison in BOL.
--
Jason Massie
Web: http://statisticsio.com
RSS: http://feeds.feedburner.com/statisticsio
"Alberto Brivio" <a.brivio@.adb.it> wrote in message
news:uZci$GBPIHA.1208@.TK2MSFTNGP05.phx.gbl...
> Dear ALL,
> I'm going to install a new cluster (2 X HP DL380 , MSA1000 Storage) based
> on Win 2003 R2 Enterprise and I 'd like to know if I have to install SQL
> SERVER 2005 Enterprise or standard version could be fine.
>
> Regards
> Alberto Brivio
>|||You better determine your needs first...
--
Ekrem Önsoy
"Alberto Brivio" <a.brivio@.adb.it> wrote in message
news:uZci$GBPIHA.1208@.TK2MSFTNGP05.phx.gbl...
> Dear ALL,
> I'm going to install a new cluster (2 X HP DL380 , MSA1000 Storage) based
> on Win 2003 R2 Enterprise and I 'd like to know if I have to install SQL
> SERVER 2005 Enterprise or standard version could be fine.
>
> Regards
> Alberto Brivio
>|||Alberto,
With SQL2005 the version will depend on the number of CPU's rather than the
memory and of course the features you require. If your server has more than
4 CPU's and you want SQL to use them then you must use Enterprise.
Chris
"Alberto Brivio" <a.brivio@.adb.it> wrote in message
news:uZci$GBPIHA.1208@.TK2MSFTNGP05.phx.gbl...
> Dear ALL,
> I'm going to install a new cluster (2 X HP DL380 , MSA1000 Storage) based
> on Win 2003 R2 Enterprise and I 'd like to know if I have to install SQL
> SERVER 2005 Enterprise or standard version could be fine.
>
> Regards
> Alberto Brivio
>

Enterprise Manager Security

I am trying to retrict access to SQL Server by the NT Administratoe, my
question in two parts:
1. SQL Server 2K and Win 2K Server are loaded on the Same Box. Is there a
way to prevent the NT Administrator gaining access to SQL Server through
Enterprise Maanager?
2. If not is there a way to prevent the NT Administrator making any changes
via Enterprise Manager
Any pointers would be gratefully accepted
MOCHi,
Solution is : Remove SYSADMIN role from BUILD/Administrators.
But this will lead in DB MAintenance plan tasks to fail. So try to avoid
this. Still OS Admins will be able to browse the Enterprise manager.
In general "OS Administrators" can do any activity in the Server being he is
the one administering the entire server and normally
he wont do any thing harm.
Thanks
Hari
MCDBA
"MOC" <MOC@.MOC.com> wrote in message
news:#Y14$EBDEHA.2308@.tk2msftngp13.phx.gbl...
> I am trying to retrict access to SQL Server by the NT Administratoe, my
> question in two parts:
> 1. SQL Server 2K and Win 2K Server are loaded on the Same Box. Is there
a
> way to prevent the NT Administrator gaining access to SQL Server through
> Enterprise Maanager?
> 2. If not is there a way to prevent the NT Administrator making any
changes
> via Enterprise Manager
> Any pointers would be gratefully accepted
> MOC
>|||You can remove builtin\administrators but should add back the service
account that SQL Server and SQL Server Agent are running under, and the [
;nt
authority\system] account if you want to use full-text search.
Probably want to review this article as well:
http://support.microsoft.com/defaul...kb;EN-US;263712
Although it talks about clustered SQL Servers most of the info applies to
stand-alone instances as well...
Richard Waymire, MCSE, MCDBA
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:eG0GnoBDEHA.3064@.tk2msftngp13.phx.gbl...
> Hi,
> Solution is : Remove SYSADMIN role from BUILD/Administrators.
> But this will lead in DB MAintenance plan tasks to fail. So try to avoid
> this. Still OS Admins will be able to browse the Enterprise manager.
> In general "OS Administrators" can do any activity in the Server being he
is
> the one administering the entire server and normally
> he wont do any thing harm.
> Thanks
> Hari
> MCDBA
>
> "MOC" <MOC@.MOC.com> wrote in message
> news:#Y14$EBDEHA.2308@.tk2msftngp13.phx.gbl...
there
> a
> changes
>