Perm. Problem - Must belong to Domain Admins to connect to SQL Ser

Discussion in 'Windows Small Business Server' started by Bobby Bounds, Oct 15, 2007.

  1. Bobby Bounds

    Bobby Bounds Guest

    Hi folks.....I have a commercial billing app running on SBS's SQL 2005. When
    connecting from a wk.station if the logged in user is not a member of 'Domain
    Admins' the application tries to load but won't. It shows it is running in
    Task Manager but the U.I. does not come up. Once I add the user to Domain
    Admins the app works fine. Any ideas? TIA

    -Bobby
     
    Bobby Bounds, Oct 15, 2007
    #1
    1. Advertisements

  2. I suggest you call the application vendor and ask them for tech support for
    their software. It could be it requires *local* admin rights (which are
    conferred by default if you have domain admin rights). Find out how to make
    the application run as a limited user account - users shouldn't have any
    admin rights at all.
     
    Lanwench [MVP - Exchange], Oct 15, 2007
    #2
    1. Advertisements

  3. Check with your application vendor. This looks like the application is
    using Impersonation on SQL Server. You don't need to add the user as a
    member of the Domain Admins. A SQL Server user with enough privileges is
    more than enough
     
    bass_player [SBS-MVP], Oct 16, 2007
    #3
  4. Bobby Bounds

    Bobby Bounds Guest

    OK....fyi.....I fingered it out. :) I joined the domain account to the local
    admins and that took care of the problem.
     
    Bobby Bounds, Oct 21, 2007
    #4
  5. Yes; that's what I suspected & why I replied as I did. That's a workaround,
    not a fix. Users should not have local admin or power user rights on their
    workstations. Talk to the app developer about this- it's bad code. You can
    use ProcessExplorer from Sysinternals (downloadable from Microsoft) to
    identify the registry keys and file system areas to which the app expects to
    have access, so you can manually change them...but this is the developer's
    problem.
     
    Lanwench [MVP - Exchange], Oct 22, 2007
    #5
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.