its not being a sharepoint that matters - its is the fact it is a odata request and web request - it applies regardless of the site you are trying...

have a look at https://support.microsoft.com/en-au/help/4043104/operation-has-timed-out-connecting-to-odata-using-ssis-in-project-onli

Not native - but have a look at third party products - one of which is http://nitrosphere.com/nitroaccelerator/
Never used but have heard of it.
Other options are setting up VPN/Tunnels...

In order for us to even try and help you further and to see what other problems you have (as I do not believe that the sample data and table...

syntax is "delete from table where key = (desired key to delete)"

So what have you tried so far and why has it failed e.g. expected results and the...

And why you think it wont work? or is it that the locations is more than those you mentioned? 

And in any case why do you need it on...

SQL then 

declare @Table table
  ( id   int
  , location varchar(50)
  )
insert into @Table select 1 , 'west'
insert into @Table select...

sorry - misread and though you after some SQL - on SSRS I don't know

Eric, did you run SSMS as administrator ON the server itself? or on your workstation?

Can you also tell us how many rows each table has.

From what you said before I would think GL_Transline is the big table, but GL_Source  I would be inclined...

I notice that your scripts are missing both compression and filegroup information - just to confirm could you please run the following script and supply us with the output.
And...

message is quite clear - access denied 
the user SQL Server instance is running under needs access to the...

I've seen that happen when there is a tiniest time difference on the clock vs domain server. Setting up a dependency on the time service can solve the issue if...

yeah.. with a totally different error 

Send-MailMessage : The SMTP server requires a secure connection or the client was not authenticated. The server
response was: 5.7.0 Must issue a...

That falls under the category of standards (company) and where none exist personal preference.

On my case standards (and personal preference) are
- tables always aliased
- select, from...