Full text search comes by default with sql licensing and that does not need a separate license.

Check for any firewall settings that prevent the client connections.

For clustered environment it is ok that you have done in the active instance alone as cluster is OS mirroring the change should have gone to the other server on...

To my knowledge SQL Server never uses page file when RAM is readily available. You can check this with perfmon counters.

As Gail shaw says you need to monitor the disk IO performance of the server and see if there is heavy load on it.

Gail: I meant that the disk was...

Yes open cursors which contains objects that are either being updated/inserted/deleted can cause deadlocks within the database. you need to handle them using proper transaction settings

Data loss in not possible since tempdb has only hash tables.

Use this script to kill alll user connection to database and then do the restore

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=24

I hope your network guy is right when you say active/active cluster. Use named instances in active/active clusters.

Yes when you say that the log file has got moved to default location without your knowledge then yo need to check what has happened to prevent. Then as said...

You can check if its a NTLM or Kerberos authentication using the DMV sys.dm_exec_connections. What you say is right this is due to a SPN issue first check how default...

Can you post the metadata of the CaseNum table?

Check the clinet connections. They too should have named pipes protocol enabled. As mentioned earlier named pipes is disabled by default in sql server installation.

Better option is to detach, copy to the other server and attach there. Then move the logins to the new server by scripting them and then remove the orphan users...

Try using query analyzer to see if the connections succeeds. Also from the server check if remote connections are set to on also try my previous advice of creating the...