This all depends on the spec of the Production machine in my opinion. If the machine requires a small number of CPUs and a low amount of RAM, it may...

Have a read here:-

http://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-1230-tempdb-should-always-have-one-data-file-per-processor-core/

If you have the media you can choose to just install the workstation components (i.e. Management Studio)

Here's the supported upgrade paths for SQL Server 2014:-

http://msdn.microsoft.com/en-us/library/ms143393(v=sql.120).aspx

It doesn't look like you can upgrade SQL Server 2008 Enterprise to 2014 Standard. It would have to be to either 2014...

OK, taking a random stab here. Have the users tried running IE as an admin?

Hmm, what's the error that you are getting?

Have permissions been granted to the home page itself, not just the site?

Andrew

Have you set the permissions within SSRS itself? In the security tabs on the home page and underlying areas?

Have a read through this article:-

http://blogs.msdn.com/b/psssql/archive/2010/03/24/how-it-works-bob-dorr-s-sql-server-i-o-presentation.aspx

It will explain the error

Hi,

Yes you can setup a DDL trigger to fire when a CREATE LOGIN is executed. Have a look here:-

http://msdn.microsoft.com/en-us/library/f44e5340-1d18-40e9-828e-0ffcca091ae3

Andrew

Yep, there were duplicate SPNs. Found them by using the LDP tool detailed here:-

http://technet.microsoft.com/en-us/library/cc772897(v=WS.10).aspx

Once removed, the server started to use KERBEROS authentication.

Andrew

Sorry but an update of the statistics is necessary as a rebuild index will not update the statistics on non indexed columns.

Andrew

Thank you Gail

Hi,

The best way of thinking about your backups is as a restore strategy. If you "lost" the database, how long would you have to bring it back online and what...

Have a look at sys.dm_os_waiting_tasks as a starting point, should give you some more information.

Andrew

Glad it's sorted, what did you change the value to?