Thanks for the quick response:

Copy and pasted straight from the config file:

<Authentication>

<AuthenticationTypes>

<RSWindowsNegotiate/>

<RSWindowsNTLM/>

</AuthenticationTypes>

<RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel>

<RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario>

<EnableAuthPersistence>true</EnableAuthPersistence>

</Authentication>

Thanks for the quick response:

Copy and pasted straight from the config file:

<Authentication>

<AuthenticationTypes>

<RSWindowsNegotiate/>

<RSWindowsNTLM/>

</AuthenticationTypes>

<RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel>

<RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario>

<EnableAuthPersistence>true</EnableAuthPersistence>

</Authentication>

Thanks for the quick response:

Copy and pasted straight from the config file:

<Authentication>

<AuthenticationTypes>

<RSWindowsNegotiate/>

<RSWindowsNTLM/>

</AuthenticationTypes>

<RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel>

<RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario>

<EnableAuthPersistence>true</EnableAuthPersistence>

</Authentication>

Spiff (3/30/2016)

---

Have you changed the SSRS authentication method to Negotiate in the rsreportserver.config?

<Authentication>

<AuthenticationTypes>

...

So have set delegation rights for the IIS server following suggestions on this blog:

https://sqlbadboy.wordpress.com/2013/10/11/the-kerberos-double-hop-problem/

Still the same situation. I've attached an SSRS log file in case someone spots a...

Have tried that already, with the same result.

As an experiment I'm going to temporarily disable the Windows Firewall on both servers and test to see what result that might have....

If I open up SSRS Config...

Spiff (3/22/2016)

---

This appears to be an error connecting the report manager to the report server database.

Log on to the the server hosting reporting services and open Reporting Services Configuration Manager...

Jaselnewpar (3/1/2016)

---

There could be a few things going on here, but one thing that I see in your image is that you do not have "User Windows Credentials" checked. ...

Thanks very much for all the replies and in this thread. I've gone back over the application and decided to alter the design ever so slightly so I' don't need...

Luis Cazares (2/2/2016)

Unless you're going to index/filter by those columns, I'd keep them as computed columns. However, the design might be wrong, the quarter should be an attribute of a...

Sean Lange (2/2/2016)

---

M Joomun (2/2/2016)

---

I have a variable, TempQuarterlyPeriod, which has values 1, 2, 3 or 4. Based on the contents of TempQuarterlyPeriod I want to update two other values,...

sgmunson (8/10/2015)

---

M Joomun (8/10/2015)

---

I'm using the SQL below to work out recruitment figures. The query works well, but I now need to build this query into a DotNet application as...

Luis Cazares (8/10/2015)

---

In this case, you don't need to know the types from the columns as they won't matter. The important part is to know the type the function returns.

From...

Thanks to all for your suggestions so far. I've had a chance to speak to the user about how we proceed and I've summarised below.

1. Make full backup of database...