sql 2000 memory win 2003 R2 problem

Last Post 29 Jan 2008 08:30 AM by timcronin. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
timcronin
New Member
New Member

--
28 Jan 2008 12:10 PM
I have a new windows 2003 R2 box with 48 gig of memory. I am running the 32 bit version of sql 2000(I need the dts for now) and Windows 2003. I have my boot.ini set to below

[boot loader]
timeout=0
default=multi(0)disk(0)rdisk(0)partition(2)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(2)\WINDOWS="Windows Server 2003, Enterprise" /fastdetect /pae /NoExecute=OptOut

I have AWE enabled. However when I goto EM and try to change memory it won't let me move the bar. Went to QA and it won't open I get message below

Server: Msg 8651, Level 17, State 1, Procedure sp_configure, Line 42
Could not perform the requested operation because the minimum query memory is not available. Decrease the configured value for the 'min memory per query' server configuration option.
Anyone seen this before?
timcronin
New Member
New Member

--
29 Jan 2008 04:54 AM
Actually it has no memory, will not start
timcronin
New Member
New Member

--
29 Jan 2008 08:30 AM
Fixed it, remove the memory, spend 2 hrs with MS on this, tried everything, removed the memory and it worked. Looks like sql 2000 Ent Ed 32 bit version does not like the memory past 32 gig
You are not authorized to post a reply.

Acceptable Use Policy