Enterprise Manager

Hi,
I am using enterprise manager to manage various SQL servers however one
server that was working now refuses to connect/register again The strange
thing is that if I register the server in question it tries connect using
the wrong username (not the one I am logged on as. I cant find where it
caches/stores the old account details. How can I change the account in
question? We are using SQL & Windows Authenication.
Cheers
Hi
In EM, right click on the server and select "SQL Server Registration
properties" and modify the login credentials.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Mikecl" wrote:

> Hi,
> I am using enterprise manager to manage various SQL servers however one
> server that was working now refuses to connect/register again The strange
> thing is that if I register the server in question it tries connect using
> the wrong username (not the one I am logged on as. I cant find where it
> caches/stores the old account details. How can I change the account in
> question? We are using SQL & Windows Authenication.
> Cheers
>
>
|||Hi,
Thanks for the info however I am using windows authentication, when Em try;s
to connect/register with this server It connects using a domain\test account
which does not have rights. The other registered servers are connected using
my domain\user account.
Where or why does this setting get retained. If I delete the registration
and try reegister it again it allways uses the domain\test account but only
with that server.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:018438CC-21D1-4BF9-B0D7-F904B8D86BD7@.microsoft.com...[vbcol=seagreen]
> Hi
> In EM, right click on the server and select "SQL Server Registration
> properties" and modify the login credentials.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Mikecl" wrote:
strange[vbcol=seagreen]
using[vbcol=seagreen]
|||Hi,
U can use sp_password to change the default password for the user.
hope this help
from
doller
Mikecl wrote:
> Hi,
> I am using enterprise manager to manage various SQL servers however one
> server that was working now refuses to connect/register again The strange
> thing is that if I register the server in question it tries connect using
> the wrong username (not the one I am logged on as. I cant find where it
> caches/stores the old account details. How can I change the account in
> question? We are using SQL & Windows Authenication.
> Cheers
|||Hi Mike,
Thanks for the info however I am using windows authentication and the
problem is the account it try's and connects with is not the one I am logged
on with e.g it uses domain\test account rather than domain\mike account.
Where/how does it cache this info. I have deleted and registered the server
but is makes no difference
Thanks
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:018438CC-21D1-4BF9-B0D7-F904B8D86BD7@.microsoft.com...[vbcol=seagreen]
> Hi
> In EM, right click on the server and select "SQL Server Registration
> properties" and modify the login credentials.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Mikecl" wrote:
strange[vbcol=seagreen]
using[vbcol=seagreen]