Wednesday, March 7, 2012

Registration from Enterprise Manager

Here is my problem:
I have a sqlserver SQLA which I have registered in EM with a sqlserver
authentication with a uid and password and that connection works fine. The
problem is that when I look at the security log of SQLA, i see continuous
failure audits but with a uid that I am logging in to my local machine with.
My question is that when I am choosing to use sqlserver authentication and
not windows authentication to connect to SQLA, how come it is in turn still
sending windows authentication requests at the same time.
Few thing that have led me to this is:
1.When I delete the sqlserver registration from EM, those failure audits
stop, so that nakes me sure that these are coming from EM only.
2. When I map a drive to SQLA with windows credentials, these failure audits
stop, which indicates that it is succeeding in windows authentication ,
thats why the audits stop.
Please let me know your thoughts?
What you are seeing is probably related to the polling that Enterprise
Manager does - it polls the SQL and 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 Fri, 10 Sep 2004 15:44:06 GMT, "Renu Doda" <r_doda@.hotmail.com>
wrote:

>Here is my problem:
>I have a sqlserver SQLA which I have registered in EM with a sqlserver
>authentication with a uid and password and that connection works fine. The
>problem is that when I look at the security log of SQLA, i see continuous
>failure audits but with a uid that I am logging in to my local machine with.
>My question is that when I am choosing to use sqlserver authentication and
>not windows authentication to connect to SQLA, how come it is in turn still
>sending windows authentication requests at the same time.
>Few thing that have led me to this is:
>1.When I delete the sqlserver registration from EM, those failure audits
>stop, so that nakes me sure that these are coming from EM only.
>2. When I map a drive to SQLA with windows credentials, these failure audits
>stop, which indicates that it is succeeding in windows authentication ,
>thats why the audits stop.
>Please let me know your thoughts?
>

No comments:

Post a Comment