Nope.

RedGate can work not just...

Almoust correct.

It looks like the author doesn't use a corner dates finding a such called "pure date difference". I assume that looking into his data and calculated number of days...

Hmm..

If this table actually exists then you have clear permission issue.

Quest, the LiteSpeed creater, resolved this issue:

http://support.quest.com/Portal/Logon.asp?redir=/SUPPORT/index?page=solution&id=SOL40753

You can do it with the latest version of RedGate backup software (Version 6.2 – released August 11, 2009).

Just go to http://www.RedGate.com and download a trial version, which works 14...

I don't think you have to install anything even if you have MDAC application.

The Windows already has MDAC components including SQL Sever native client, you just may want to check...

Why do you want to install SS native client on App server? I am just curious.

As mentioned, the code below should work, you just missed a schema part (dbo), which is reason for your error message.

SELECT * FROM [VSMIADBGP01].[LPB_GreatPlainsUtils].[dbo].[vwADB_LPB_CONSOLIDATED_ACCOUNT_DIV_DEPT_BRANCH_YEAR_2009]

If you break a part off you are required to have a license for it. When you buy a SQL license you are buying all the components on ONE machine,...

Planning a Reporting Services Deployment including Scale-out deployment for SS2005/SS2008:

http://technet.microsoft.com/en-us/library/ms157293(SQL.90).aspx

Configuring a Report Server Scale-Out Deployment for SS2005:

http://technet.microsoft.com/en-us/library/ms156453(SQL.90).aspx

Configuring a Report Server Scale-Out Deployment for SS2008:

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

We are in SS2005 thread, so we are not talking about SS2008 at all.

I would manually delete this login on Server2 and re-apply transfer login script for this login only.

SSAS are always very resource consuming services, so it is better to keep them away of production OLTP cluster.

SSRS required own security model and special attention. SSRS are also required IIS running, which is not good for database server.

I would create application server with IIS and SSRS installed...

You don't suppose to create the users, they have been moved with database already during...