Logins exists on both sides of the mirror.

Primary is active 24/7 unless we issue manual failover

Secondary is always restoring

Partner timeout is 60 seconds

No linked servers in the mix.

The jobs all...

I would recommend SQL Compare from Red-Gate, I use it all the time, great tool.

Others are available, SSDT has one, also one from ApexSQL.

There is a freeware tool called DBComparer...

Perry's stairway has all the steps necessary on setting up the cluster from the ground up for Always-On

http://www.sqlservercentral.com/stairway/112556/

The share has to be aware from the cluster, eg on your corporate...

Your loosing quorum so the cluster is going offline.

You need an odd number of objects to get a true quorum, add in a 3rd node or add in a file...

The 18456 error is happening on the mirror node.

The connection strings / connection managers are all set to point to the principal node.

Yeah my thoughts where to have 2 DB's one to load the copy of the tables you needed into

Eg, DB1 has TableA_Today, TableA_Yesterday, DB2 has TableA, run a checksum...

You could also firewall off people from connecting to the DB server by blocking your active port for the instance out for everyone, then only punching a hole into the...

ChrisM@Work (10/27/2015)

anthony.green (10/27/2015)

Ed Wagner (10/26/2015)

I think we always have silver spoons on...

Does the report have to run as the user running the report?

If not then change the data source to use a generic account to run the queries, this is the...

Do you need the full source DB or is it just a subset?

Ed Wagner (10/26/2015)

I think we always have silver spoons on hand. ...

Yep the login is defaulted to master, I am guessing that the initial catalog in the connection string/connection manager is forcing it to ignore the default db and go straight...

Use a central management server or register all your servers in SSMS and run a query against the registered server group

Assessment

Invest