October 6, 2005 at 12:56 pm
One of my developers has an issue of her Windows User account on the database server becoming locked whenever she opens EM. It doesn't matter whether she actually tries connecting to the database server and she has not logged on to the database server interactively.
We watched the event viewer on the server as she created a VPN connection and nothing happened but as soon as she opened EM the server started registering login failures.
She uses SQL authentication, not Windows; her Windows username is the same on both machines but her passwords are different; the machines are not in the same domain. The server runs Win2K and the RDBMS is SQL Server 2000. The user does need to log on to the server interactively from time to time.
Does Enterprise Manager poll registered servers in an attempt to speed up the connection process when a user does try to connect? Does anyone have an idea why Enterprise Manager passes a Windows username and password to a registered server?
It is a curiousity!
October 6, 2005 at 2:05 pm
Not totally sure but how are the sql servers registered on her enterprise manager (edit registration)
1)Display SQL Server state is on?
Perhaps EM tries to log in to verify the current state
2)Use SQL Server Authentication is on?
Does
Always prompt for login name and password makes a difference?
October 6, 2005 at 2:41 pm
1) Display SQL Server state did not seem to make a difference
2) I want to withold final judgement, but initial results suggest that setting the "Always prompt for login name and password" to true causes the login failures to cease.
Why would that be? The SQL login and password is nothing close to the Windows login... SQL Authentication was already in use... what is the difference between requiring a manual login every time and storing it in memory?
BTW... Thanks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply