Re: Not associated with a trusted SQL server connection
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 02/24/05
- Next message: Peter: "Re: What are the necessary rights to install SQL Server?"
- Previous message: Sue Hoegemeier: "Re: Not associated with a trusted SQL server connection"
- In reply to: Deepali Garg: "Not associated with a trusted SQL server connection"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 24 Feb 2005 13:55:27 -0700
Sorry...forgot one other thing. You can change it in the
registry if you can't find it in DbaMgr 2K.
HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode
Change the value for LoginMode to 2
-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
>
- Next message: Peter: "Re: What are the necessary rights to install SQL Server?"
- Previous message: Sue Hoegemeier: "Re: Not associated with a trusted SQL server connection"
- In reply to: Deepali Garg: "Not associated with a trusted SQL server connection"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
