Michael Walter-477776 (3/15/2012)

1. Is there any way to configure SSMS to only point to a single server ( my assumption is that there is not - unless you separate out...

was this the only domain controller in the domain or do you have a replicated AD?

if its the only DC then you cant use AD credentials as there is no...

you either need to pass in a null value so that it gets everything, or change the last statement from @parm is null to @param = 2

thanks, will give it a go, the downloading server is a test server so dont think there will be a problem installing the extra component

thanks Howard thats great, it is roughly an hour into downloading that it does decide to time out, i've resulted in trying a number of ftp clients with no luck...

please post the DDL of the tables, the full query and test data and we can help you further.

as a side note to this, apart from winrar, are there any bult in commands like winrar which will split the files into multiple chunks, just thinking if I can...

again with the test1.rdl i still get the right results back from the test data I created in the eailer post using the first query you gave after modifing the...

i have attached the report rdl which I used, just give it a data source which points to the data and then create the query as a procedure and then...

yeah thats the same pdf

will wait for the official release of 2012 to get a bit of play on it before attending the courses

i have just created a sample report based on the query you provided using both a procedure and also the sql text embeded into a data set using a parameter...

all depends on the level you are required to support SSRS

there are lots of good topics by doing a simple google search on SSRS Administration, key things I would say...

the symetric key is an issue as thats one of the things which handles the authentication.

I would suggest completly removing SSRS rebooting and reinstalling and configuring

you could create a policy against the data file facet for the avilable space properties and have it alert you via email

you will need db mail setting up and SQL...

have you removed the username from the error message or is the error saying its a blank user?

Msg 18456, level 14, State 1, Line 1

Login Failed for user ''

or

Msg 18456,...