you can use DBCC CHECKIDENT to change the Identity value

http://technet.microsoft.com/en-us/library/ms176057.aspx

what are you rules for ordering?

You really need a primary key / clustered index to define the order

As mentioned you will not be able to stop the administrator from accessing the database.

This is a good thing otherwise in the possible case of a disaster you may find...

I usually write

\PackageName

And it saves in MSDB fine, you can easily test this by connecting to the integration server in SSMS and expanding MSDB and see if your...

that seems okay,

I don't pu MSDB\ in the package path but it could work

can you see the package when you connect to the reporting server in SSMS?

you can do this through BIDs.

It may be possible through SSMS though I have not tried it.

To save packages in the MSDB;

on the package click Save Copy of Package as --> then enter your server details..

make sure you set the package location to SQL...

I assumed the log that you posted was the system log from the server that is running sql server?

The SQL log can be viewed in Management Studio under Management-->...

I would check the Report server database error logs, there must be a reason why it can not connect to the report server database.

12gb of memory should be plenty to run report server, do you have anything else running on the server.

Also check your System logs for the reason that report server...

The first error in the log is;

have you checked that report...

Another suggestion to save money would be to use Mirroring for the DR server

If you can move the reporting database elsewhere, then if you use Mirroring you will not...

As stated above check the file.

Also it is a warning, not an error so it should not stop your package from executing

I use Textpad for opening large files and it works very well

http://www.textpad.com/index.html

I am not sure that is going to work,

when implementing mirroring you need to restore the database and logs to the MIRROR server with No Recovery

then start the mirroring