Trusted connection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

maciek@kolobrzeg.com.pl - 22 Dec 2005 10:51 GMT

Hi,

Can I log on to SQL Server 2000 being loged on to a computer (local
user account) which is added to a domain? Here is the issue:

I am logged on to my Win XP using local account which is a member of
local Administrators group (I am NOT logged on to a domain) but the
same login exists in Active Directory and is a member of Administrators
and Domain Administrators group. I somehow managed to login in QA to
SQL Server using trusted connection but it shows as I am logged as
domain administrator, but i do not remember how I did it. I need
another user being loged on to local WinXP account to use trusted
connection to SQL Server. I do not know if I am making myself clear but
if you have any ideas, i'd appreciate.

TIA
Maciek Szymanski

Reply to this Message

Uri Dimant - 22 Dec 2005 13:06 GMT

Hi
If you ( a computer name ) is a member of domain admin so you probably is
loged on as DOMAIN\YourComputerName
and of cause it is a member of the Local Admistrators group

When you log in "localy" as you siad you should be a member of Local
Admistrators group or any group that has an access to SQL Server

> Hi,
>
[quoted text clipped - 13 lines]
> TIA
> Maciek Szymanski

Reply to this Message

maciek@kolobrzeg.com.pl - 22 Dec 2005 14:15 GMT

Hi Uri,
I don't quite follow. When the SQL Server is on local box and I log in
localy with Admin rights I log in, using windows authentication, to sql
server as LocalBox\MyLogin. But the thing is (I forgot to mention this,
I apologize) the SQL Server I'm talking about is on different box (also
member of the domain). And somehow I've managed to log in to that SQL
Server as Domain\DomainAdminLogin. So: I'm logged on localy with local
admin rights to Windows XP, the same username is a member of Domain
Admin group in the Active Directory (I don't know if it's relevant) and
when I connect to Sql Server (which is on completely another box) using
Windows Authentication i get logged in as Domain\DomainAdminAccount
(which is NOT my local login account name). I think I must have done
something to "translate" my login into domain login account (probably I
read an article on it and did something but I really don't remember
what it was :-( ).

Reply to this Message

David J. Cartwright - 22 Dec 2005 14:06 GMT

is username/password the same for the local and domain account.
did you map or open any shares/RPC to the sql server by using the domain
account ?

> Hi,
>
[quoted text clipped - 13 lines]
> TIA
> Maciek Szymanski

Reply to this Message

maciek@kolobrzeg.com.pl - 22 Dec 2005 14:21 GMT

David,
Yes, but so is my colleague (we have the very same security settings)
but he cannot access SQL Server from his box. He gets "Login failed for
user '(null)'. Reason: Not associated with a trusted SQL Server
connection" error.

Reply to this Message

maciek@kolobrzeg.com.pl - 22 Dec 2005 14:28 GMT

... and we both had open shares to SQL box using domain admin account
but he still could't get in.

Reply to this Message

David J. Cartwright - 22 Dec 2005 14:54 GMT

his domian account has a login ?

> ... and we both had open shares to SQL box using domain admin account
> but he still could't get in.

Reply to this Message