As with anything licensing, it is best to speak to MS directly or contact your MS reseller.

General rule of thumb is anyone who accesses a development SQL server must have...

This is data collector and the management data warehouse.

I would first start by checking the configuration, under management - data collection - (right click) management data warehouse.

EXEC sp_srvrolepermission 'dbcreator';

EXEC sp_dbfixedrolepermission 'db_backupoperator';

DBCreator can only restore while db_backupoperator can backup.

Easiest thing to do is add the user to the model database with db_backupoperator and then when a new...

That is a totally different schema and set of data to what you have provided all ready.

Please post the correct DDL and the correct data along with your expected outcomes...

There is no BIN folder in SSRS as your not creating an application.

All you need to do once you have configured the target server URL and developed the report is...

You should see records like this

Recovery of database 'DBName' (DBID) is 0% complete (approximately 124308 seconds remain). Phase 1 of 3. This is an informational

message only. No user action...

;WITH CTE AS

(

SELECT DISTINCT branch, groupid FROM companies where groupid <> 0

)

SELECT

branch,

sum(num)

FROM

(

SELECT branch, count(groupid) as num FROM companies where groupid = 0 group by branch

union all

SELECT branch, count(groupid) as...

Thats right, you have two records for branch 2 in the sample data

But checking your expected results you only want 1, what is the logic to only get 1 and...

SELECT branch, count(groupid) as num from companies group by branch

I have attached the quick reference guides to licensing for 2008R2 and 2012, you might still be able to purchase 2k8 licenses but if not you will need to follow...

Thanks to Lowell for the image

Keep your eye on the SQL error log, it should post the current step and estimated time left on the recovery process.

If you could read the second link in my signature on posting code it will help us out in future as we will have readily consumable data to which anyone...

Sample data in consumable format

DECLARE @Table1 TABLE (RPTTypeCode CHAR(2), Firstname VARCHAR(50), LastName VARCHAR(50), BarrowerID INT, LoanTransID INT)

INSERT INTO @Table1 VALUES ('B1','Anu','k',1,1),('C1','Swetha','SS',2,1)

DECLARE @Table2 TABLE (LoanAppID INT, LoanTransID INT, LoanNumber VARCHAR(10))

INSERT INTO...

Technically no, but as its Visual Studio, it might need a reboot to register some components in the GAC.