Re: Login failure

From: anees mitha (anees_at_sharekhan.com)
Date: 06/17/03

  • Next message: Bronek Kozicki: "Re: sqlservr.exe unusual activity" 
    Date: Tue, 17 Jun 2003 00:20:08 -0700

    hi dejan

    i got the solution atlast.
    i went through ODBC and i selected 'system DSN'
    from there connection is being established and sql server
    works, but ya the change in registry helped to change the
    authentication mode.

    thanks for yr co-operation and advise

    regards
    anees
    (sharekhan.com)
     
    >-----Original Message-----
    >hi dejan
    >thanks for yr reply and kind co-operation, but the sad
    >part is that the problem still exist. i have tried the
    >solution u had provided but the error still exist. after
    >changing the registry of sql server 7 from 1 to 0 the
    >error popped up is :
    >'connection failure general network error.check yr
    network
    >documentation
    >connectionopen [gethostbyname [][]]' while loggin through
    >sa user.
    >thanks again for the reply. looking forward for yr co-
    >operation.
    >>-----Original Message-----
    >>Maybe you have to change the authentication mode to
    Mixed
    >(I guess you have
    >>mode Windows Only). You can change this in registry:
    >>In SQL Server 7.0, the key is:
    >>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft
    >\MSSQLServer\MSSQLServer\LoginMode
    >>In SQL Server 2000, the key is:
    >>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MicrosoftSQLServer\
    <
    >instance_name>\MSS
    >>QLServer\LoginMode
    >>
    >>In 7.0 valid values are 0 and 1, in 2000 1 and 2. Change
    >the value and
    >>restart the SQL Server. Try to connect with sa login.
    >>
    >>--
    >>Dejan Sarka, SQL Server MVP
    >>FAQ from Neil & others at: http://www.sqlserverfaq.com
    >>Please reply only to the newsgroups.
    >>PASS - the definitive, global community
    >>for SQL Server professionals - http://www.sqlpass.org
    >>
    >>
    >>"anees" <anees@sharekhan.com> wrote in message
    >>news:039301c333f4$02e16ab0$a001280a@phx.gbl...
    >>> thanks for yr reply. but i tried to login through sa
    but
    >>> it dosnt work, it gives the error 'not associated with
    >the
    >>> trusted sql server connection.
    >>>
    >>> anees
    >>> sharekhan.com
    >>> >-----Original Message-----
    >>> >You can use the SA internal login. Hope you know the
    >>> password.
    >>> >
    >>> >--
    >>> >Dejan Sarka, SQL Server MVP
    >>> >FAQ from Neil & others at: http://www.sqlserverfaq.com
    >>> >Please reply only to the newsgroups.
    >>> >PASS - the definitive, global community
    >>> >for SQL Server professionals - http://www.sqlpass.org
    >>> >
    >>> >"anees" <anees@sharekhan.com> wrote in message
    >>> >news:4bcc01c333e0$99ee7ba0$3101280a@phx.gbl...
    >>> >> i have deleted built in administrator & local
    server
    >>> >> connection and i am unable to connect to my local
    >>> server.
    >>> >> how can i establish connection? i am working on
    >windows
    >>> NT
    >>> >> 4 workstation and sql server is installed on the
    same
    >>> >> machine ? thanks for yr reply in advance.
    >>> >>
    >>> >> anees
    >>> >
    >>> >
    >>> >.
    >>> >
    >>
    >>
    >>.
    >>
    >.
    >

  • Next message: Bronek Kozicki: "Re: sqlservr.exe unusual activity"

    Relevant Pages

    • Re: Error "SQL Server does not allow remote connections"
      ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: Connection from remote computer to network SQL Server
      ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
      (microsoft.public.access.adp.sqlserver)
    • ADO.net Orcas Samples Install Problem
      ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, ... or am I better off with a full SQL Server install. ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: OpenDataSource SQL Server xpress problem
      ... I tried your suggestions with some success. ... I tried setting up the .odc file through the Word Mail Merge wizard as ... If I work through the dialog to connect and then click the 'Test Connection' ... but I suspect it's because until recently most SQL Server ...
      (microsoft.public.word.mailmerge.fields)
    • Re: Exception trying to import data from Excel .
      ... An attempt to install Microsoft SQL Server 2005 this week has not gone ... The connection type "EXCEL" specified for connection manager ... to create a connection manager for an unknown connection type. ...
      (microsoft.public.sqlserver.tools)