Home > Archive > MS SQL Server security > October 2006 > sp_grantlogin and full domain name









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author sp_grantlogin and full domain name
Pavel Žákavec

2006-10-25, 6:01 am

Hi,

I have a question.
How can I use 'sp_grantlogin' with full domain name?

I tried use sp_grantlogin 'KAROLINA.CZ\pavel' but I get this error message:
Windows NT user or group 'KAROLINA.CZ\pavel' not found. Check the name
again.

If I use sp_grantlogin 'KAROLINA\pavel' then all is right.

Thank you for your help.

Pavel



Dan Guzman

2006-10-28, 7:15 pm

> How can I use 'sp_grantlogin' with full domain name?

The NetBois domain name needs to be specified, not the DNS name.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Pavel Žákavec" <pavel.zakavec@seznam.cz> wrote in message
news:eih15MB%23GHA.4472@TK2MSFTNGP05.phx.gbl...
> Hi,
>
> I have a question.
> How can I use 'sp_grantlogin' with full domain name?
>
> I tried use sp_grantlogin 'KAROLINA.CZ\pavel' but I get this error
> message:
> Windows NT user or group 'KAROLINA.CZ\pavel' not found. Check the name
> again.
>
> If I use sp_grantlogin 'KAROLINA\pavel' then all is right.
>
> Thank you for your help.
>
> Pavel
>
>
>

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com