Maybe this link will help even though it is for Always-On - I bel;ieve that the same principles should apply.

http://www.mssqltips.com/sqlservertip/3247/what-you-need-for-a-multi-subnet-configuration-for-alwayson-in-sql-server-2012/

What port are you using - the default 1433 ?

Is the Browser Service running ?

Have you checked Active Directory to verify the SPN ?

hmmm ... moving system databases to another server ...

hmmm ... should not be attempted ???

I would call that Disaster Recovery !

any decent DBA should be able to recover all system...

That is an interesting 'esoteric' fact - WOW !

The line: "DLL must contain function Execute" might be pointing yo an 'extended' stored procedure.

If that os so 'sysadmin' role is usually required. But only the software vendor knows...

It's nice to know that Windows still supports 'old' DOS 5.0 'stuff' !!!

SQL Data Compare might be of some use ...

http://www.red-gate.com/products/sql-development/sql-data-compare/?utm_source=google&utm_medium=cpc&utm_content=brand_aware&utm_campaign=sqldatacompare&gclid=CJq1xMun_74CFSJo7AodYxEAlA

If your SQL Server is on VM/ESX, the 'frozen/thawed' messages could be from what they call a 'VMDK'.

On the other hand it could also be due to having backup 'agent'...

We have performed a multitude of upgrades from SQL 2000 to SQL 2008 R2 (and still habe many more instances to go).

The issue you are experiencing performance wise we uncovered...

What version of SCCM are you running ?

for general information ...

we have multiple SCCM database servers, the main database is in simple recovery mode and is allocated like:

- data...

I just ran into an old article - it seems to be the 'holy grail' (or at least a piece of it) regarding tebp table creation ...

https://www.simple-talk.com/sql/t-sql-programming/temporary-tables-in-sql-server/

just for fun:

select name

from tempdb..sysobjects

where name like '#%'--> table variables

and name not like '#[A-Z,a-z]%' --> temp tables

select name

from tempdb..sysobjects

where name like '#[A-Z,a-z]%'--> temp...

Look at the drive letter(s) in your restore error messages.

Then go into the cluster administrator and see if those drive letters are in the SQL disk group.

If those specific drive...

As for the 'encryption', since this needs to meet the HIPAA requirements, have you met with the Healthcare provider's administrative and legal staff ?

Now a few questions ...

What 'version' of...

is Semantec just scanning the SQL Server as an agent service or is it executing as an enterprise platform for a number of servers in your organization ?

if it is...