There are two ways to do this one you create a database do your SSIS and then run aspnet_regsql utility on the database. If that is not right then...

That may relate to how it was delpoyed at your place because I remember reading Project Server 2007 installs 10 or 12 databases by default so I think you are...

That dialog box means there is a lot of permission that you need to define. Check the...

If you must drop those databases ask for it in writing and get your boss to approve it because in the 2003 version of Project Server the CUBES are .sql...

You are in SP2 so that is not the issue so it must be related to connection and protocols. Here are two support articles for how to fix it.

http://support.microsoft.com/default.aspx?kbid=315159

http://support.microsoft.com/kb/328306/

I have given you an implementable plan now you need to look at your processes and design and build a solution. The first step is to build an...

If all you need is staging table you can run all three processes separately when one package is completed you start the run for the second and third. What...

You have an interesting problem that cannot use the all or none ADO.NET Command object Transaction operation and you cannot use unit of work transaction with SavePoint because you want...

Your application must be running Excel with SA permissions instead of the Asp.net runtime so you need to find the code running Excel and add Asp.net to the folder holding...

No you cannot use anything SSIS from client tools install but you can use the developer edition for Dev and QA, so you can run your main license for Production....

If Reporting Services is having problem with a query returning only 60 rows then you may be using local temp tables which it does not handle very well. If...

Now I have covered all you need so go do some work because you should not be using SSRS at this level if you don't know the basic. Here...

You need to verify that both databases are installed and spend time with the link below because most things you need to do are covered. If you don't know...

You need both databases so you need to rerun setup and you also need Asp.net because it is used to run Reporting Services configuration.

You cannot run SSRS without ReportServerDB and ReportServerTempDB if you have not installed both you need to rerun setup to install both, you can also run one of the SSRS...