Registration of SQL Servers missing in Enterprise manager

Hi All,
Recently a strange behaviour was seen with Enterprise manager. When we
change the Windows login password all the registrations of SQL Servers are
missing from SQL Server Enterprise Manager. Did anyone faced this situatio
n
before? Its really painful to register 20 servers each time when login
password is changed. Some of the registered servers are windows
authentication and rest of them are SQL Server authentication.
Thanks a lot in advance!
Vinod MeesalaHi,
Never aware of this issues. What is the SQL Server service pack you are usin
g?
If you are using old service packs, install SP4 for SQL 2000 (if you are
using SQL Server 2000) and see if you still have issues.
Thanks
Hari
SQL Server MVP
"VM" wrote:

> Hi All,
> Recently a strange behaviour was seen with Enterprise manager. When we
> change the Windows login password all the registrations of SQL Servers are
> missing from SQL Server Enterprise Manager. Did anyone faced this situat
ion
> before? Its really painful to register 20 servers each time when login
> password is changed. Some of the registered servers are windows
> authentication and rest of them are SQL Server authentication.
> Thanks a lot in advance!
> Vinod Meesala|||Sounds like this may be the issue you are running into:
FIX: Registered remote servers disappear from SQL Enterprise
Manager in Windows XP when user password is changed
http://support.microsoft.com/?id=323280
-Sue
On Thu, 17 Aug 2006 13:39:02 -0700, VM
<VM@.discussions.microsoft.com> wrote:

>Hi All,
>Recently a strange behaviour was seen with Enterprise manager. When we
>change the Windows login password all the registrations of SQL Servers are
>missing from SQL Server Enterprise Manager. Did anyone faced this situati
on
>before? Its really painful to register 20 servers each time when login
>password is changed. Some of the registered servers are windows
>authentication and rest of them are SQL Server authentication.
>Thanks a lot in advance!
>Vinod Meesala|||Sue,
Thats an awsome piece of information. I wasn't aware of this.
Thanks
Hari
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:04s9e214f3pk9386bmg12lq7jq8q4kbqhj@.
4ax.com...
> Sounds like this may be the issue you are running into:
> FIX: Registered remote servers disappear from SQL Enterprise
> Manager in Windows XP when user password is changed
> http://support.microsoft.com/?id=323280
> -Sue
> On Thu, 17 Aug 2006 13:39:02 -0700, VM
> <VM@.discussions.microsoft.com> wrote:
>
>|||Hey Hari,
People haven't hit the issue for quite awhile so you
probably just forgot it by now. I think it was two or three
years ago when people posted hitting the issue. I guess I'm
just wasting limited brain space with old info - your brain
is just more current than mine : )
-Sue
On Thu, 17 Aug 2006 19:00:43 -0500, "Hari Prasad"
<hari_prasad_k@.hotmail.com> wrote:

>Sue,
>Thats an awsome piece of information. I wasn't aware of this.
>Thanks
>Hari
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:04s9e214f3pk9386bmg12lq7jq8q4kbqhj@.
4ax.com...
>|||Excellent Finding!! Thanks much Sue! I will try this Fix.
Vinod Meesala
"Sue Hoegemeier" wrote:

> Sounds like this may be the issue you are running into:
> FIX: Registered remote servers disappear from SQL Enterprise
> Manager in Windows XP when user password is changed
> http://support.microsoft.com/?id=323280
> -Sue
> On Thu, 17 Aug 2006 13:39:02 -0700, VM
> <VM@.discussions.microsoft.com> wrote:
>
>

Registration of SQL Servers missing in Enterprise manager

Hi All,
Recently a strange behaviour was seen with Enterprise manager. When we
change the Windows login password all the registrations of SQL Servers are
missing from SQL Server Enterprise Manager. Did anyone faced this situation
before? Its really painful to register 20 servers each time when login
password is changed. Some of the registered servers are windows
authentication and rest of them are SQL Server authentication.
Thanks a lot in advance!
Vinod MeesalaHi,
Never aware of this issues. What is the SQL Server service pack you are using?
If you are using old service packs, install SP4 for SQL 2000 (if you are
using SQL Server 2000) and see if you still have issues.
Thanks
Hari
SQL Server MVP
"VM" wrote:
> Hi All,
> Recently a strange behaviour was seen with Enterprise manager. When we
> change the Windows login password all the registrations of SQL Servers are
> missing from SQL Server Enterprise Manager. Did anyone faced this situation
> before? Its really painful to register 20 servers each time when login
> password is changed. Some of the registered servers are windows
> authentication and rest of them are SQL Server authentication.
> Thanks a lot in advance!
> Vinod Meesala|||Sounds like this may be the issue you are running into:
FIX: Registered remote servers disappear from SQL Enterprise
Manager in Windows XP when user password is changed
http://support.microsoft.com/?id=323280
-Sue
On Thu, 17 Aug 2006 13:39:02 -0700, VM
<VM@.discussions.microsoft.com> wrote:
>Hi All,
>Recently a strange behaviour was seen with Enterprise manager. When we
>change the Windows login password all the registrations of SQL Servers are
>missing from SQL Server Enterprise Manager. Did anyone faced this situation
>before? Its really painful to register 20 servers each time when login
>password is changed. Some of the registered servers are windows
>authentication and rest of them are SQL Server authentication.
>Thanks a lot in advance!
>Vinod Meesala|||Sue,
Thats an awsome piece of information. I wasn't aware of this.
Thanks
Hari
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:04s9e214f3pk9386bmg12lq7jq8q4kbqhj@.4ax.com...
> Sounds like this may be the issue you are running into:
> FIX: Registered remote servers disappear from SQL Enterprise
> Manager in Windows XP when user password is changed
> http://support.microsoft.com/?id=323280
> -Sue
> On Thu, 17 Aug 2006 13:39:02 -0700, VM
> <VM@.discussions.microsoft.com> wrote:
>>Hi All,
>>Recently a strange behaviour was seen with Enterprise manager. When we
>>change the Windows login password all the registrations of SQL Servers are
>>missing from SQL Server Enterprise Manager. Did anyone faced this
>>situation
>>before? Its really painful to register 20 servers each time when login
>>password is changed. Some of the registered servers are windows
>>authentication and rest of them are SQL Server authentication.
>>Thanks a lot in advance!
>>Vinod Meesala
>|||Hey Hari,
People haven't hit the issue for quite awhile so you
probably just forgot it by now. I think it was two or three
years ago when people posted hitting the issue. I guess I'm
just wasting limited brain space with old info - your brain
is just more current than mine : )
-Sue
On Thu, 17 Aug 2006 19:00:43 -0500, "Hari Prasad"
<hari_prasad_k@.hotmail.com> wrote:
>Sue,
>Thats an awsome piece of information. I wasn't aware of this.
>Thanks
>Hari
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:04s9e214f3pk9386bmg12lq7jq8q4kbqhj@.4ax.com...
>> Sounds like this may be the issue you are running into:
>> FIX: Registered remote servers disappear from SQL Enterprise
>> Manager in Windows XP when user password is changed
>> http://support.microsoft.com/?id=323280
>> -Sue
>> On Thu, 17 Aug 2006 13:39:02 -0700, VM
>> <VM@.discussions.microsoft.com> wrote:
>>Hi All,
>>Recently a strange behaviour was seen with Enterprise manager. When we
>>change the Windows login password all the registrations of SQL Servers are
>>missing from SQL Server Enterprise Manager. Did anyone faced this
>>situation
>>before? Its really painful to register 20 servers each time when login
>>password is changed. Some of the registered servers are windows
>>authentication and rest of them are SQL Server authentication.
>>Thanks a lot in advance!
>>Vinod Meesala
>|||Excellent Finding!! Thanks much Sue! I will try this Fix.
Vinod Meesala
"Sue Hoegemeier" wrote:
> Sounds like this may be the issue you are running into:
> FIX: Registered remote servers disappear from SQL Enterprise
> Manager in Windows XP when user password is changed
> http://support.microsoft.com/?id=323280
> -Sue
> On Thu, 17 Aug 2006 13:39:02 -0700, VM
> <VM@.discussions.microsoft.com> wrote:
> >Hi All,
> >
> >Recently a strange behaviour was seen with Enterprise manager. When we
> >change the Windows login password all the registrations of SQL Servers are
> >missing from SQL Server Enterprise Manager. Did anyone faced this situation
> >before? Its really painful to register 20 servers each time when login
> >password is changed. Some of the registered servers are windows
> >authentication and rest of them are SQL Server authentication.
> >
> >Thanks a lot in advance!
> >
> >Vinod Meesala
>

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?
>

register local instance with MSDE

Thanks in advance.
I am trying to register my local machine with MSDE 2000.
SQL server authetication keep rejecting my login id and password.
Please, advised me why it is not accepting.
Is it because I don't have installed server portion of SQL 2000 Server?
What exactly do you mean "register local instance with MSDE"?
When you say "SQL Server authentication keep rejecting my login id and
password", do you mean you was trying to connect to the MSDE by supplying
username/password pair (meaning the MSDE must be enabled on mixed security
mode)? Since by default installation, only Windows Integrated Authentication
mode is enabled, unless you specifically enabled mixed security mode on the
MSDE, you will not be able to access the MSDE by supplying
username/password. This could be the cause of your problem.
"Jay" <Jay@.discussions.microsoft.com> wrote in message
news:C83EC5C8-012D-4155-AA55-5228713A967C@.microsoft.com...
> Thanks in advance.
> I am trying to register my local machine with MSDE 2000.
> SQL server authetication keep rejecting my login id and password.
> Please, advised me why it is not accepting.
> Is it because I don't have installed server portion of SQL 2000 Server?
>
>
|||Thank you Norman for your clarification.
In MSDE SQL Server Enterprise Manage, under Microsoft Servers and SQL Server
Groups, I am trying to connect (LOCAL)(Windows NT: this is my local machine).
I am having this error message: Connection Failed, check SQL server
Registration
1.Using Windows Authentication in "Edit SQL Server Registration Properties"
Error message: A connection can not be established to (LOCAL).
Reason: Login failed
2.SQL Server Authentication in "Edit SQL Server Registration Properties"
Error message: SQL server registration failed.
Login failed for user.
3. Network administrator can connect to this "LOCAL" machine.
Will you help me to clear oou my confused minds?
Thanks, again.
"Norman Yuan" wrote:

> What exactly do you mean "register local instance with MSDE"?
> When you say "SQL Server authentication keep rejecting my login id and
> password", do you mean you was trying to connect to the MSDE by supplying
> username/password pair (meaning the MSDE must be enabled on mixed security
> mode)? Since by default installation, only Windows Integrated Authentication
> mode is enabled, unless you specifically enabled mixed security mode on the
> MSDE, you will not be able to access the MSDE by supplying
> username/password. This could be the cause of your problem.
> "Jay" <Jay@.discussions.microsoft.com> wrote in message
> news:C83EC5C8-012D-4155-AA55-5228713A967C@.microsoft.com...
>
>
|||There is no such product as: "MSDE SQL Server Enterprise Manage".
Are you using EM with a properly licensed SQL Server installation?
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Jay" <Jay@.discussions.microsoft.com> wrote in message
news:8CBFEED6-75E2-4215-9D38-B55F8E98F348@.microsoft.com...[vbcol=seagreen]
> Thank you Norman for your clarification.
> In MSDE SQL Server Enterprise Manage, under Microsoft Servers and SQL
> Server
> Groups, I am trying to connect (LOCAL)(Windows NT: this is my local
> machine).
> I am having this error message: Connection Failed, check SQL server
> Registration
> 1.Using Windows Authentication in "Edit SQL Server Registration
> Properties"
> Error message: A connection can not be established to (LOCAL).
> Reason: Login failed
> 2.SQL Server Authentication in "Edit SQL Server Registration Properties"
> Error message: SQL server registration failed.
> Login failed for user.
> 3. Network administrator can connect to this "LOCAL" machine.
> Will you help me to clear oou my confused minds?
> Thanks, again.
>
> "Norman Yuan" wrote:
|||Sorry for confusion!
I just put MSDE in front of SQL Server Enterprise Manager to emphasize that
it is MSDE not SQL Server.
Thanks
"Arnie Rowland" wrote:

> There is no such product as: "MSDE SQL Server Enterprise Manage".
> Are you using EM with a properly licensed SQL Server installation?
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to the
> top yourself.
> - H. Norman Schwarzkopf
>
> "Jay" <Jay@.discussions.microsoft.com> wrote in message
> news:8CBFEED6-75E2-4215-9D38-B55F8E98F348@.microsoft.com...
>
>