Re: Cannot access my SQL Database

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 01/28/05 

Date: Thu, 27 Jan 2005 18:42:28 -0700

If when you try to login with sa and you receive the error
"not associated with a trusted SQL Server connection then it
looks like the server is set to windows authentication only.
In that case, you can change the authentication mode in the
registry. Change the registry value for LoginMode in:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer
to 2
If you can get in with sa, then you can clean things up.

-Sue

On Thu, 27 Jan 2005 22:26:03 GMT, "Eric Dahlstrom via
SQLMonster.com" <forum@SQLMonster.com> wrote:

>I have a SQL DB which is configured to use mixed mode. Recently, I attempted to create a group login for the db based on our company's domainn accounts. I also included the local machine login.
>After creating the group in Windows, then within the database, I turned off access to the database for the original local domain group.
>After logging out of the database, I am now unable to access it either through the Enterprise Manager or Query Analyzer, or via an application that was configured to use that db over the network.
>I have tried the sa login, the network admin logins I created to no avail. Is there a way to hack in to SQL Server accouts and reset them to allow all groups?
>Typical errors are:
>Login failed for user .....reason:Not associated with a trusted SQL Server connection.
>
>and
>
>(connection failed, check sql server registration properties) - From SQLEM.
>
>Thanks for any help on this.

Relevant Pages

  • Re: Newbie: SQL Server connection, help needed
    ... Mike Epprecht, Microsoft SQL Server MVP ... > trying to setup an ODBC connection from another XP and win2000 machines. ... Not associated with a trusted SQL Server connection. ...
    (microsoft.public.sqlserver.connect)
  • Re: Problem with Windows 2003 Server
    ... Not associated with a trusted SQL Server connection. ... FAQ: ...
    (microsoft.public.inetserver.iis)
  • Re: Where did the connections come from?
    ... login isn't logged in SQL Server 2000, ... Login failed for user ''. ... trusted SQL server connection. ... I found a lot login failures. ...
    (microsoft.public.sqlserver.security)
  • Re: Login failed for user (null).
    ... Not associated with a trusted SQL Server connection. ... The web server is currently on my local machine and after tweaking the ...
    (microsoft.public.inetserver.asp.db)
  • Re: Users lost access to SQL Server
    ... The error means you are attempting to login to SQL Server ... >associated with a trusted SQL Server connection.. ...
    (microsoft.public.sqlserver.security)