Cannot Connect to SQL Server 2000 Using Domain Account

Hi folks:
I'm new here so please bear with me. I have a problem that is totally
driving me crazy, and it seems like it should be simple but for the life of
me I can't figure it out.
My question is simple: How do I connect to a Microsoft SQL 2000 server using
a domain account? Let me run through what I've done and what I'm trying to do.
I go to Enterprise Manager, expand my server, and click on
SECURITY...LOGINS. I create a new Login. I want to use Windows
Authentication, so I select that. Selecting that prompts me to select my
domain name, which I do. Let's suppose that the domain is named MCD. OK,
now I type in the name of the account, WHICH MATCHES THE DOMAIN ACCOUNT
IDENTICALLY! So, for example, I type in TestAccount, which combined with the
domain name is now MCD\TestAccount. I grant the account access to the
database and make it a full system administrator. I click OK, and the
account looks great.
HOWEVER, when I try to login using Query Analyzer or OSQL, I get "Login
failed for user MCD\TestAccount." Why?! I must just be missing something, but
I have no idea what it could be. I can authenticate to other resources using
that account just fine. For example, I created a network share on another
server and granted just that test account permissions to it. I can connect
to it using that domain account with no problem, so I know the domain account
is OK.
Any ideas?Are you logged into the client machine using that TestAccount, SqlServer
will pass on the credential of the logged in user.
if you are logged in as MCD\NormK and trying to connect to the sql server
using MCD\TestAccount that is not possible, (at least not from query
analyzer), You can connect to Network Share using different account.
(different username )
HTH
--
Rakesh Ajwani
MCSD, MCSD.NET
"NormK" wrote:
> Hi folks:
> I'm new here so please bear with me. I have a problem that is totally
> driving me crazy, and it seems like it should be simple but for the life of
> me I can't figure it out.
> My question is simple: How do I connect to a Microsoft SQL 2000 server using
> a domain account? Let me run through what I've done and what I'm trying to do.
> I go to Enterprise Manager, expand my server, and click on
> SECURITY...LOGINS. I create a new Login. I want to use Windows
> Authentication, so I select that. Selecting that prompts me to select my
> domain name, which I do. Let's suppose that the domain is named MCD. OK,
> now I type in the name of the account, WHICH MATCHES THE DOMAIN ACCOUNT
> IDENTICALLY! So, for example, I type in TestAccount, which combined with the
> domain name is now MCD\TestAccount. I grant the account access to the
> database and make it a full system administrator. I click OK, and the
> account looks great.
> HOWEVER, when I try to login using Query Analyzer or OSQL, I get "Login
> failed for user MCD\TestAccount." Why?! I must just be missing something, but
> I have no idea what it could be. I can authenticate to other resources using
> that account just fine. For example, I created a network share on another
> server and granted just that test account permissions to it. I can connect
> to it using that domain account with no problem, so I know the domain account
> is OK.
> Any ideas?