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.
CheersHi
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]