Server Not Found 1

[extempore]

I am trying to connect to a SQL server database through a command file from a proxy machine. It always says "Specified Server not found". But when I ping it from that machine with the IP address of the server I get a response back. Do I need to have a CLient utility installed on a machine to access a SQL Server database or is this probelm becos of something else? Help appreciated.

Extempore

 

[rajeevnandanmishra]

Hi Extempore,
You can access SQL server from any of the Client Utilities, Server Utilities or from any Application which offers the libraries to connect to SQL server.

But i thing you already have one of these on your machine, that is the only reason it is giving the "SQL Server Not found", Otherwise, it must had given some other error.

So, please let us know about the command you are using to connect to SQL.

 

[extempore]

Rajeev this is the script I am trying ...this is a test.cmd file...and i get the error.
cd cd scripts
cd VAIO_Regn
set SERVER=TESTSERVER

isql -Usa -Pft-myer -S%SERVER% -ic:\scripts\TEST\test.sql -oc:\scripts\TEST\test.out

 

[rajeevnandanmishra]

Hi Extempore,
This means that you are already having the client utilities on your machine.
Now try this.
In the command prompt type
isql -Usa -STESTSERVER -ic:\scripts\test\test.sql
and press enter. It will ask you the password. Enter the password. And check if it return you the result or not. If not please let us know the full error message you receive.

 

[extempore]

Rajeev the error is:
CT-LIBRARY ERROR:
CT-CONNECT()IRECTORY SERVICE LAYER: INTERNAL DIRECTORY CONTROL LAYER ERROR: REQUESTED SEREVER NOT FOUND

Hope this helps. Thanks