Can you provide more information please, I dont fully understand what the problem is?

Definitely need to check and confirm the port the instance is listening on.

Can you connect from SSMS on Server1 to the instance on Server2?

Is SQL Browser running on server 2?

What are the server protocols enabled on server2?

Can you telnet from Server1 to Server2?

It looks like it might be trying to use Named Pipes, what are the Server 2's connectivity options set as?

This might work - https://msdn.microsoft.com/en-GB/library/ms174385.aspx

Only try it on a test instance.

Otherwise taking a backup is going to be the best way to go, if they dont have...

Do they not have any backups of the database (.bak files)?

How big is the log file and how big is the data file?

Do you not have a backup you can restore to another instance?

You said "corruption issues", what seems to be the issue/error message?

Could they not then just go and connect via Excel/Access or anything else?

I'm not sure that you could do this. If the SQL login details are in the configuration file and this is freely available then anybody who gets hold of it...

Can you compare query plans across the two?

Can you simplify the TSQL to get it to work and then try and build back up until it causes the problem?

Can...

Can you provide any further information about the parameters in the report? Can you simplify the report to see if you can get it running and build it back up...

Something like this will give a list of users: http://sqlserverzest.com/2013/08/06/sql-server-get-all-login-accounts-using-t-sql-query-sql-logins-windows-logins-windows-groups/

Something like this may give you what your after in terms of connections - http://sqlblog.com/blogs/adam_machanic/archive/2009/08/20/who-is-active-v8-82-harder-better-faster-stronger.aspx

Does sp_who or sp_who2 work.

So something like this doesn't work? - IIF(CONVERT(VARCHAR(10),@date1,101)=CONVERT(VARCHAR(10),@date2,101), 'same day','different day')

Test Script:

Declare @date1 datetime

Declare @date2 datetime

set @date1 = getdate()

set @date2 = Cast('02/29/2016' As DateTime)

Select IIF(CONVERT(VARCHAR(10),@date1,101)=CONVERT(VARCHAR(10),@date2,101), 'same...