Community
Showing results for 
Search instead for 
Do you mean 
Reply

sa password reset/usage

Copper Super Contributor
Posts: 128
Country: USA

sa password reset/usage

sa password is easily changed with "SQL Server Management Studio"

then you can reset it with "ActDiag" ie creating new dbs in act.

 

having said all this i noticed that act is trying to login as "SA user" upon startup.

my question is whats is the purpose for act to logon as a "SA user" I can not see any functionality issue that i have tested

 

other than creating new dbs

 

thanks inadvance

server stats: Ms Svr Std 2k8, Ms SQL Svr 2k8 R2 build 10.50.4302, ACT! Premium (Web) 2014 v16.0.291.0_HotFix5, 16GIG Memory
http://www.act.com/support/getting-started-documentation
http://www.act.com/support/downloads/act-premium-v16
http://kb.swiftpage.com/app/answers/detail/a_id/36097kwAdministrator%27s%20Guide
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: sa password reset/usage

Copper Super Contributor
Posts: 128
Country: USA

Re: sa password reset/usage

now answering a question with question is not excactly polite...but I am game never the less

 

using act7 on the ms.sql2k7 latest builds 10.50.4270 as an instance

 

backup etc

but more so i have other crms instances running that on ocasion require SA access so I default the sa user

then restore via actdiag if needed

 

so no why would you ever puchase the password from sage.....btw have ocean front property 4 sale in arizona

they should be more concerned with file security hence another post in this forum

 

so what is the answer to my question

btw I am in act7 2013

 

 

 

server stats: Ms Svr Std 2k8, Ms SQL Svr 2k8 R2 build 10.50.4302, ACT! Premium (Web) 2014 v16.0.291.0_HotFix5, 16GIG Memory
http://www.act.com/support/getting-started-documentation
http://www.act.com/support/downloads/act-premium-v16
http://kb.swiftpage.com/app/answers/detail/a_id/36097kwAdministrator%27s%20Guide
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: sa password reset/usage

I'm not sure of the reason it requires it

But, purchasing the sa utility means corporate backup programs can run - at least those that need sa ... but, easier than that is backing up with the ACT! Scheduler to ZIP and having the corporate backup store that

Copper Elite Contributor
Posts: 260
Country: Australia

Re: sa password reset/usage

Answering a question with a question usually just means that we need a little more specific information.

 

As Mike suggested, I would (and do) use the ACT Scheduler to create the backup zip file.

Cherie Buttsworth
ACT! Certified Consultant
Simply PC
cherie@simplypc.com.au