I've got a SQL Server 2008 R2 Express database. We're working on a WPF app, that's going to use this database, which will be installed on each users' desktop/laptop. We want it so that access to the SQL Express database will be handled by Windows authentication,
so if a domain user is logged in he/she can access the data. The database is named ASI. The plan is to create a new role, assign the db_datareader and db_datawriter roles to this new role, associate a user in SQL for all domain users and associate the new,
custom role with all domain users. We've got a group in our AD named "Domain Users", and that's what I was going to associate with the user in SQL. However, I'm getting an error trying to do this, I don't have to give a lot of lines to illustrate
where the error occurs. Here's the SQL:
USE ASI
GO
CREATE ROLE [DomainUsersAccess]
--give my new role appropriate permission to ALL tables
EXEC sp_addrolemember N'db_d ...
Go to the complete details ...