Community
Showing results for 
Search instead for 
Do you mean 
Reply

What is the sa password after actdiag resets it

Astute Commentator
Posts: 15
Country: United States

What is the sa password after actdiag resets it

I have client computers that access an ACT database on a central workstation.  I upgraded the whole lot to v21 and now I can't access the database using Crystal Reports.  I don't know the sa password.  Suggestions will be welcomed.

 

Thanks.

Employee
Posts: 333
Country: USA

Re: What is the sa password after actdiag resets it

Hello,

I think you will need to uninstall the SQL instance and install SQL with a desired password.
http://kb.act.com/app/answers/detail/a_id/38099/kw/install%20sql

 

I do not see any documents on the reset of password in actdiag.

http://kb.act.com/app/answers/detail/a_id/28641

 

Thanks
Carl

 

Carl Mag

Customer Success & Support Team

 

Highlighted
Nickel Super Contributor
Posts: 368
Country: United_Kingdom

Re: What is the sa password after actdiag resets it

Hi Leo

You could use the ACTReader user rather than the SA user for the connection in the report. The password for this user can be changed using the ActReader.exe in the act! install folder. 

 

I hope that helps