error enabling AWE to access >2GB of memory

hi,

I am having a problem enabling this, I am getting the error message:

Alter failed. (Microsoft.SqlServer.Smo)

Aditional information:

An exception occurred while executing a Transact-SQl Statement or batch
(Microsoft.SqlServer.ConnectionInfo)

Address Windowing Extensions (AWE) requires the 'lock pages in memory' privilege which is not currently present in the access token of the process.

Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install (Microsoft SQL Server, Error: 5845)

-- end of error.

Prior to this, I opened up gpedit.msc, and associated the Administrator on the "lock pages in memory" policy.

I rebooted the server thinking that this might require it, but it didn't. I still cannot access memory .2Gb.

Any ideas?

cheers.hi,

anyone who can help?

thanks

Error during V7 to 2000 upgrade. Its URGENT

I launch an installatino of SQL Server 2000 on a server, upgrading the V7 original datbase but it failed with error :
"the ordinal 105 could not be located in the dynamic link library opends60.dll"

And the SQL server services cant' start.

Can someone help me ?
It's urgent.I suggest you contact Microsoft -- I cannot find anything that relates to your problem|||I concur. I hope you made some backups somewhere. Have you tried reinstalling 7. Google, books online, my large SQL book says nothing about this.

Get MS engineer on the phone.|||OK, step back.

HOW did you do the "upgrade"?|||Thanks all, I found the way to correct this problem on another forum:

The cause of this is the sqlservr.exe and sqlsort.dll in the MSSQL7BINN directory are still on a hotfix build. When the upgrade wizard tries to stop SQL 7.0 and tries to start SQL 2000 it checks the version on the sqlservr.exe and sqlsort.dll. It is unable to recognise the hotfix versioning and therefore SQL 2000 stops. SQL 7.0 which has already been stopped by this point ends up corrupted.

The following options are available to recover from this problem

a) Pull out the hotfix and go back to Sp3 on the machines where upgrade has not been attempted

b) On the machines that upgrade has been attempted, rename the 4 files that are part of the hotfix: sqlservr.exe, sqlservr.pdb, sqlservr.dbg, sqlsort.dll. Copy the sqlservr.exe and sqlsort.dll from the SQL 2000 install point to the MSSQL7BINN. Re-run setup and allow it to resume from where it stopped before.

c) Upgrade to Sp4 prior to upgrading the machine to SQL 2K.

This error does not seem to be documented anywhere. It is not on Technet and I only got the explanation through a contact in Microsoft

Error during installation process

Microsoft SQL Server 2005 Setup
-

The setup failed to get IID_IIMSAdminBase object. The error code is -2147467262.

Hi there,

I have checked every possible site for this error but unable to find any solution. I received the above alert message during the installation of SQL2k5, Reporting Services. I am using window xp with sp2.

When click OK to alert box then it rollback all installed components of Reporting Services.

Please help.

Cheers,

Zafar.

I believe you have a typo on the error message you have listed. I believe it actually states that it can not find the IIS Imsadminbase. This is the metabase (http://msdn2.microsoft.com/en-us/library/ms525941.aspx). I would remove IIS and then add it back and try the SSRS installation again.

Larry

Error during Copy Database Wizard operation

Do anyone know why i got "Failed to create the share OMWWIZD" error message when trying to copy databases from SQL Server 7.0 to SQL Server 2000?
Thanks!Probably something to do with security permissions between the two servers. If so, pick an administrative account which is the same on both. Run the wizard as that account. Test access by logging into one server and map a drive to the other.

--jfp|||Thanks for the suggestion! I tried using a domain admin to copy the database over and it works! I was using a local admin account before to establish the connection.

Thanks again.

--Speedster.|||hi

I have the same problem but i'm in workstation ...
i used Administrator account in the source server and the destination server, but it doesn't work :eek:

What can i do ?|||- quoting "hi I have the same problem but i'm in workstation ...
i used Administrator account in the source server and the destination server, but it doesn't work What can i do ?"

asanhaji, are you accessing it from a windows workstation via Enterprise Manger? Is it possible to be at one of the servers locally and try to copy it over? Unless you are a logged into the workstation with a domain admin account OR connect to the server in Enterprise manager with a domain admin account you may not have any luck in copying the stuff over. You may need to connect to both servers using a DBO account (typically sa is the user name for it).

slashman

Error connecting

Cannot open database requested in login <DatabaseName>. Login fails.
Login failed for user <DOMAINNAME\User>.
Please help."Viktor Zadro" <viktor.zadro@.tel.net.ba> wrote in message
news:ukzXI7IcEHA.3016@.tk2msftngp13.phx.gbl...
> Cannot open database requested in login <DatabaseName>. Login fails.
> Login failed for user <DOMAINNAME\User>.
>
How are you attempting to connect? Can you reproduce this using Query
Analyzer? What login and database permissions have you defined for this
user?
Steve|||Hello, Steve,
How can I manage SQL Server's users, for example, how to change the 'sa' pas
sword?
Is it can only be done by using 'Enterprise Manager'?
LLF
--
There's an unfinished grid inside my head...
"Steve Thompson" wrote:

> "Viktor Zadro" <viktor.zadro@.tel.net.ba> wrote in message
> news:ukzXI7IcEHA.3016@.tk2msftngp13.phx.gbl...
> How are you attempting to connect? Can you reproduce this using Query
> Analyzer? What login and database permissions have you defined for this
> user?
> Steve
>
>|||LLF,
You can use Enterprise Manager if you wish. Enterprise
Manager is really just executing T-SQL commands for you so
you can manage these through Query Analyzer or any other
tool that can connect to and execute queries on SQL Server.
Passwords are changed using sp_password.
You can add logins using sp_grantlogin for Windows logins or
sp_addlogin for SQL logins.
You can add users to a database using sp_grantdbaccess.
You can find all of these system stored procedures
documented in SQL Server Books Online.
-Sue
On Tue, 27 Jul 2004 10:01:37 -0700, LLF
<LLF@.discussions.microsoft.com> wrote:

>Hello, Steve,
>How can I manage SQL Server's users, for example, how to change the 'sa' pa
ssword?
>Is it can only be done by using 'Enterprise Manager'?
>LLF|||Thanks a lot !
LLF
There's an unfinished grid inside my head...
"Sue Hoegemeier" wrote:

> LLF,
> You can use Enterprise Manager if you wish. Enterprise
> Manager is really just executing T-SQL commands for you so
> you can manage these through Query Analyzer or any other
> tool that can connect to and execute queries on SQL Server.
> Passwords are changed using sp_password.
> You can add logins using sp_grantlogin for Windows logins or
> sp_addlogin for SQL logins.
> You can add users to a database using sp_grantdbaccess.
> You can find all of these system stored procedures
> documented in SQL Server Books Online.
> -Sue
> On Tue, 27 Jul 2004 10:01:37 -0700, LLF
> <LLF@.discussions.microsoft.com> wrote:
>
>

Error connecting

Cannot open database requested in login <DatabaseName>. Login fails.
Login failed for user <DOMAINNAME\User>.
Please help.
"Viktor Zadro" <viktor.zadro@.tel.net.ba> wrote in message
news:ukzXI7IcEHA.3016@.tk2msftngp13.phx.gbl...
> Cannot open database requested in login <DatabaseName>. Login fails.
> Login failed for user <DOMAINNAME\User>.
>
How are you attempting to connect? Can you reproduce this using Query
Analyzer? What login and database permissions have you defined for this
user?
Steve
|||Hello, Steve,
How can I manage SQL Server's users, for example, how to change the 'sa' password?
Is it can only be done by using 'Enterprise Manager'?
LLF
There's an unfinished grid inside my head...
"Steve Thompson" wrote:

> "Viktor Zadro" <viktor.zadro@.tel.net.ba> wrote in message
> news:ukzXI7IcEHA.3016@.tk2msftngp13.phx.gbl...
> How are you attempting to connect? Can you reproduce this using Query
> Analyzer? What login and database permissions have you defined for this
> user?
> Steve
>
>
|||LLF,
You can use Enterprise Manager if you wish. Enterprise
Manager is really just executing T-SQL commands for you so
you can manage these through Query Analyzer or any other
tool that can connect to and execute queries on SQL Server.
Passwords are changed using sp_password.
You can add logins using sp_grantlogin for Windows logins or
sp_addlogin for SQL logins.
You can add users to a database using sp_grantdbaccess.
You can find all of these system stored procedures
documented in SQL Server Books Online.
-Sue
On Tue, 27 Jul 2004 10:01:37 -0700, LLF
<LLF@.discussions.microsoft.com> wrote:

>Hello, Steve,
>How can I manage SQL Server's users, for example, how to change the 'sa' password?
>Is it can only be done by using 'Enterprise Manager'?
>LLF
|||Thanks a lot !
LLF
There's an unfinished grid inside my head...
"Sue Hoegemeier" wrote:

> LLF,
> You can use Enterprise Manager if you wish. Enterprise
> Manager is really just executing T-SQL commands for you so
> you can manage these through Query Analyzer or any other
> tool that can connect to and execute queries on SQL Server.
> Passwords are changed using sp_password.
> You can add logins using sp_grantlogin for Windows logins or
> sp_addlogin for SQL logins.
> You can add users to a database using sp_grantdbaccess.
> You can find all of these system stored procedures
> documented in SQL Server Books Online.
> -Sue
> On Tue, 27 Jul 2004 10:01:37 -0700, LLF
> <LLF@.discussions.microsoft.com> wrote:
>
>

error code sql server

Good morning
MOM server 2005 prompt this message during the installation
Failed to setup database security.
Error code: -2147217900 (user, group, or role 'SC DW DTS'
already exist in the current database)
what can i do in this casehttp://groups.google.co.uk/group/microsoft.public.mom/browse_thread/thread/9
fc353baf7bde8b8/45c77c865aeb54a8?lnk=st&q=user%2C+group%2C+or+role+'SC+DW+DT
S'+already+exists&rnum=1&hl=en#45c77c865aeb54a8
"Djeff" <e.djeff@.free.fr> wrote in message
news:mn.b33c7d5c80e5082d.46131@.free.fr...
> Good morning
> MOM server 2005 prompt this message during the installation
> Failed to setup database security.
> Error code: -2147217900 (user, group, or role 'SC DW DTS'
> already exist in the current database)
> what can i do in this case
>

Error Authentication User Informations

Hey Gang, I get a error message "Authentication Failed for SQL Server
instance: local with friendly name local SQL Server does not exist or
access denied". I have a Just loaded SQL Server on my virtual box and loaded
Microsofts bpa and microsoft security anlyzer. The security scan work but the
bpa scan does
not. I also look at the database,I can get access to and notice a new
database schema(sqlbpa). Any help would be appreciated.

Thanks
Garry DGarry D (garrydawkins@.hotmail.com) writes:
> Hey Gang, I get a error message "Authentication Failed for SQL Server
> instance: local with friendly name local SQL Server does not exist or
> access denied". I have a Just loaded SQL Server on my virtual box and
> loaded Microsofts bpa and microsoft security anlyzer. The security scan
> work but the bpa scan does not. I also look at the database,I can get
> access to and notice a new database schema(sqlbpa). Any help would be
> appreciated.

The message means that the specified SQL Server does not exist. (Or that
your network permissions prevented you from finding it).

If you have SQL Server running on your virtual box, and BPA running on your
host machine and have specified (local) as your SQL Server, that won't
fly. You need to specify the name of the virtual machine.

And, of course, you have to make sure that SQL Server is running.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Thanks, that work perfectly. By Identifying the server name within bpa
it took off and authenticated and is running as we speak.

GDawkins

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Error attaching database file

When I tried to attach a database it failed with:
Error 3624:
Location: recbase.cpp:1374
Expression: m_nVars > 0
SPID: 55
Process ID: 952
Some ideas to recover the file?
Marco,
Could be a corrupt file.
Did you perform a DBCC CHECKDB prior to detaching? Did you detach the
database before or...? What method are you using to attach i.e.,
sp_attach_db or sp_attach_single_file_db? Do you have admin permissions to
do this?
HTH
Jerry
"Marco Frontini" <iunknown@.libero.it> wrote in message
news:es5ZY5QyFHA.2652@.TK2MSFTNGP14.phx.gbl...
> When I tried to attach a database it failed with:
> Error 3624:
> Location: recbase.cpp:1374
> Expression: m_nVars > 0
> SPID: 55
> Process ID: 952
> Some ideas to recover the file?
>

Error attaching database file

When I tried to attach a database it failed with:
Error 3624:
Location: recbase.cpp:1374
Expression: m_nVars > 0
SPID: 55
Process ID: 952
Some ideas to recover the file?Marco,
Could be a corrupt file.
Did you perform a DBCC CHECKDB prior to detaching? Did you detach the
database before or...? What method are you using to attach i.e.,
sp_attach_db or sp_attach_single_file_db? Do you have admin permissions to
do this?
HTH
Jerry
"Marco Frontini" <iunknown@.libero.it> wrote in message
news:es5ZY5QyFHA.2652@.TK2MSFTNGP14.phx.gbl...
> When I tried to attach a database it failed with:
> Error 3624:
> Location: recbase.cpp:1374
> Expression: m_nVars > 0
> SPID: 55
> Process ID: 952
> Some ideas to recover the file?
>

Error attaching database file

When I tried to attach a database it failed with:
Error 3624:
Location: recbase.cpp:1374
Expression: m_nVars > 0
SPID: 55
Process ID: 952
Some ideas to recover the file?Marco,
Could be a corrupt file.
Did you perform a DBCC CHECKDB prior to detaching? Did you detach the
database before or...? What method are you using to attach i.e.,
sp_attach_db or sp_attach_single_file_db? Do you have admin permissions to
do this?
HTH
Jerry
"Marco Frontini" <iunknown@.libero.it> wrote in message
news:es5ZY5QyFHA.2652@.TK2MSFTNGP14.phx.gbl...
> When I tried to attach a database it failed with:
> Error 3624:
> Location: recbase.cpp:1374
> Expression: m_nVars > 0
> SPID: 55
> Process ID: 952
> Some ideas to recover the file?
>