sa login

From: Brig (balonso_at_jt-int.com)
Date: 08/23/03

  • Next message: Hal Berenson: "Re: sa login" 
    Date: Sat, 23 Aug 2003 13:02:22 -0700

    Hi,

    I have a SQL2K server running on W2KAS (MSCS). The
    instance is set to Windows autentication only.
    When I try to connect to it remotely through Query
    Analyzer using the SQL login (sa), I get the correct
    error: "Login failed for user sa. Not associated with a
    trusted sql server connection".
    Now if I do the same from the server console itself - I
    connect using the SQL login (sa) - it works.
    I can enter any password or leave it blank it works all
    the time.
    When I run select suser_sname() the login is mine:
    DOMAIN\BRIG (= my NT account).

    Why is the sa directly "mapped" to my NT account? Is it a
    normal behaviour?

    Thanks
    Brig

  • Next message: Hal Berenson: "Re: sa login"

    Relevant Pages

    • Re: SQL Connection with .udl and domain accounts
      ... authentification and SQL ... Login account using a SQL Login name and password that will be ...
      (microsoft.public.sqlserver.connect)
    • Re: log the activity with the actual login credential
      ... You can encapsulate the code I posted in a stored proc so that the app can just past the original AD account after connecting. ... SQL Server MVP ... "Dan Guzman" wrote: ... > sql login instead of their domain account which is not good. ...
      (microsoft.public.sqlserver.server)
    • Re: log the activity with the actual login credential
      ... "Dan Guzman" wrote: ... SQL Server MVP ... Since you connect with SQL authentication, the original user's AD account ... We have an application which is using one single sql login to connect ...
      (microsoft.public.sqlserver.server)
    • Re: log the activity with the actual login credential
      ... Has the "after login" been done in application level? ... Since you connect with SQL authentication, the original user's AD account ... We have an application which is using one single sql login to connect the ... User logons the application using windows domain account. ...
      (microsoft.public.sqlserver.server)
    • Re: Login failed for NT AUTHORITYNETWORK SERVICE on a ASP.Net app
      ... made it a user of mydb and put it in role db_owner. ... newmachine\IIS_WPG has NETWORK SERVICE as member already. ... > ASPNET account - you'll have to adjust the SQL login accordingly. ...
      (microsoft.public.dotnet.framework.aspnet)
    • Quantcast