Re: 2 sa entries in sysxlogins

From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 08/28/03 

Date: Thu, 28 Aug 2003 21:36:21 +0100

Have a look at the srvid column, when it's NULL that's your local instance
sa login, any other value indicated a linked server login mapping 

-- 
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Gert" <deswardtg@excite.com> wrote in message
news:0ac301c36d5d$bb6dfec0$a501280a@phx.gbl...
On 2 of my servers, I have 2 entries for the sa user in
the sysxlogins table. Whould anybody know why?
Regards
Gert

Relevant Pages

  • Re: Cannot open remote connection to Dql Server
    ... The user is not associated with a trusted SQL Server ... > Jasper Smith ... >>> The Allow Remote Conections is not the correct setting (it controls the ...
    (microsoft.public.sqlserver.setup)
  • Re: Run time jobs
    ... The SQL server agent is started by Local System account. ... The login account has admin privileges on source and destination server also. ... > Jasper Smith ...
    (microsoft.public.sqlserver.security)
  • Re: 2 sa entries in sysxlogins
    ... any other value indicated a linked server login ... >Jasper Smith (SQL Server MVP) ...
    (microsoft.public.sqlserver.security)
  • Re: Connect to DB using another TCP port from SQL management Studio
    ... It's in the Server name box i.e. if your server was called FOO and on port ... Jasper Smith ... alternative you can set up a client alias using SQL Server Configuration ...
    (microsoft.public.sqlserver.connect)
  • Does server linking work without Security Account Delegation?
    ... Is there any way to make server linking working without Security Account ... Delegation enabled if the target server is set to "Windows only" ... If SERVER2 were set to "SQL Server and Windows" authentication we could ... easily add a linked server login: ...
    (microsoft.public.sqlserver.security)