June 11, 2008 at 8:36 am
Hello,
I have a SQL 2005 clustered environment for a sharepoint portal - and am suppose to change the identity level passoword. Can someone let me know the steps to do this. Please note am not much aware of cluster environment and impact happening on other nodes etc... hence requesting to provide me steps in detail.
June 11, 2008 at 8:47 am
What is the "identity" password? sp_password, run against the virtual server, will change the password for the login.
June 11, 2008 at 9:28 am
I am not sure about " identity Password". I am prety much sure that if you wanted to change your password in SQL server login use this SP...
sp_password [ [ @old = ] 'old_password' , ]
{ [ @new =] 'new_password' }
[ , [ @loginame = ] 'login' ]
Please be make sure that you could do this on Virtual server and then tryto failover the server check to login with your new password. It will work.
MCP, MCTS (GDBA/EDA)
July 2, 2008 at 6:18 am
Hi,
I followed the following steps and it worked for me:
- Use SQL Server Configuration Manager to change the Cluster password. (Start > All programs > MS SQL SErver 2005 > Congiguration Tools > Server Configuration Manager)
- Select SQL Server 2005 Services
- Sort by Lon on As
- Go to properties of each resource and change the password in Log on tab
- Right Click and Start the service
- Service Starts only if Password is correct.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply