one thought (without downloading your code, so excuse any suggestions you already did) - put "SET NOCOUNT ON" at the start of your script and have the DBA run the...

My opinion - a SQL Server DBA is not likely to get much training from a project.  A database developer would; a database architecht would, but the administration side of...

Step 1 - check the logs.  SSRS logs, SQL Server logs, and Windows event logs.  One of those will have more information about the error.

If the logs are not helpful,...

I agree with Steve here.

On top of that, if you are wanting someone to help with a project, you should provide some details on the project.  Is it strictly a...

I just read the article and I think I am a mix of gatekeeper and flexible.   Some things I see as hard-fast rules that should not be debated with new...

To recovery the master key, if the password is known, you run (the button for adding SQL is missing for me right now, sorry for the poor formatting):

OPEN MASTER KEY...

My first thought is it the same version of DTExec on your machine and the server?

One thing I am reading about that particular error (0x800004005) makes it sound like error...

Since you are on 64-bit and Enterprise Edition, it is likely that the system is running out of  memory to process the data.

I would check things out on the server...

How large is the file?  From what I remember (and a quick bit of googling), SSRS doesn't limit file types by default and I'm not even sure it supports limiting...

Few things i would check before looking at upgrading from 2016 to 2017. My expectation is that upgrade won't help, but it might if it is a 32-bit vs 64-bit...

It seems that it is the two operators following each other "/-" that causes unexpected behavior (not the minus at the beginning).

SELECT -100.0/-100.0*10.0 => 0.1

SELECT (-1*100.0)/-100.0*10.0 =>0.1

SELECT -100.0/(-1*100.0)*10.0 =>...

• This reply was modified 5 years, 3 months ago by Mr. Brian Gale.

My opinion, that should work.  I see no obvious reason why it wouldn't work.

The only case where I can see it being problematic is would be if you set database...

Is sharepoint referencing the SQL Instance directly, or is it referencing the web interface?  If it is referencing the web  interface, then you don't have much to worry about as...

I personally have not seen that error before, but my first thought here is going to be either permissions or a typo.

First step that I would do is if you...

My first thoughts on this are that renaming a SQL instance is tricky and can be problematic.  I would recommend picking a name that works for the new server if...