Problem when connecting remotely

[logx]

Hi everyone,

First time poster here. I've been Googling around for quite a bit without any actual success to resolution of my problem.

I am using osql to connect to my remote MSSQL server and that's when the problem starts. I am able to get a prompt for password and telnet to 1433 just fine. However, when I do try to connect:

C:\Program Files\Microsoft SQL Server\80\Tools\Binn>osql -S xx.xx.xx.xx -U test

Password:
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect()).

But when I try exactly this from the server itself:

C:\Program Files\Microsoft SQL Server\80\Tools\binn>osql -U test
Password:
1>

--

Logs don't show up anything interesting. This is Microsoft SQL Server 2005 - 9.00.1399.06.

Any help is greatly appreciated!

 

[vbkris]

are you able to ping the server from your system???

Known is handfull, Unknown is worldfull

 

[logx]

No, not really. ICMP is filtered by the firewall. However, as I've said, I am able to telnet to MSSQL port just fine (as well as connect to some other services, as well as on the "Default Website" that's running off IIS on the SQL server).

 

[logx]

As I've said, any help is appreciated.

 

[logx]

I guess I'll have to seek my answers elsewhere.

 

[mutley1]

Have you tried the -P option in the original command line, or even add a domain account and use -E?

As for seeking elsewhere, with all due respect Sir, we all have our own work to do as well!

Rgds,

M.