May 7, 2004 at 11:20 am
I have two entries for sa in the sysxlogins table. The problem is that one of them has a NULL password and I haven't been able to figure out how to fix it (or if I even need to).
Here are some of the values for the two records:
srvid xstatus password dbid language isrpcinmap
NULL 18 <not null> 1 us_english 0
0 32 NULL 0 NULL 1
And I haven't found a lot of documentation for that table and the various values. Any ideas?
Thanks in advance.
I Only Work Here......
May 7, 2004 at 11:57 am
The first one with the xstatus of 18 and no srvid is the sa for this server. The other with a srvid looks like a remote server or linked server where the login has been mapped to sa and that connection is using no password.
Do a
select * from sysservers where srvid = 0
odds are that it is the remote server copy of the local server (I see this on my boxes) which in this case is a non issue as this is a default thing.
May 7, 2004 at 12:05 pm
Thanks for your response.
I ran the script and the server does show up. However, one thing I failed to mention is that the server with multiple sa records is the publisher with merge replication. The remote server is a copy of the local server, but I can't delete it because it is a publisher.
The bottom line is that I don't think that this is a security issue. Agree?
I Only Work Here......
May 7, 2004 at 12:10 pm
Yes that should not be a security risk at all.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply