"Out of memory" error

I get Run-time error '-2147024882 (8007000e) & "Out of menory" errors when I replicate with SQL server 7. I have made a VB program that uses SQLServer7 SP3's replication. Program gets through most of it's subscriptions but in the last one it gives these error messages. Sometimes when I push ok on that message box, replication continues and end with no errors, but sometimes it just shuts down without ending the replication process.

M.U.RMicrosoft talks about a memory leak in the following Technet article, I don't know if this helps?

FIX: Replication Initialize Method Causes Handle Leak on Failure (Q243741) (http://support.microsoft.com/default.aspx?scid=kb;en-us;Q243741)

Also this article mentions error number -2147024882 (8007000e), I know it's about DTS and Oracle, but at the bottom it makes note that the "Out of Memory" is due to another problem.

PRB: DTS Transfer From SQL Server to Oracle Through OLE DB Provider Shows Ongoing Private Bytes Consumption (Q293320) (http://support.microsoft.com/default.aspx?scid=kb;en-us;Q293320)

"NT Authority/NetworkService" not available as a login

Just installed Server 2003 and then SQL server 2000 followed by sp3a and I'm trying to use an ASP.NET program called DNN which wants "NT Authority / NetworkService" user for access to the database. However, "NT Authority / NetworkService" is not showing
up in the database after installation.
Why is this?
How can I fix it?
Thanks
OK...finally, out of frustration, I just pasted in the name 'NT Authority/NetWorkService'
Start at:
SQL Server Enterprise Manager,
Security node,
Logins node (right click and select New Login),
SQL Server Login properties - New Login,
Paste 'NT Authority/NetWorkService' into the 'name field'
The 'NT Authority/NetWorkService' user was created and it also appears to work properly.
|||You did the correct thing, and Dot Net Nuke should now be happy.
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"oloooooo" <anonymous@.discussions.microsoft.com> wrote in message
news:531707DF-C146-4ED0-A845-978CECF9845C@.microsoft.com...
> Just installed Server 2003 and then SQL server 2000 followed by sp3a and
I'm trying to use an ASP.NET program called DNN which wants "NT Authority /
NetworkService" user for access to the database. However, "NT Authority /
NetworkService" is not showing up in the database after installation.
> Why is this?
> How can I fix it?
> Thanks
>

"NT Authority/NetworkService" not available as a login

Just installed Server 2003 and then SQL server 2000 followed by sp3a and I'm
trying to use an ASP.NET program called DNN which wants "NT Authority / Net
workService" user for access to the database. However, "NT Authority / Netw
orkService" is not showing
up in the database after installation.
Why is this?
How can I fix it?
ThanksOK...finally, out of frustration, I just pasted in the name 'NT Authority/Ne
tWorkService'
Start at:
SQL Server Enterprise Manager,
Security node,
Logins node (right click and select New Login),
SQL Server Login properties - New Login,
Paste 'NT Authority/NetWorkService' into the 'name field'
The 'NT Authority/NetWorkService' user was created and it also appears to wo
rk properly.|||You did the correct thing, and Dot Net Nuke should now be happy.
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"oloooooo" <anonymous@.discussions.microsoft.com> wrote in message
news:531707DF-C146-4ED0-A845-978CECF9845C@.microsoft.com...
> Just installed Server 2003 and then SQL server 2000 followed by sp3a and
I'm trying to use an ASP.NET program called DNN which wants "NT Authority /
NetworkService" user for access to the database. However, "NT Authority /
NetworkService" is not showing up in the database after installation.
> Why is this?
> How can I fix it?
> Thanks
>

"NT Authority/NetworkService" not available as a login

Just installed Server 2003 and then SQL server 2000 followed by sp3a and I'm trying to use an ASP.NET program called DNN which wants "NT Authority / NetworkService" user for access to the database. However, "NT Authority / NetworkService" is not showing up in the database after installation
Why is this
How can I fix it
ThankOK...finally, out of frustration, I just pasted in the name 'NT Authority/NetWorkService
Start at
SQL Server Enterprise Manager
Security node
Logins node (right click and select New Login)
SQL Server Login properties - New Login
Paste 'NT Authority/NetWorkService' into the 'name field
The 'NT Authority/NetWorkService' user was created and it also appears to work properly.|||You did the correct thing, and Dot Net Nuke should now be happy.
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"oloooooo" <anonymous@.discussions.microsoft.com> wrote in message
news:531707DF-C146-4ED0-A845-978CECF9845C@.microsoft.com...
> Just installed Server 2003 and then SQL server 2000 followed by sp3a and
I'm trying to use an ASP.NET program called DNN which wants "NT Authority /
NetworkService" user for access to the database. However, "NT Authority /
NetworkService" is not showing up in the database after installation.
> Why is this?
> How can I fix it?
> Thanks
>

"Cannot find keycodev2.dll or invalid keycode" for certain user account

Hi,

I've created program that sits on a server and provides some reporting functionality. The user submits a SQL Server job that calls this program, passing in some command args.

The SQL Server job is submitted by a C# program that is using a non-sysadmin connection account, therefore it is calling SETUSER to change the job mapping to a local user account, called MYSERVER\SQLServerJobs - I've granted it local admin rights.

Whenever SQL Server attempts to run this job, it's failing with the "Cannot find keycodev2.dll or invalid keycode" error. It's definitely not an install problem, I can run the program from command line using a domain account and it's fine. I guess its a permissions problem with the local account, but I can't put my finger on it!

Again, the local account is in the Administrators group & I've even explicitly granted it rights to the two registry keys

HKEY_CLASSES_ROOT\Interface\{4A4D268A-DF9B-4FC1-8301-D9FEEEF69F9C}

- HKEY_CLASSES_ROOT\TypeLib\{8D43D0B9-C14E-4577-9E67-A9A1EEF82302}

as detailed in some Crystal troubleshooting documents.

Anything else I should check for??

ThanksSOLVED:

I went back onto the machine, logging on as the local user account SQLServerJobs. I then reinstalled the 'CrystallInstaller' setup I had created (just all the merge modules that are required) & made sure the 'For everyone' box was checked - Now works fine.

I reckon i flew through the install the first time round and didn't check the 'For Everyone' box - can't remember to be honest, but would make sense!!