no you wont be insuring against fail over, nothing can insure against that, if it happens it happens, you will need to find the cause of what made the cluster...

why not just create a proc, which executes sp_readerrorlog as a different user, which has access to read the logs, then just grant your users the rights they need to...

I've just checked our cluster (Server 2008, SQL 2008, 4 node, 3 instance) and each instance has its own MSDTC, but I have worked in a multi instance environment before...

You can manually add in the key to the registry if you wish. It's something to do with the kernel so unsure if you have a dodgy install of...

If you have Enterprise/Standard already why not just install SSMS from the installation media and get the full functionality?

The functionality of express management studio is limited, you cant connect to...

just SSMS?

http://www.microsoft.com/en-us/download/details.aspx?id=22985

If you failed over an LS broke, then yes when you fail over again it will break until you fix the issues.

What is the likelyhood of failing over? It...

Just register as self employed on HMRC, can setup as a sole trader, you will get a bill every 6 months to pay self employed NI contributions on top of...

You will need to redevelop the report in VS/BIDS 2005 to use it on a 2005 SSRS installation. Its the old thing of you can upgrade but you cant...

Are you self employed? If so you will need to take a recent correspondence from HMRC in or something along time lines to register for a tradecard to shop...

in sql server config manager, what is the user which is running the SSRS service?

then in SSMS, ensure that this account has access to the databases under the security tab.

pavanpala.vja (5/31/2012)

---

Thanks a lot...anthony.green. i Meet my Requirement.

But Unfortunately i have one more Requirement same like...i need to Insert the Incremented value in other table

Example ...

Andy Hyslop (5/31/2012)

---

I think I see...

If you add in <RSWindowsNegotiate/> under authentication types, then restart SSRS what happens?

So it should look like the below.....

<Authentication>

<AuthenticationTypes>

<RSWindowsNegotiate/>

<RSWindowsNTLM/>

</AuthenticationTypes>

<RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel>

<RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario>

<EnableAuthPersistence>true</EnableAuthPersistence>

</Authentication>

Andy Hyslop (5/31/2012)

---

+10000 !! 😀

I'm quite fond of Banana Bread Beer - Sounds a bit unusual but...