Hi, Sql server credentials change resulted in MOSS breakdown. I am unable to run a single site in MOSS. Kindly help! Goraksh

Hi, Which SQL server credentials you have changed ? Default content Access account's credentials ? or farm admin account ? Please follow the procedure mentioned in below article to update farm credentials once. http://support.microsoft.com/KB/934838 This will update all credentials in farm and its not required to change farm admin account's password, you just need to update content access account or credentials used in SQL server. hope this helps. Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/

Hi, Just open your central admin and add sql account into "Site Collection Administrator" OR you can update farm credential. stsadm -o updatefarmcredentials -userlogin DomainName\UserName -password NewPassword Let us know if it worksCheers, Hemendra-MCTS "Yesterday is just a memory,Tomorrow we may never see"

I am sorry for incomplete information but i am new to sharepoint. I can just say that our network administrator changed the password for the 'sa' user and then the moss sites stopped working. Hemendra, tried stsadm -o updatefarmcredentials -userlogin DomainName\UserName -password NewPassword but it didnt worked...

I am sorry for incomplete information but i am new to sharepoint. I can just say that our network administrator changed the password for the 'sa' user and then the moss sites stopped working. Hemendra, tried stsadm -o updatefarmcredentials -userlogin DomainName\UserName -password NewPassword but it didnt worked... please suggest, i've tried everything i can....

Hi, Add you farm admin in your database server and Just try to run "Sharepoint product and technologies configuration wizard" from start-->Programmes--->administrative tool. I am not sure whether it will work or not. Refer this article fro more information for configuration http://technet.microsoft.com/en-us/library/cc263093%28office.12%29.aspx Please let us know if it worksCheers, Hemendra-MCTS "Yesterday is just a memory,Tomorrow we may never see"

Thanks Pratik, Hemendra for your suggestions. This problem is resolved now. It worked by executing all the commands in http://support.microsoft.com/KB/934838 provided by Pratik Vyas. I first executed all the commands in above article and then changed the database credentials in Central Administration->Application Management->Content Databases and it worked. Although i tried changing the database credentials before but it didnt worked. It worked only after executing the commands in the aforementioned url. Please let me know what could be the probable cause of this problem. Thank You Friends!!!!

Thanks Pratik, Hemendra for your suggestions. This problem is resolved now. It worked by executing all the commands in http://support.microsoft.com/KB/934838 provided by Pratik Vyas. I first executed all the commands in above article and then changed the database credentials in Central Administration->Application Management->Content Databases and it worked. Although i tried changing the database credentials before but it didnt worked. It worked only after executing the commands in the aforementioned url. Thank You Friends!!!!