I don't have SQL server data tools. I have everything else

Regardless of who is using it for what, unless it's development SQL server then you have to pay for the license.

Thanks everyone for responding. Just to let you know the issue was SPN on the server. I deleted it rebooted the server reset it. The detailed info is in the...

Hi,

I have not got the update from what I can see. I did pass this on the Windows admins and they have no idea. I believe we are...

I have found this error, not sure if it's the problem:

2016-05-16 09:10:40.17 Server SQL Server is attempting to register a Service Principal Name (SPN) for...

In Windows I'm seeing "There is insufficient system memory in resource pool 'default' to run this query." and I see nothing in SQL

SharePoint has it's own Web server from the SQL server. In the event log it says "There is insufficient system memory in resource pool 'default' to run this query." and...

Thanks for your help, but as I said earlier I'm a newbie with RS. Can you tell me what you exactly what you mean. Where do I go? I'm sorry...

Yep, and tested the connection successfully. Sorry to be a pain, I'm a newbie to Reporting services.

I've also played around with removing that auto number and reset to point at...

Thanks for that.

The this is when I first had RS working the over application pointed to the reports (SCCM) and I didn't have the reports in RS itself. So I...

I've also in my experience not to do that, but I've never seen a SQL server give all the memory to one instance, particularly when they are all set up...

I must be doing something wrong. When I go to upgrade in only upgrades the Configuration Tools. It won't upgrade the current instances of SQL server. Or it wants to...

Unfortunately I don't have the luxury of another server hence the question. In a perfect world I'd build a new server and then move the databases one by one.

Thanks for...

Thanks heaps

Thanks Vedran, That was perfect 😀