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...

Out of interest, why do you want to increament journal values, typically when a journal is saved it shouldnt be modified (well thats how finance systems I've worked with in...

does the account running the SSRS service have access to the SSRS Databases?

What authentication types do you have in the RSReportServer.config file under the <Authentication> xml node?

By default the only accounts permitted to connect to a fresh instance of SSRS is anyone in the administrators group of the server where SSRS is installed.

Does the account you...

I have to say I'm enjoying Crabbies alcoholic ginger beer at the moment, but my best thing to drink of late is Hoegaarden Rose

If you backup 2005 and restore over the 2008 RS DB's you will loose your 2008 reports so you wont want to do that.

Options you have are

use a tool...

duplicate post, replies here http://www.sqlservercentral.com/Forums/Topic1308723-150-1.aspx

It will stay in recovery until it has rolled back, rolled forward what it needs to do. Now depending how big the transactions and how long the transactions where...

BrainDonor (5/30/2012)

---

It is possible to log-ship from 2005 to 2008 but I don't think you would want to.

If your Log-Shipping is for Disaster Recovery then what happens if your 2005...

All three of the answers to them can be found on google.

Copy your questions, place them into google and you will get the answer. I have just...

you will need to build it into a variable then pass in that variable

declare @attach nvarchar(max)

set @attach = 'C:\fjnrfrgrjnjnfg'+CONVERT(NVARCHAR,GETDATE(),112)+'.xls'

sp_send_dbmail ......, @file_attachments = @attach