September 11, 2009 at 1:39 am
We are trying to change the login and password of the server.
In one of the server login for sqlserver agent and mssqlserver is different.we changed the login to "abcdef" and password for mssqlserver and restarted the service.but after connecting to the server i am unable to expand the node of the server under enterprise manager...it is throwing the error login failed for the user "abcdef"
what can be the reason ...can anyone help me
September 11, 2009 at 2:09 am
shanila_minnu (9/11/2009)
We are trying to change the login and password of the server.
In one of the server login for sqlserver agent and mssqlserver is different.we changed the login to "abcdef" and password for mssqlserver and restarted the service.but after connecting to the server i am unable to expand the node of the server under enterprise manager...it is throwing the error login failed for the user "abcdef"
what can be the reason ...can anyone help me
Ok.., first of, you mention enterprise manager, are you using sql 2000 or sql 2005?.
what tool did you use to change the account and which account was it previously using. I would assume that you were using a windows account for the sqlserver/sqlagent account.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply