a typical day is start at 08:00 finish at 16:30, but then i'm on call 24/7/365 so technically i could work every hour of every day all year if there...

run a profile trace on the server/instance in question

select the blank template from the templates section on the first screen, then select all the events for the audit login failure...

there is a tool called RSScriptor which I've used in the past, start putting in a change versioning / source control mechanisum where you store the solutions and rdl files...

Thanks Markus, I will take a look at them.

the only freeware tools I have found are Quests discovery manager so I can see who is installing SQL out on the network without us knowing and PowerGui for developing...

Sorry, I was focused on the Server 2008 and SQL 2008R2 line at the top.

Perry, while I totally agree with you with migrating should be a full redeployment from the base solutions again or by using tools to script out and redeploy from an...

one thing i would say as well is with the move from 2000 to 2008 I would only copy the user databases not the system databases, dont restore them over...

Sorry Ravi, it seems like I have lost the ebook and I cant find it on Amazon. Sure the title was something along the lines of designing business dashboard...

if you send me a private message i will send on the completed scripts (minus a few things) and a sample of a few reports as a starting block

i will...

@chris-2

The metrics I have so far are

free drive space, db size and free space, job failures, memory usage,a few metrics from sys.dm_os_perf_counters, DDL changes, sys.configuration changes, permission changes, CPU usage,...

if you do need to one day move the SSRS database from one server to another, you will need the ssrs encryption keys.

when you configure SSRS, the last step should...

along with trusts in place, try using the FQDN so \\server.domain.com\share

the data source is set to connect as domain\username, once the connection is made, it then switches from domain\username to domain\vinod.saraswat for example

if that second account doesnt have the access...

Thanks Daniel, I was on the right track. Just copied the tamplate RDL I had created and put it in the correct folder now I dont have to modify the...