Enable User Login

From: aart (aart@astona.nl)
Date: 11/12/02 

From: "aart" <aart@astona.nl>
Date: Tue, 12 Nov 2002 13:23:54 +0100

Hi listsubcribers!

May be i am allowed to bother you with an elementary question?

We have a C++ application that connects to SqlServer2000 via ADO using
the connectionstring: "Provider=SQLOLEDB;Data
Source=our-companyserver\SqlServer01;Initial
Catalog=OurDataBase;Trusted_Connection=yes".
So far so good. The app behaves as expected as long as the developer (who
creates the database) is logged in.
But how to enable other users to log-in? We have consult the manual and came
up with the sp_grantdbaccess
stored procedure: EXEC sp_grandbaccess 'OurDomain\DomainUsers' to enable all
users of the specific
Windows group to login. But when we login to windows with a user-account in
the DomainUsers group,
SqlServer complains that it has not a entry for that user.

The question is: How to grant a windows user group access to SqlServer?

Thanks in advance for any suggestions,

Aart

Relevant Pages

  • Re: Enable User Login
    ... Aart, ... But when we login to windows with a user-account ... > SqlServer complains that it has not a entry for that user. ...
    (microsoft.public.sqlserver.security)
  • USB scanner help/advice request
    ... I apologize for what must be a somewhat elementary question. ... would like to avoid spending hours trying to get this to work only to ... Virtual PC and Windows XP Pro. ...
    (microsoft.public.mac.virtualpc)
  • Re: Microsoft NET Framework 1.1 sp1
    ... Carey Frisch ... Windows XP - Shell/User ... "Charlie" wrote: ... | Like I said, an elementary question! ...
    (microsoft.public.windowsxp.help_and_support)
  • Scanning XP computer over the local network
    ... Sorry if this is an elementary question but: ... I have one machine with NAV installed, and a second running ... Windows XP Home on the local network. ...
    (alt.comp.anti-virus)