How to set user group for sql 2005 express application

I have built an application using vs 2005 and sql 2005 express.
I have used windows authenication in sql server 2005
I have added the USER group to the sql server 2005 logins (or at least I
think I have:: BUILTIN\user), and given read/write permissions to the
database.

The application will run if and only if the logged in user is a member of
the windows admin group.

I need to be able to limit the access to only selected windows groups and to
date have not been able to find any combination of settings that will work.

"a cry from the wilderness -- for some help!!"

Ed Warren.


.

Relevant Pages

  • Re: Using Windows XP Pro as a server
    ... No, SQL Server can't. ... Per user Group Policy Restrictions for XP Home and XP Pro ... Didn't notice that Windows XP has different newsgroup. ... SQL Server can be installed on XP. ...
    (microsoft.public.windows.mediacenter)
  • Re: Slow booting xp home.
    ... Changing the boot order to boot first from your hard disk might save you a half second, but you won't be able to boot from a CD until you change it back - and the time spent to do that will erase any previous time saved. ... 2- Consider what software you really want to start with Windows and also how you've configured your applications at startup ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Slow booting xp home.
    ... Thirty seconds to boot Windows? ... I read somewhere that Microsoft suggest 30s boot up on xp home, I have seen videos on youtube of 8s boot up on xp, I'd be delighted with 30s and happy just to get below a minute. ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Remote connection failed
    ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
    (microsoft.public.sqlserver.connect)
  • Re: Security Update for SQL Server 2005 Service Pack 2 (KB948109)
    ... If you're running Windows Live Mail, sign out then close the application. ... Understand that you can open a free support incident about your issues: ... When you call, clearly state that your problem is related to a Security Update and cite the update's KB number. ... SQL Server Database Services 2005 ENU SP2 ...
    (microsoft.public.windowsupdate)