Permissions BUILTIN/Administrator

We recently migrated from an NT4 domain to a Windows 2003 domain.
I was using the login olddomain\paulc and I now use newdomain\paulc
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
new domain called "Sql Admins". I was an NT Domain Admin on the old domain.
I have added this new group to sql server however I am being validated as
BUILTIN\Administrators.
exec master..xp_logininfo 'DOMAIN\username'
Any idea why this is? I think this is an NT issue. I believe there is an NT
trust between the old and
new domains.
Regards
Paul CahillPaul,
Not sure if I understand your situation right, but basically the
BUILTIN\Admins is the same as you local administrators group on the
server. If your new account is a member of this local administrators
group, either direct or through group membership SQL Server will
validate you as BUILTIN\Administrators
Markus|||Cheers Markus.
I'll have a look or words with our IS admins.
<m.bohse@.quest-consultants.com> wrote in message
news:1133356379.166090.122130@.g47g2000cwa.googlegroups.com...
> Paul,
> Not sure if I understand your situation right, but basically the
> BUILTIN\Admins is the same as you local administrators group on the
> server. If your new account is a member of this local administrators
> group, either direct or through group membership SQL Server will
> validate you as BUILTIN\Administrators
> Markus
>|||The IS guys had made all us Sql dba/developers domain admins and domain
admins has been added to the local administator group.
All is cool.
Thanks again Markus.
Paul
<m.bohse@.quest-consultants.com> wrote in message
news:1133356379.166090.122130@.g47g2000cwa.googlegroups.com...
> Paul,
> Not sure if I understand your situation right, but basically the
> BUILTIN\Admins is the same as you local administrators group on the
> server. If your new account is a member of this local administrators
> group, either direct or through group membership SQL Server will
> validate you as BUILTIN\Administrators
> Markus
>