RE: Active Directory Group in SQL Server 2005 SP3 Server

State 11 means that the use does not have access their default database or
initial catalog setting is wrong in the connection string.

Thanks.
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/


"Chris" wrote:

Error: 18456, Severity: 14, State: 11

"Mohit K. Gupta" wrote:

Hi Chris

What is the Error state?

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/


"Chris" wrote:

I have a SQL Server 2005 SP3 server that will not allow Active directory
group users to login. I get this in the event log (names and addresses
changed to protect the innocent):
Login failed for user 'DOMAIN\user'. [CLIENT: 1.1.1.1].

However on my other SQL Servers (all have SP2), it works perfectly. I just
create the login as the Domain group, and assign its appropriate roles.

Is there something different in SP3? I am not sure if this worked prior to
the upgrade, as we never used groups with this server until now, so it is
possible this problem is specific to that server.
.

Relevant Pages

  • RE: Cluster Configurations
    ... MCTS: SQL Server 2005 ... "Mohit K. Gupta" wrote: ... Named Instance -> Failover to Node 4 ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL native client
    ... "Mohit K. Gupta" schrieb im Newsbeitrag ... i have a VB6 app which connects via SQL native client 2005 to a SQL Server ... As other computers don't need admin rights i think it's a config. ...
    (microsoft.public.sqlserver.clients)
  • RE: SQL Agent not Showing in SSMS
    ... "Mohit K. Gupta" wrote: ... MCTS: SQL Server 2005 ... Agent node disappears on NodeB but is still visible on NodeA. ...
    (microsoft.public.sqlserver.security)
  • Re: Too many full-text columns or the full-text query is too compl
    ... Looking for a SQL Server replication book? ... Looking for a FAQ on Indexing Services/SQL FTS ... "Mohit K. Gupta" wrote: ...
    (microsoft.public.sqlserver.fulltext)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
Loading