Cannot access my SQL Database

From: Eric Dahlstrom via SQLMonster.com (forum_at_SQLMonster.com)
Date: 01/27/05

  • Next message: Ryan Ternier: "SQL Server And windows authentication" 
    Date: Thu, 27 Jan 2005 22:26:03 GMT

    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. 

    -- 
Message posted via http://www.sqlmonster.com
  • Next message: Ryan Ternier: "SQL Server And windows authentication"

    Relevant Pages

    • Re: System Administrator Implied Permissions
      ... > sa login, it assigns it the System Administrator fixed ... > Now, given this, why does SQL Server ... in each database is always a member of the public and db_owner roles. ... Other sysadmin role members have the exact same ...
      (microsoft.public.sqlserver.security)
    • Re: No db access after publishing web site
      ... GRANT UPDATE TO ... If I detach and attach this database on a different PC (according that PC ... Cannot open database "pago" requested by the login. ... Are you detaching/attaching the SQL Server Express database correctly ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: SQLDriverConnect error
      ... > The error says that for the user that is logging into SQL Server, ... > For login 001, you need to give the user another default database. ...
      (microsoft.public.sqlserver.connect)
    • Re: Logging in irrespective of database access
      ... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
      (microsoft.public.sqlserver.server)
    • Re: Logging in irrespective of database access
      ... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
      (microsoft.public.sqlserver.server)