Re: AWE and Lock Pages in Memory
Which user account did you add? You need to add the account that sql server
is running under. NT4, wow. I haven't seen anyone running on that in a long
time. I suppose it may have something to do with it but check the account
first.
--
Andrew J. Kelly SQL MVP
"Tman" <Tman@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:79FEA5AA-63C2-4D3A-8479-D244C175789C@xxxxxxxxxxxxxxxx
I am running SQL server 2000 Enterprise Edition on MS Sever 2003 Enterprise
Edition.
I have enabled AWE on the SQL server. I have added the user account to
the
Lock Pages in Memory right under the Group policy editor.
I have the /3GB and /PAE extensions in my boot.ini file and I get an
error
"Cannot use Address Windowing Extensions because lock memory privilege was
not granted."
I am on an NT4 domain, is this why the lock memory privilege cannot be
granted?
.
Relevant Pages
- Re: The Microsoft Search service cannot be administered under the present user accou
... When you changed the SQL-Service to run with Local User account (with admin ... rights), did you make this change in the SQL Server 2000 Enterprise Manager ...
(microsoft.public.sqlserver.fulltext) - Re: Not associated with a trusted SQL Server connection - Windows
... I checked the user accounts on the SQL server and I ... > Using Windows authentication in SQL server DOES NOT mean that as long as you ... and SQL Server accept who you are as your user account claims. ... > include authentication and authorization. ...
(microsoft.public.dotnet.framework.adonet) - Re: SQL open error
... > my connection string. ... > "SQL server does not exist or access denied". ... What user account id the MSSQLServer Windows ... >>> database thru the SQL Server Enterprise Manager. ...
(microsoft.public.dotnet.general) - Re: User account
... MSSearch service? ... Change the password for the MSSQLServer service using the SQL Server ... Is that means the user account for both MSSQKServer and MSSearch ...
(microsoft.public.sqlserver.fulltext) - Re: SQL Server user account
... After reading the online docs about what permissions are required for the user account, I decided it might be easier to uninstall/reinstall SQL Server. ... LocalSystem is almost as bad as Administrator when the machine is a DC. ... SQL Server doesn't generally require any special privileges - so any user account you choose to use for the SQL service account does not need to be an administrator. ...
(microsoft.public.windows.server.sbs) |
|
