It certainly seems to me that you are experiencing a permissions issue where Network Service does not have permission to access the database server. You should have failed login...

ramana3327 (3/21/2016)

---

When I click on the report manager URL, I received following error

Report server cannot open a connection to the report server database. A connection to the database is ...

On personal note, my 17 year old daughter, is the NH State Champion for Poetry Out Loud[/url]. She gets a trip to Washington D.C. for the national competition...

SQLRNNR (3/22/2016)

---

Had to look up what happened. It's...

Alan.B (3/21/2016)

---

Quick question: I got the standard email saying that someone replied to a comment on one of the forum threads but when I go to that thread the comment...

ramana3327 (3/16/2016)

---

I am seeing errors on server A, where the report service is running but the report server database (From SSRS configuration manager) is pointing to server B.

Are you talking...

Are the SSRS service and the ReportServer database(s) on the same server?

Are there any errors in the SQL Server Log or failed Login messages?

How are the databases being backed up?

Are...

Caveat, I don't know Oracle at all, but I found this thread which may have something for you to try, http://www.sqlservercentral.com/Forums/Topic1052699-391-1.aspx

Can you do a CAST() of the ALPHA to CHAR\VARCHAR in the query? I honestly had never heard of the ALPHA type until reading this post. Doesn't even...

Hugo Kornelis (3/15/2016)

---

This appears to be the same code you also asked help for in this topic: http://www.sqlservercentral.com/Forums/Topic1767785-3411-1.aspx.

In the future, please keep questions on the same issue in the same...

I did some playing around on my local instance. First I set msdb to read-only in SQL Server and SQL Agent wouldn't start. Then I set it back...

Since I replied on the other thread for this issue because I never saw this one, I'll reply here.

The permissions issue is going to be a problem because sp_executesql creates...

Do you have the database code in source control? Do you have any kind of build server (msbuild, jenkins, ...)? If both are ture you should be able...

GilaMonster (3/15/2016)

---

Before you turn it off, make sure it isn't required by your company's audit or...

It will execute in order. The optimizer can re-order joins based on a better plan but it doesn't re-order batches.