Re: Not associated with a trusted SQL server connection

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 02/24/05 

Date: Thu, 24 Feb 2005 13:50:47 -0700

It sounds like you have it set for Windows Authentication
only. If you want to use a SQL login, you need to change the
authentication for the server to SQL Server and Windows. I
don't know where that is in DbaMgr 2K...somewhere I'm sure.
But change the authentication mode, restart the service and
then you can log in using a SQL login.

-Sue

On Thu, 24 Feb 2005 06:32:16 GMT, "Deepali Garg"
<dgarg@bigpond.net.au> wrote:

>I have just installed MSDE on my PC running WinXP Pro. I set it up to use
>mixed mode for security mode. However, when I try to log in to the database
>using a user account I created I get the following error:
>
>Login Failed for user 'username'. Reason: Not associated with a trusted SQL
>server connection.
>
>I am using DbaMgr 2k to view the database settings. I have provided all
>admin level access to this user. However, I just cannot login using a
>username. I have tried using the sa account to login and I get the same
>error. I can only login using a Trusted NT Connection option. Any ideas what
>I should try? When I searched it on the web, the only suggestion I can see
>is to make sure the security mode is set to mixed mode, which seems to be
>correct in this case.
>
>Any help will be appreciated.
>
>Deepali
>

Relevant Pages

  • Re: I cant login to Sql no matter what i try! im ignorant and i need help :)
    ... It sounds like your server is configured for Windows authentication ... >requested in login 'T254DN_Staging'. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Return credentials with anonymous authentication?
    ... When you navigate to a site that is uses windows authentication I am ... I need to implement login page. ... >> I need this because if login is successfull I need to redirect user to ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Windows Authentication (asp.net 1.1 C#)
    ... i wouldn't recommend using your internal AD for customer accounts. ... There is no easy way to get a forms based login for IIS integrated auth - this would require to craft the authentication headers on the client - maybe ... If I use windows authentication, I can validate with my domain and I wouldn't have a problem with that, unless that would cause a problem with my internal security. ... Can you point me at another method of secure login, like forms but with encryptation, that can allow me to not have to validate with my domain. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Logout from windows authentication??
    ... I came across this in a forum, so I guess it's in the windows authentication ... The user credentials are being cached by the client browser, ... server (either via a login dialog or automatic submission under IE ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Return credentials with anonymous authentication?
    ... I was now authenticating in an windows authentication site (with the gray ... This way if i will ne next navigation to real windows authentication site I ... place of its current credentials. ... > Have a login page in Application 1 with Anoynoumous authentication. ...
    (microsoft.public.dotnet.framework.aspnet.security)