Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
¢ödêmån
Starting Member
32 Posts |
 Posted - 2002-05-27 : 00:30:27
|
OK here's the config :Microsoft SQL Server 2K Enterprise Edition SP2on Windows 2K Advanced Server SP23968MBI've enabled AWEadded /3GB in Boot.iniBut I still get the error message in errorlog.Pls note I have another server, which is as follows but this one is ok.Microsoft SQL Server 7.00 Enterprise Edition SP3on Windows 2K Advanced Server SP24032MBANY TIPS is appreciated. Cheers. --¢ödêmån-- |
|
|
¢ödêmån
Starting Member
32 Posts |
Posted - 2002-05-27 : 00:32:58
|
| Microsoft SQL Server 2K Enterprise Edition SP2 on Windows 2K Advanced Server SP2 3968MB I've enabled AWE added /3GB in Boot.ini But I still get the error message in errorlog. ALSO max memory is 3000MB--¢ödêmån-- |
 |
|
|
¢ödêmån
Starting Member
32 Posts |
Posted - 2002-05-27 : 00:50:12
|
| Found it, "lock pages in memory" right wasn't enabled for the account that SQL Server was running under.http://www.sql-server-performance.com/awe_memory.aspAlthough the other server doesnt require it???Any drawbacks known will this break the other one ???--¢ödêmån-- |
|
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-05-28 : 16:24:39
|
Hmmm.If that permission wasn't enabled or inherited then I would ask if the SQL Server user is a local Administrator on the machine.quote:
Found it, "lock pages in memory" right wasn't enabled for the account that SQL Server was running under.http://www.sql-server-performance.com/awe_memory.aspAlthough the other server doesnt require it???Any drawbacks known will this break the other one ???--¢ödêmån--
setBasedIsTheTruepath<O> |
|
|
|
¢ödêmån
Starting Member
32 Posts |
Posted - 2002-05-30 : 08:03:38
|
| Yes the SQL Account is a member of the local administrator group.--¢ödêmån-- |
|
|
|
|
|
|
unable to allocate 'min server memory' of 3000MB