Thanks for the info ... use the above change on the reportserver database to reset the ServerVersion to 162 and our Reporting services came back - fully operational.

A lifesaver.

Great idea...and how about letting operators see the current operating status in Job Activity Monitor.

Not just from a history point of view.

Yep...getting the Policy "Replace a process level token" updated with the account that the SQL Server Service is running under definitely fixed the problem.

Now able to deploy SSISDB projects to...

You did mean:

Local Group Policy Editor -> Windows Settings -> Security Settings -> Local Policies -> Security Options...

Cheers

Hi Hany,

Did you try the suggested solution:

Enable "Allow inprocess" option in the Oracle Provider for OLE DB.

That resolves the issue.:-)

As I said:

"Looks like the SQL Server restart resolved the issue for me...no need for CU's.""

Looks like the SQL Server restart resolved the issue for me...no need for CU's.

Great script...makes it real easy to 'copy' settings to another server.

Think Microsoft should have this included as a RMB option in SSMS.

txtPost_CommentEmoticon(':-)'); Thanks for the info.

Will be webexing with our Networker product support tomorrow hopefully they can sort this out.http://www.sqlservercentral.com/Forums/Skins/Classic/Dialogs/InsertEmotIcon.aspx?ControlID=txtPost#

1. Is this a native SQL backup or does it use something like LiteSpeed?

Standard SQL Server 2012 backup.

But we are running in...

Did you ever get to the bottom of this issue?

I'm having a similar problem.

SQL Backup of DB to .bak file and subsequent restore works.

If the .BAK file is now 'backed...

Hi eric,

Out of interest, how does using RSSBus compare on reliability and performance when using a SQL Linked Server definition to link SQL Server and Salesforce?

Hi Soren,

Seems as if this topic has gone off the boil!

What did you eventually decide to do?

As I said...really cleaned up...has nothing to show!!!

So where's the new script and the example display?

So what's this? Really cleaned up!txtPost_CommentEmoticon(':w00t:');