Re: Trusted connection

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 :-( ).

.

Relevant Pages

  • Re: Slow booting xp home.
    ... Changing the boot order to boot first from your hard disk might save you a half second, but you won't be able to boot from a CD until you change it back - and the time spent to do that will erase any previous time saved. ... 2- Consider what software you really want to start with Windows and also how you've configured your applications at startup ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Slow booting xp home.
    ... Thirty seconds to boot Windows? ... I read somewhere that Microsoft suggest 30s boot up on xp home, I have seen videos on youtube of 8s boot up on xp, I'd be delighted with 30s and happy just to get below a minute. ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Connection string/Sql Server 2005/Windows authentication/ but not on domain
    ... SQL Server defaults to prohibit "mixed mode" authentication. ... make sure that the Login account is setup to accept the Windows account and has rights to the correct database. ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.sqlserver.connect)
  • Re: Remote connection failed
    ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
    (microsoft.public.sqlserver.connect)
  • Re: Security Update for SQL Server 2005 Service Pack 2 (KB948109)
    ... If you're running Windows Live Mail, sign out then close the application. ... Understand that you can open a free support incident about your issues: ... When you call, clearly state that your problem is related to a Security Update and cite the update's KB number. ... SQL Server Database Services 2005 ENU SP2 ...
    (microsoft.public.windowsupdate)