How can i know the server name ?

Hi

While creating connection pool in admin console all the necessary columns i filled .. While ping it , it shows an error ...

An error has occurred.

Operation'pingConnectionPool' failed in'resources'

Config Mbean. Target exception message: Connection

could not be allocated because: [Microsoft][SQLServer

2000 Driverfor JDBC]Unable to connect. DataSource

property serverName must be specified.

It is asking me the server name.. i am using sql server 2000..

While i query select @@servername

1.its showing sqlserver i think that i gived it at the time of installing..

2.When i tried to connect sql server with query analyser it shows only '.' (dot)..

3.While in configuring data source name there it displays (local)..

so actually what is the real server name ..

I tried all the above names but getting the same error...

Would anybody know the solution ?

Thanx..

[1063 byte] By [Reona] at [2007-11-15]