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

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

"Bobby Bounds" <BobbyBounds@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0531E639-1190-4A72-8155-5EC33E2CD726@xxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • Re: Permissions WTF - BUILTIN
    ... We recently migrated from an NT4 domain to a Windows 2003 domain. ... My pc and the SQL server have been moved to the new domain. ... Our nt admins have created a new group for the sql admins/developers on the ... > said i was member of db_owner and not srv role sysadmin...but i am getting ...
    (microsoft.public.sqlserver.security)
  • Re: ForestPrep Issues!
    ... not load exchange 2003 server on a production box as ... >the Domain Admins, Schema Admins, Enterprise Admins ... >a member of the Schema Admin and Enterprise Admins group ... >> I have a domain with a single active directory. ...
    (microsoft.public.exchange.setup)
  • Re: cannot acees two databases as owner
    ... it does not matter you are a member of the ... the sysadmin fixed server role or if there is no any other Login which is ... group if it's a domain) and you can login to your SQL Server with, ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Login
    ... The sa login account is a member of that role as well. ... Dejan Sarka, SQL Server MVP ... > But how do we add the User X to the sysadmin / ...
    (microsoft.public.sqlserver.security)
  • Re: New AD installation issue
    ... Then a second server was added to the domain. ... (I am a member of the Administrators ... Membership of the Administrators group in the domain gives you admin access ... Membership of the Domain Admins group grants you admin privileges to the ...
    (microsoft.public.windows.server.active_directory)