OH, my bad.  But, yay, progress!

SQL browser service (I believe) uses port 1434.  Do you have that port open in your firewall (as was suggested by 

July 26, 2017 at 3:02 pm

#1952916

Since you can connect when you specify the port, I am thinking this isn't a firewall related issue.
Have you tried restarting the SQL browser service?  I beleive (but could...

I am planning on speaking soon... just need to get some demo scripts and some stuff set up.
I am hoping to do a presentation on troubleshooting service broker.  I've...

Where I work, we sometimes have an issue with orphaned users on our test systems.  We restore live user databases to test from backup when we need to troubleshoot some...

I'd enjoy it.  I know I have wanted to start speaking in general and plan on doing a presentation at my local chapter sometime soon.  But I have also been...

Do you have windows authentication turned on on the server?  If so, just add the windows group instead of the individual users.
Otherwise, you would want to create a SQL...

I agree with Lowell here.  I would export all of the dtsx's using powershell.  You should also get all the DTSX's (or ISPAC's) off of your server so you have...

Another thought - does your SSRS server have access to the Excel file?  If it is on a network share, are you using the full UNC filename or the drive...

Try it.  That is the best way to know for sure.  Inserting into a temp table (as long as your tempdb isn't full, which will cause other problems as well)...

Might not hurt to run chkdsk on the drive as well.  Could be the disk is starting to fail.

I could be wrong, but I think the problem is you are doing incorrect data type conversion.
You are dividing an int by an int which will produce an int....