basic windows authentication problem
From: Tony Su (tonysu@su-networking.com)
Date: 12/19/02
- Next message: brlarue: "Job Security"
- Previous message: michael ngong: "User Rights and Privileges"
- In reply to: ian: "basic windows authentication problem"
- Next in thread: ian: "Re: basic windows authentication problem"
- Reply: ian: "Re: basic windows authentication problem"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Tony Su" <tonysu@su-networking.com> Date: Thu, 19 Dec 2002 09:31:23 -0800
Others may have more to say, but IMO the problem is
basically that you're running XP Home on your workstation.
XP Home cannot join a Domain, so every time you connect to
a database, you will be presenting either security
credentials stored locally on your machine or SQL
Username/Password. You cannot present Domain credentials.
So, your solution should be to either login with SQL
credentials (and configure your dB to support Mixed
Authentication) or upgrade your workstation to XP Pro
(highly recommended).
I'm somewhat surprised you have any kind of access to the
database already... speculating that you may have Mixed
Authentication turned on already and/or you might have
Ownership permissions due to creating the dB.
Tony Su
>-----Original Message-----
>Hi all,
>
><Newbie alert>
>
>I've got a simple setup here for getting to grips with
SQL Server 2000, but
>can't connect to the sample database from my PC.
>
>Existing network had a single Win2K server, called
SERVER1, with Active
>Directory domain COMPANY.
>I have created an account FRED.
>My PC, called PC1, runs XP Home, with an account also
called FRED.
>Both accounts use same password, so when I log in on PC1
as FRED I get
>access to all areas available to FRED on SERVER1.
>
>Added new Win2K server SERVER2, which joined the COMPANY
domain. I can log
>in to this server as FRED (or any other valid COMPANY
account) without a
>problem.
>
>I have run
> exec sp_grantlogin 'COMPANY\FRED'
>on SERVER2, and this granted login access ok. Logging in
as FRED directly on
>SERVER2 allows me to run Query Analyser with no problems.
>
>In Query Analyser on PC1, logged in as FRED, connecting
to SERVER2 using
>windows authentication, get the error 'Login failed for
user (null)'.
>
>Seems as if the SQL Server does not recognise my account
as being
>COMPANY\FRED....
>
>If I try to map a drive on PC1 to SERVER2, it initially
tries to use
>PC1\FRED as the account name, which fails until I change
it to use
>COMPANY\FRED . Is this what is happening when I try to
connect to SQL
>Server?
>
>Is this a problem with my SQL Server setup, or is my
basic network
>authentication setup wrong? Is the way I use the same
account name on my XP
>box and on the server the cause of the problem?
>
>Any suggestions?
>
>TIA,
>
>Ian
>
>
>.
>
- Next message: brlarue: "Job Security"
- Previous message: michael ngong: "User Rights and Privileges"
- In reply to: ian: "basic windows authentication problem"
- Next in thread: ian: "Re: basic windows authentication problem"
- Reply: ian: "Re: basic windows authentication problem"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
