Re: Windows authentication failed on SQL2000 +NT4

From: Serge Olivier (sdo20@hotmail.com)
Date: 03/11/03 

From: "Serge Olivier" <sdo20@hotmail.com>
Date: Tue, 11 Mar 2003 10:35:34 -0500

Thanks for your reply Dejan,
I did grant access to a Win Group (DomainName\GroupName) with read/write on
the appropriate database but still won't recongnize their logins. I read and
followed the instructions from the SQL Server Book.

Is it something about SQL on the NT4 being member of our Win2k domain?

Thanks
Serge

"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@reproms.si> wrote in
message news:#pJGLq65CHA.1784@TK2MSFTNGP10.phx.gbl...
> Serge,
>
> You have to grant access to SQL Server to Win users and groups. Only local
> Administrators group has granted access to SQL Server after the
> installation. Do please read about security in SQL Server Books OnLine.
>
> --
> Dejan Sarka, SQL Server MVP
> FAQ from Neil & others at: http://www.sqlserverfaq.com
> Please reply only to the newsgroups.
> PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>
> "Serge Olivier" <sdo20@hotmail.com> wrote in message
> news:O0go1b45CHA.2308@TK2MSFTNGP11.phx.gbl...
> > Hi folks,
> > All users (except admins) failed to be authenticated on our SQL2000
> server.
> > It's running on NT4 sp6 and the PDC is Win2000 Server (A.D.). Windows
and
> > SQL authentication are set.
> >
> > I have granted access Read/Write to the DB to the group of users.
> >
> > What could cause this problem? Would it be NT not recognizing the
Win2000
> > groups?
> >
> > Thanks for any anwers.
> >
> > Serge
> >
> >
>
>

Relevant Pages

  • Re: Controlling access with custom groups
    ... Adding a fixed database role to a user-defined role is not permitted. ... Columnist, SQL Server Professional ... db_datareader, through Enterprise Manager. ... then grant access to the role. ...
    (microsoft.public.sqlserver.security)
  • Re: prevent developers writting to our SQL DB ?
    ... Then only grant access to the procs and views and deny access directly to ... Abstract this through the use of a database role. ... Looking for a SQL Server replication book? ... How can we employ this in a VB and SQL environment when users need ...
    (microsoft.public.sqlserver.server)
  • Re: WSS 2 to WSS 3 migration error
    ... Thanks for your response Peter. ... would I grant access to the user? ... SQL server or in this case Windows internal DB. ... It is possible that your account ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Database Access
    ... > Do you create the group in SQL Server on the NT Domain? ... Sort of. ... You create the group in the NT domain, then grant access to the ... This email account is my spam trap so I ...
    (microsoft.public.scripting.jscript)
  • GRANT CONNECT to group? - How?
    ... I've created a web service endpoint on SQL Server 2005. ... But I failed trying to give access to a database role. ... I can only grant access to SQL Server users. ...
    (microsoft.public.sqlserver.connect)