You should install the SQL 2005 native client. SQLNCI is the driver that you have to use to access SQL2005 resources. Then you can set it up as a normal...

Here's a base script that you could use.

If you comment out the part that sends email, you could run in query analyzer, paste the text results into an html file...

Do you have reporting services installed?

http://support.microsoft.com/default.aspx?scid=kb;en-us;840709

I would ensure that the "BUILTIN\Administrators" group is removed from the sysadmin server role.

Of course, prior to doing that make sure that you have another group, or account with sysadmin...

When you create the script institute another prior which will check for the existence of the procedure and drop it if it exists.

All databases should have system objects, are the...

You would have installed SQL2008 with Windows Authentication only (the default), as such SQL logins will not work.

Books Online has the procedure for changing the instance to also accept SQL...

Try setting them the same. It should just grab that memory right away, not saying it'll do anything, but it might.

Have you tried going from direct memory allocation to just setting a hard value? Maybe that would help with paging (but then again maybe not).

You could do a side by side certainly. This would require installing SQL Server 2005 x64 on the server, backing up and restoring the SQL 2000 databses to the SQL...

This can be a common error in SQL 2005 x64 standard, as per http://support.microsoft.com/kb/918483

There are links to a couple of hotfixes as regards terminal services potentially causing this issue, but...

You need to have SP3 on 2000 at minimum. To move up to 2005.

Are you running SQL 2000 in WOW64 mode on Windows 2003 x64 edition?

There is no supported upgrade...

Have you checked out the looping article on SQLDTS.com?

This usually happens from looping in the wrong place and so not updating the globalvariable properly (not that I've done it several...

BES has it's own replication topology that has nothing to do with SQL Server. SQL is just the database that happens to sit behind the BES application. There are other...

By BES replication do you mean the replication within Blackberry Enterprise Server?

Yes, they can.

Is there any entry in the event logs to indicate what the issue might be?