Thanks Shafat Husain

I am not allowed to install SSMS on the application server but I used ODBC explained in section below

I cannot ping using the server name but I can ping using the IP address

The SQL Database and Browser services are indeed running

When I attempt a connection through the servlet application and then look at the log in the SQL Server Management Studio, the only entry is as follows;

Backup,Unknown,Log was backed up. Database: Images<c/> creation date(time): 2013/11/23(10:27:57)<c/> first LSN: 322050:59755:1<c/> last LSN: 322050:85856:1<c/> number of dump devices: 1<c/> device information: (FILE=17<c/> TYPE=DISK: {'ImagesLogBac'}). This is an informational message only. No user action is required.

However, I have a possible solution and going to check what you think. I have attempted to connect using Oracles SQL Developer app from the application server to the database server (Ifound a way of doing this by referencing the sqljdbc in SQL Developer) but it gave me a TCP/IP error, although this worked fine from my PC and another server within the network. I also tested the connection using a Windows ODBC connection and this also failed although again it was successful from my PC and the other server within our network. I also tried changing the the server name for the IP address in the ODBC connection attempt but it also failed. Also, I am not allowed to install SSMS on the application server. HOWEVER, I changed the server name with the IP address in the Tomcat JNDI entry and this time SUCCESSFUL CONNECTION!!!! Does this mean that the database server is listening with TCP\IP instead of "named pipe" and perhaps the old server used "named pipe"?

Thanks and I look forward to your feedback.

AJFarroll