Re: SQL SERVER 2000 - SQL Enterprise Manager from Workstation problem

Tech-Archive recommends: Speed Up your PC by fixing your registry

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
<CharlesL@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

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

.

Relevant Pages

  • Re: Sql Server 2005 Dev. Ed. on Windows Server 2003
    ... Check out this KB which is about transferring Logins: http://support.microsoft.com/kb/246133 ... Also, since this is running on a newly installed Windows Server 2003, is ... them from your older SQL Server instance to the newer one. ...
    (microsoft.public.sqlserver.setup)
  • Re: New Windows Infrastructure
    ... vendor's application runs on windows with an SQL database and I will also need a web server for a separate module which will allow our customers to access account data online. ... I would think that if the app runs on windows, I do not need the citrix server. ... It makes sense to have separate DCs though, because let's say you want to upgrade your Active Directory in two weeks time, with separate DCs it's easy, but if you've got a bunch of apps installed it could be a nightmare. ...
    (microsoft.public.win2000.setup_deployment)
  • How can I avoid using SQL Authentication with the Office Web Parts?
    ... We have a machine running Windows 2003 Server, IIS 6, and Windows SharePoint ... We are using Office Web Parts on several Web ... Part pages to display data retrieved from a SQL Server (SQL 2000 SP3 running ...
    (microsoft.public.office.developer.web.components)
  • How can I avoid using SQL Authentication with the Office Web Parts?
    ... We have a machine running Windows 2003 Server, IIS 6, and Windows SharePoint ... We are using Office Web Parts on several Web ... Part pages to display data retrieved from a SQL Server (SQL 2000 SP3 running ...
    (microsoft.public.inetserver.iis)
  • How can I avoid using SQL Authentication with the Office Web Parts?
    ... We have a machine running Windows 2003 Server, IIS 6, and Windows SharePoint ... We are using Office Web Parts on several Web ... Part pages to display data retrieved from a SQL Server (SQL 2000 SP3 running ...
    (microsoft.public.sharepoint.windowsservices)