connection problem in osql / isql

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Kam (Kam_at_discussions.microsoft.com)
Date: 08/02/04

  • Next message: Hari Prasad: "Re: connection problem in osql / isql" 
    Date: Sun, 1 Aug 2004 23:19:01 -0700

    I try to run script :
    isql -Usa -Psa -SAAA -iAAA.sql -oLog.log -n

    I got the error:
    1.unable to connect : SQL Server is Unaviable or does not exist
    2.Net-Library error 52: ConnectionOpen (Connect())

    but I can use Query Analyzer and login as sa.

    Why?

  • Next message: Hari Prasad: "Re: connection problem in osql / isql"

    Relevant Pages

    • Re: SP4 Installation Problem on Win2000/SQL Enterprise Edit.
      ... Hmm...didn't helped (the manual MDAC installation)... ... I’ve tried running the script from Query Analyzer as well. ... > Jasper Smith (SQL Server MVP) ... This should indicate why the script failed. ...
      (microsoft.public.sqlserver.setup)
    • Re: Question for Script of users permission.
      ... BUT AS I AM USING THE SCRIPT ON THE MSDE FOR THE LOGIN ... AND PERMISSION OF USERS. ... >> As i have only one SQL server I have check the same on ...
      (microsoft.public.sqlserver.security)
    • Re: Why CAN I log in?
      ... Get into Query Analyzer however you got into it the first time. ... "bing" wrote in message ... Did you suggest login to SQL ... > installed on the sql server. ...
      (microsoft.public.sqlserver.server)
    • Re: Cannot create a SQL user logon
      ... Tibor Karaszi, SQL Server MVP ... >>> Login to Query Analyzer and execute the below query to check if login ...
      (microsoft.public.sqlserver.setup)
    • sa password
      ... I lost my password for sa. ... I login to SQL Server thru the query analyzer using Windows ... I try login to SQL Server thru query analyzer using SQL Server ...
      (microsoft.public.sqlserver.server)