How to reset sa password (GP 8.00g34)

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I need to get sa access to a GP 8.00g34 environment. I am the sole person remaining from a company that went under (recession) and I need to output some reports as a part of closure.

I do not have access to the person that had the sa password.

Can anyone tell me if there is a method of resetting the sa password? My normal duties did not need me to have access to the financial modules for running trial balances, etc. 

I have full admin access to the Win2003 environment the server is on. 

Can anyone offer suggestions?

I am a registered GP owner/user and this is my machine and my data. In the chaos of closing down I never thought to ask for the sa password from the person that had it.

Any help is appreciated!

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
jeffwsi Members Profile Find Members Posts MicrosoftDynamicsForums.com Member Joined: September 19 2006 Location: United States Status: Offline Points: 13	Post Options Post Reply Quote jeffwsi Report Post Thanks(0) Quote Reply Topic: How to reset sa password (GP 8.00g34) Posted: December 07 2009 at 5:18pm
	I need to get sa access to a GP 8.00g34 environment. I am the sole person remaining from a company that went under (recession) and I need to output some reports as a part of closure. I do not have access to the person that had the sa password. Can anyone tell me if there is a method of resetting the sa password? My normal duties did not need me to have access to the financial modules for running trial balances, etc. I have full admin access to the Win2003 environment the server is on. Can anyone offer suggestions? I am a registered GP owner/user and this is my machine and my data. In the chaos of closing down I never thought to ask for the sa password from the person that had it. Any help is appreciated!

Sponsored Links

Rohtash Kapoor Members Profile Find Members Posts Visit Members Homepage MicrosoftDynamicsForums.com Moderator Joined: July 06 2005 Location: United States Status: Offline Points: 652	Post Options Post Reply Quote Rohtash Kapoor Report Post Thanks(0) Quote Reply Posted: December 07 2009 at 7:53pm
	"sa" is SQL Server user (system administrator). Login to machine running SQL Server as local administrator or as an account who is member of Administrators Group. I am assuming you have SQL Server 2000. Start SQL Server 2000 Enterprise Manager. Under Security -- right click "sa" and reset the password.
	Microsoft Dynamics Books * Microsoft Dynamics Jobs

qingshanlvshui Members Profile Find Members Posts MicrosoftDynamicsForums.com Member Joined: June 24 2011 Status: Offline Points: 2	Post Options Post Reply Quote qingshanlvshui Report Post Thanks(0) Quote Reply Posted: June 30 2011 at 4:05am
	If you want to reset sa password, i suggest you can do it with the help of the third party. my boyfriend experienced the same situation last month, he tried SQL Password Recovery. He said it is useful and easy-to-operate.
	duocai duoyi