duplicate posts, please post replies here

Probably work out cheaper to go CPU then if your installing SQL Standard SSRS, if Enterprise SSRS CAL will probably work out cheaper in the short term, but as more...

So you have no licences what so ever? Or only CPU licences?

Question 1

In your instance, are the reports...

Your welcome, if you can answer the questions in my post, we will be able to tell you which is the best way to licence SSRS for you.

take a look at the offical 70-432 book here

this is the book i used to pass 70-432, it has a range of things in which you can try out on...

is there a trust in place between the two domains?

have users from bb.cba.com been granted access in SSRS to see the folders and reports that they need to?

you would have to build into the query a where statement for run_requested_date in the activity table which brings back the top row when ordered desc to ensure its the...

i'm working on just that

this should help you get off on the right foot

CREATE TABLE DB.DatabaseFileUsage

(

ID BIGINT IDENTITY(1,1),

DatabaseName SYSNAME,

FileID INT,

FileSizeMB DECIMAL(18,2),

SpaceUsedMB DECIMAL(18,2),

FreeSpaceMB DECIMAL(18,2),

LogicalName SYSNAME,

FileLocation SYSNAME,

DateCollected DATE DEFAULT GETDATE(),

CONSTRAINT PK_DB_DatabaseFileUsage PRIMARY...

has the SQL Agent account been granted access to the profile you have created?

granted it should do this itself when you configure SQL Alert System profile but I have seen...

If you install SSRS on your web server then yes you will need a licence for this.

For example I have 5 servers in my data warehouse environment, one which is...

do these mobile phone/electronic swipe cards login to the database themselves?

or do they need to be swiped through a machine and that one machine connects to the database?

They have created the schema right? Also for some reason db_owner hasnt been removed as it? Shouldnt of as they created the DB and with dbcreator should get...

Damn them for updating BOL,

Thanks for that, just so you know its not me going crazy

I would say have they created the schema? or has something gone funny with permissions when the db was created?

i've just tested this on my test bed and working as...

Ah as in public internet facing.

So for an internal intranet with a company user base of 50 I could licence on a user cal/server method and not CPU.

Suppose it then...