Hello all,
Can anyone recommend some dependable machines for running Microsoft
SQL Server 2000? This machine may be hit with as many as 75000 to
100000 simultaneous database requests (stored procedures, trigger
functions) at a time so I'm looking to put this database on a good,
solid machine. Thanks in advance.
AlanRefer to this url
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechn
ol/sql/maintain/operate/opsguide/sqlops6.asp
- Vishal
"aminnis" <alanminnis@.yahoo.com> wrote in message
news:eaef7f31.0309151608.36284af4@.posting.google.com...
> Hello all,
> Can anyone recommend some dependable machines for running Microsoft
> SQL Server 2000? This machine may be hit with as many as 75000 to
> 100000 simultaneous database requests (stored procedures, trigger
> functions) at a time so I'm looking to put this database on a good,
> solid machine. Thanks in advance.
> Alan
Showing posts with label machines. Show all posts
Showing posts with label machines. Show all posts
Saturday, February 25, 2012
Machine Recommendation
Monday, February 20, 2012
MAC address
Hi,
I have a win 2000 adv + sql 2000 box. I would like to know if it is
possible to not allow access to the server using some machines MAC address o
r
Name. I know we can do a lot by using logins and other ways, but in my case
I
have no other choice except either MAC or machine name.
Thanks for your help.
SalamHi
Do this at network router level as it is really efficient down there and the
right place to do it.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"SalamElias" <eliassal@.online.nospam> wrote in message
news:FE1C4C5A-84A2-4E21-8669-4EDC5B25FCA9@.microsoft.com...
> Hi,
> I have a win 2000 adv + sql 2000 box. I would like to know if it is
> possible to not allow access to the server using some machines MAC address
> or
> Name. I know we can do a lot by using logins and other ways, but in my
> case I
> have no other choice except either MAC or machine name.
> Thanks for your help.
> Salam|||This is my problem, I have no control on the router.
So as I said I have no other choice rather thatn machine name or mac adresse
Thanks
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> Do this at network router level as it is really efficient down there and t
he
> right place to do it.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "SalamElias" <eliassal@.online.nospam> wrote in message
> news:FE1C4C5A-84A2-4E21-8669-4EDC5B25FCA9@.microsoft.com...
>
>|||Hi
If you have Windows 2003 (preferably with SP1), you can use IPSec at OS
level to filter the traffic. Look up IPSec on technet for more information.
No an elegant solution, but it is the only thing that you could do.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"SalamElias" <eliassal@.online.nospam> wrote in message
news:E2528C86-EFEF-43E4-A998-EDC6F6153136@.microsoft.com...[vbcol=seagreen]
> This is my problem, I have no control on the router.
> So as I said I have no other choice rather thatn machine name or mac
> adresse
> Thanks
> "Mike Epprecht (SQL MVP)" wrote:
>
I have a win 2000 adv + sql 2000 box. I would like to know if it is
possible to not allow access to the server using some machines MAC address o
r
Name. I know we can do a lot by using logins and other ways, but in my case
I
have no other choice except either MAC or machine name.
Thanks for your help.
SalamHi
Do this at network router level as it is really efficient down there and the
right place to do it.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"SalamElias" <eliassal@.online.nospam> wrote in message
news:FE1C4C5A-84A2-4E21-8669-4EDC5B25FCA9@.microsoft.com...
> Hi,
> I have a win 2000 adv + sql 2000 box. I would like to know if it is
> possible to not allow access to the server using some machines MAC address
> or
> Name. I know we can do a lot by using logins and other ways, but in my
> case I
> have no other choice except either MAC or machine name.
> Thanks for your help.
> Salam|||This is my problem, I have no control on the router.
So as I said I have no other choice rather thatn machine name or mac adresse
Thanks
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> Do this at network router level as it is really efficient down there and t
he
> right place to do it.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "SalamElias" <eliassal@.online.nospam> wrote in message
> news:FE1C4C5A-84A2-4E21-8669-4EDC5B25FCA9@.microsoft.com...
>
>|||Hi
If you have Windows 2003 (preferably with SP1), you can use IPSec at OS
level to filter the traffic. Look up IPSec on technet for more information.
No an elegant solution, but it is the only thing that you could do.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"SalamElias" <eliassal@.online.nospam> wrote in message
news:E2528C86-EFEF-43E4-A998-EDC6F6153136@.microsoft.com...[vbcol=seagreen]
> This is my problem, I have no control on the router.
> So as I said I have no other choice rather thatn machine name or mac
> adresse
> Thanks
> "Mike Epprecht (SQL MVP)" wrote:
>
Subscribe to:
Posts (Atom)