Re: Help! Set up Windows Group to access application

You would execute something like the following:
USE master
GO
CREATE LOGIN [YourDomain\SomeGroup]
FROM WINDOWS
WITH DEFAULT_DATABASE= YourDefaultDatabaseName
GO
USE YourDatabase
GO
CREATE USER [YourDomain\SomeGroup]
FOR LOGIN [YourDomain\SomeGroup]
WITH DEFAULT_SCHEMA= YourDefaultSchemaName

That's just to access the database. Then you need to figure
out permissions in the database.

-Sue

On Mon, 14 May 2007 17:45:01 -0700, Sandy
<Sandy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I am sorry for cross-posting, but I'm used to posting in the programming
section and posted there as a force of habit.

I have an application written in VB6 that is hooked up to Sql Server 2005.
I can't seem to get a regular user to be able to access it. There's a Sql
Server error:

"Login failed for user ''. The user is not associated with a trusted Sql
Server connection." Note that it doesn't name the user; just supplies blank
single quotes together.

I want to use Windows Authentication. I set up a group in Active Directory
called CustomerService.

Can someone show me step by step how I set up the CustomerService group to
access the database MyDatabase?

Any help will be greatly appreciated!!

.

Relevant Pages

  • Re: ASP.NET User.Identity.Name value after a domain username chang
    ... Since .NET is just calling into Windows API calls to resolve the user name, ... I have an ASP.NET application that is on a Win2000 server in a domain ... I have a very confusing issue when the domain login of a user is ... I thought this might have been some caching issue on the client so I ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: CAN WE LOGIN TO A WINDOWS 2003 ACTIVE DIRECTORY DOMAIN OVER TH
    ... Having a user login to a windows 2003 server over the internet is not a good ...
    (microsoft.public.windows.server.active_directory)
  • Re: Win2003 Console Login Screen Black- Cant Log In
    ... it discovered the existing install, ... > I've got a Windows 2003 Standard server. ... This is also our Veritas Netbackup server. ... > black screen with only part of the login prompt showing. ...
    (microsoft.public.windows.server.general)
  • Re: CAN WE LOGIN TO A WINDOWS 2003 ACTIVE DIRECTORY DOMAIN OVER THE IN
    ... If I create a user in active directory in windows 2003 server, ... login to that user using windows xp login dialog box within the network ... and you can resolve DNS from the point of view of an INTERNAL ...
    (microsoft.public.windows.server.active_directory)
  • Re: Locked out of Enterprise Manager
    ... When you went into the Server Config and changed it to Windows Auth you did ... stopped working is that it didn't know what login to connect with. ...
    (microsoft.public.sqlserver.security)