Groups | Blog | Home
all groups > sql server connect > march 2006 >

sql server connect : SQL SERVER 2000 - SQL Enterprise Manager from Workstation problem


Charles L
3/27/2006 8:20:01 AM
Hello,
I've been running a copy of SQL 2000 under Windows 2000 server. I have
two admin's both running enterprise manager from their windows XP Prof
workstations.
One admin has no problem.

The other admin's workstation, whenever sql enterprise manager is run, tries
to log in to the windows 2000 server using windows authentication even though
sql enterprise manager is configured to use sql authentication (and is
successfully logging in to the sql server). This admin doesn't have a
windows account on the server and thus is generating a log of security
audits. Eventually, the security audit log fills up and the server shuts down.

Why does enterprise manager try to login using windows authentication when
it is already logged in using sql authentication?

Any fixes?

Thanks,
Charles
--
Sue Hoegemeier
3/27/2006 8:07:41 PM
If it's login failures that you are seeing, it could be
related to the polling that Enterprise Manager does - it
polls the SQL related services on the servers that you have
registered. You can turn this off in Enterprise Manager by
going up to the menu to Tools and selecting Options. On the
general tab, you can remove the check for Server State
Polling.

-Sue

On Mon, 27 Mar 2006 08:20:01 -0800, Charles L
[quoted text, click to view]
AddThis Social Bookmark Button