I actually did two things to resolve the issues discussed here and it was actually very simple.  

First to get the ODBC to connect from the app server...

Thank you very much for the quick response.

I am still having trouble getting connected to this server.

I have a Database server on Windows Server 2008 box running SQL Server 2008R2 SP3 and the hotfix to...

Thank you very much for the reply. I have looked at this article before, but I think i need to revisit and verify that all the patches, updates and...

Thank you very much for the help. I have marked it as solution

I actually figured out the solution to this

First: The revoke was actually a deny xp_regread and xp_instance_regread to public rather than revoke and deny cannot be over ridden by a...

I have seen this in Oracle once and the problem a missing system variable under environmental variable on the computer. I would compare the two

Go to system properties...

I actually experienced this problem just the other day. It was while the CPU usage was pegged at 100% on the SQL Server from an application that uses it....

Good Idea. Thanks for the reply

I will give it a try.

I looked at the simple talk article by Gail Shaw and it was great. I actually set it up on the test environment and will eventually on production..

I...

Thanks your help is appreciated

Thank you for the feedback

I don't know why the team lead asks to verify. I think he just wants to know that the script work.

Your help is appreciated

Thanks for the help.

I will try getting the code and give you more detail.

Thank you very much It was perfect.

Thank you for all the help

We are using Mirroring.