ISQL fails to connect to local machine. OSQL works fine.
-
G'day all,
I'm having an issue here where ISQL is unable to connect to the local sql instance, however OSQL is perfectly capable.
ISQL on the local machine can connect to SQL instances on other boxes and ISQL on the other boxes can connect to SQL on the machine in error.
I get no error messages at the command prompt, none in event viewer and none in the SQL log. I simply type isql, it asks for a password and after I enter it (correctly or incorrectly) is simply shows the command line again.
Has anyone seen this or know where I should look for the specific relationship between isql and the local sql instance?
Thanks in advance,
-
Did you try typing something in the window might be it would have got connected. Check that and let know.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com -
Not sure what you're talking about but this is what I get using ISQL on the local box(see below)
D:\>isql
Password:
D:\>isql -Sdbserver
Password:
Msg 18456, Level 14, State 1:
Login failed for user 'admcharles'.
DB-Library: Login incorrect.
D:\>
So if I use ISQL on the local box to the local SQL instance, type in my password and wrong or right it gives me nothing but the next command prompt. I then use ISQL on the local box to a remote server and it at least responds to a wrong password.
-
Just try this and let me know isql -E -S.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com -
Sugesh,
I tried that but again saw nothing
D:\>isql -E -S
password:
D:\>
However I ended up going into the cliconfg and changing the order of the network connections from TCP/IP -> named pipes to named pipes -> TCP/IP restarted SQL and it worked.
Its a mad mad mad world.
-
Ok i dint remember that it would be a network protocol problem too.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com -
Do NOT use ISQL!!! It is severely deprecated compared to OSQL. I'm not even sure why they left the bloody program available. And, don't confuse ISQL with ISQLW which is Query Analyzer.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Intro to Tally Tables and Functions
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply