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,584
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,584
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

Highlighted
Copper Elite Contributor
Posts: 265
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