Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ErikVB
Starting Member
3 Posts |
 Posted - 2003-02-05 : 05:06:02
|
| Hi,I encountered some strange behaviour from Enterprise Manager when connecting to a remote sql2000 server. The remote server has mixed mode authentication enabled, i am a domain adminstrator on de domain in which the win2000 adv. server exists, and i have also a sqlserver login with the same name/pw as my domain login/pw. When connecting to the remote sql server from my home PC with EM, using sql server authentication, somehow my home login is also sent to the remote sql server. The connection seems to go smoothly, but when reviewing the security log on the remote server, there are pairs of failure audits: event id 681, with error code 3221225578 and event id 529 with reason unkown user name or bad password. My home username/pw is generating the error.Somehow EM tries to log on with my home account as well. Does anyone know what causes this behaviour and how to avoid it?Thanks in advance,Erik |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-02-05 : 12:40:51
|
| I have never seen this before. Are you sure that it is you who is generating the error and not someone else? Do you have some process kicking off on your home machine? Does this weird behavior exist when you use Query Analyzer instead of EM? |
 |
|
|
ErikVB
Starting Member
3 Posts |
Posted - 2003-02-06 : 03:49:13
|
| Nope,connecting through any other way doesn't generate any error on the remote machine. I've tested with query analyzer and connecting via odbc, but that works just fine. Furthermore the problem is consistent with at least two machines at home: a windows 2000 advanced server box and a windows xp box. My home domain account + information about my pc (name etc) is being sent to the remote server. The problem is not huge, but is causing clogging of security error log of remote server.Maybe this is not an EM problem, but a windows problem?This is a short overview of all configurations concerned:remote machine: windows 2000 adv. server sp3, part of a nt4 domainsql server 2000 sp3 Home machineswindows 2000 adv server sp3, domain controllersql server 2000 sp3windows xp pro, part of windows2000 domainsql server 2000 client tools |
|
|
|
ErikVB
Starting Member
3 Posts |
Posted - 2003-02-06 : 04:47:42
|
| new info:In the domain of the remote sql server2000 a sql server 7 is also running on a different (almost identically configured) machine. When i connect to that sql7 instance from home with EM, in exactly the same way as i do to the sql2000 instance, no error is reported on the machine sql7 is running on. Could it be a hidden configuration feature of sql 2000? |
|
|
|
|
|
|
|
|
Strange authentication behaviour from EM