Advice

I am a bit concerned I am not doing everything I can with regards to
security on my SQL2000 server. My current setup is as follows:
SQL server in LAN, Firewall between outside world and the LAN using port
forwarding to pass the SQL Server comms to the server. Server comms is all
password protected, with only read/write/update/insert access granted to any
user outside of the LAN.
What I want to know is, is there anything else I could be doing. For
instance I currently have a separate webserver in a DMZ, should I pass all
SQL comms to the webserver first then use somekind of port forwarding to
pass it on to the LAN?
Thanks for any suggestions anybody might have.What do you mean by 'server comms'?
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"JosephByrns" <josephbyrns@.yahoo.com> wrote in message
news:OyzcrpktGHA.2088@.TK2MSFTNGP05.phx.gbl...
>I am a bit concerned I am not doing everything I can with regards to
>security on my SQL2000 server. My current setup is as follows:
> SQL server in LAN, Firewall between outside world and the LAN using port
> forwarding to pass the SQL Server comms to the server. Server comms is
> all password protected, with only read/write/update/insert access granted
> to any user outside of the LAN.
> What I want to know is, is there anything else I could be doing. For
> instance I currently have a separate webserver in a DMZ, should I pass all
> SQL comms to the webserver first then use somekind of port forwarding to
> pass it on to the LAN?
> Thanks for any suggestions anybody might have.
>|||I mean that all SQL Server requests (i.e. requests for data) from outside of
the LAN are being forwarded to the SQL Server using port forwarding.
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:eDd2C9ltGHA.1508@.TK2MSFTNGP05.phx.gbl...
> What do you mean by 'server comms'?
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "JosephByrns" <josephbyrns@.yahoo.com> wrote in message
> news:OyzcrpktGHA.2088@.TK2MSFTNGP05.phx.gbl...
>

Adressing memory above 1,7 Gb in SQL

Hi everyone,
We are using W2k3 standard x 64 edition in combination with SQL2000 standard
edition.
W2k with SQL2000 systems are also in use.
These machines have 4Gb of RAM, but i can't seem to get SQL to use more than
1,7Gb.
Tried the /3Gb switch in boot.ini en AWE enabled in sp_configure.
Nothing works, am i doing something strange or wrong ?
Rob
How do you check the memory used ? Performance monitor or Task Manager?
Task Manager will show you a wrong value if you use more than 2 Gb of
RAM.
Also how much memory is used by other Apps and/or OS.
Markus
|||Hi Rob,
Unfortunately SQL 2000 Standard Edition has a limit of 2GB worth of memory.
You can check the Maximum Capacity Specifications here:
http://msdn.microsoft.com/library/de...ar_ts_8dbn.asp
Let me know if I can help any further.
Adam J Warne, MCDBA
"Rob Vos" wrote:

> Hi everyone,
> We are using W2k3 standard x 64 edition in combination with SQL2000 standard
> edition.
> W2k with SQL2000 systems are also in use.
> These machines have 4Gb of RAM, but i can't seem to get SQL to use more than
> 1,7Gb.
> Tried the /3Gb switch in boot.ini en AWE enabled in sp_configure.
> Nothing works, am i doing something strange or wrong ?
> --
> Rob
|||Thanks Adam. Now i need to get back to my supplier, he sold me 4 Gb system
with SQL standard.
Rob
"Adam Warne" wrote:
[vbcol=seagreen]
> Hi Rob,
> Unfortunately SQL 2000 Standard Edition has a limit of 2GB worth of memory.
> You can check the Maximum Capacity Specifications here:
> http://msdn.microsoft.com/library/de...ar_ts_8dbn.asp
> Let me know if I can help any further.
> --
> Adam J Warne, MCDBA
>
> "Rob Vos" wrote:

Adressing memory above 1,7 Gb in SQL

Hi everyone,
We are using W2k3 standard x 64 edition in combination with SQL2000 standard
edition.
W2k with SQL2000 systems are also in use.
These machines have 4Gb of RAM, but i can't seem to get SQL to use more than
1,7Gb.
Tried the /3Gb switch in boot.ini en AWE enabled in sp_configure.
Nothing works, am i doing something strange or wrong ?
--
RobHow do you check the memory used ? Performance monitor or Task Manager?
Task Manager will show you a wrong value if you use more than 2 Gb of
RAM.
Also how much memory is used by other Apps and/or OS.
Markus|||Hi Rob,
Unfortunately SQL 2000 Standard Edition has a limit of 2GB worth of memory.
You can check the Maximum Capacity Specifications here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
Let me know if I can help any further.
--
Adam J Warne, MCDBA
"Rob Vos" wrote:
> Hi everyone,
> We are using W2k3 standard x 64 edition in combination with SQL2000 standard
> edition.
> W2k with SQL2000 systems are also in use.
> These machines have 4Gb of RAM, but i can't seem to get SQL to use more than
> 1,7Gb.
> Tried the /3Gb switch in boot.ini en AWE enabled in sp_configure.
> Nothing works, am i doing something strange or wrong ?
> --
> Rob|||Thanks Adam. Now i need to get back to my supplier, he sold me 4 Gb system
with SQL standard.
--
Rob
"Adam Warne" wrote:
> Hi Rob,
> Unfortunately SQL 2000 Standard Edition has a limit of 2GB worth of memory.
> You can check the Maximum Capacity Specifications here:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
> Let me know if I can help any further.
> --
> Adam J Warne, MCDBA
>
> "Rob Vos" wrote:
> > Hi everyone,
> >
> > We are using W2k3 standard x 64 edition in combination with SQL2000 standard
> > edition.
> > W2k with SQL2000 systems are also in use.
> >
> > These machines have 4Gb of RAM, but i can't seem to get SQL to use more than
> > 1,7Gb.
> >
> > Tried the /3Gb switch in boot.ini en AWE enabled in sp_configure.
> >
> > Nothing works, am i doing something strange or wrong ?
> >
> > --
> > Rob

Adressing memory above 1,7 Gb in SQL

Hi everyone,
We are using W2k3 standard x 64 edition in combination with SQL2000 standard
edition.
W2k with SQL2000 systems are also in use.
These machines have 4Gb of RAM, but i can't seem to get SQL to use more than
1,7Gb.
Tried the /3Gb switch in boot.ini en AWE enabled in sp_configure.
Nothing works, am i doing something strange or wrong ?
RobHow do you check the memory used ? Performance monitor or Task Manager?
Task Manager will show you a wrong value if you use more than 2 Gb of
RAM.
Also how much memory is used by other Apps and/or OS.
Markus|||Hi Rob,
Unfortunately SQL 2000 Standard Edition has a limit of 2GB worth of memory.
You can check the Maximum Capacity Specifications here:
http://msdn.microsoft.com/library/d...br />
8dbn.asp
Let me know if I can help any further.
Adam J Warne, MCDBA
"Rob Vos" wrote:

> Hi everyone,
> We are using W2k3 standard x 64 edition in combination with SQL2000 standa
rd
> edition.
> W2k with SQL2000 systems are also in use.
> These machines have 4Gb of RAM, but i can't seem to get SQL to use more th
an
> 1,7Gb.
> Tried the /3Gb switch in boot.ini en AWE enabled in sp_configure.
> Nothing works, am i doing something strange or wrong ?
> --
> Rob|||Thanks Adam. Now i need to get back to my supplier, he sold me 4 Gb system
with SQL standard.
Rob
"Adam Warne" wrote:
[vbcol=seagreen]
> Hi Rob,
> Unfortunately SQL 2000 Standard Edition has a limit of 2GB worth of memory
.
> You can check the Maximum Capacity Specifications here:
> http://msdn.microsoft.com/library/d... />
s_8dbn.asp
> Let me know if I can help any further.
> --
> Adam J Warne, MCDBA
>
> "Rob Vos" wrote:
>