SQL Server Login

From: Sorcha NiGheannain (smcdermott_at_galwaycoco.ie)
Date: 06/11/03

  • Next message: B Sethu Ramalingam: "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'." 
    Date: Wed, 11 Jun 2003 02:19:56 -0700

    Hi,
    I have created a system DSN specifying SQL Server Authentication.
    The front end of the database is in MSAccess 97. When I try to open the
    front end I get the following error..
    Connection Failed: SQL State: '28000', SQL Server Error: 18456,
    [Microsoft][ODBC SQL Server Driver][SQL Server]Login Failed for user
    (user name).
    I then proceed to click ok and this brings up the SQL server Login
    dialog box and the 'Use Trusted Connection' tick box is ticked. When I
    untick this it allows me to enter the username and password I set up
    under the SQL Server Authentication when creating the DSN. The ODBC
    connection is now successful.
    My question is, is it possible to have the 'Use Trusted Connection' not
    ticked by default, then I would not get the original Connection Failed
    Error.
    Many thanks for any help,
    Sara

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!

  • Next message: B Sethu Ramalingam: "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."

    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)
    • Quantcast