×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

SA password reset

SA password reset

SA password reset

(OP)
Hi, i am having problem with sql SA password for sage erp accpac.

SQL error when try to open database. ( property is locked is not available for login) the SA password did not change,
when o try to configure database in ODBC i get error when using the sa account. nothing changed in the sql or sage erp accpac UI sa.

anyhelp please,

regards,

RE: SA password reset

Check your work, you made a simple mistake. sa passwords don't change by themselves.

Sage 300 Whisperer

RE: SA password reset

(OP)
No did not change the SA passw. can i reset it????

RE: SA password reset

Yes

Sage 300 Whisperer

RE: SA password reset

(OP)
So how can i reset the passw??? i have multiple database. some of them connect with windows authentication, however cannot connect all of the database.

RE: SA password reset

Reset it in SSMS, of course.

Sage 300 Whisperer

RE: SA password reset

SA passwords can be set to expire, I've run into that a few times.
Best advise is create an SQL user specifically for Sage and set the password to something easy to remember, and make sure it does not expire. That way there is no snafu if IT decides to change the SA password on you.

Sage 300 Certified Consultant

RE: SA password reset

Hi dikidushi,

This may be when MS SQL Server is installed with Windows Authentication only.

Try switching Security to mixed mode ie., both Windows and SQL authentication might resolve the issue.

How to change to mixed mode check the below link
http://kb.kcsi.ca/Knowledgebase/How-to-Change-from...

Hope this helps

Thanks,
Krish

RE: SA password reset

You can login your SQL or sql management studio with Windows Authentication, after that go to security, and find sa user, and properties, you can change your password

RE: SA password reset

@gmaji - That will work only IF you have set up AD access when the server was installed. It's not turned on by default.

Sage 300 Whisperer

RE: SA password reset

Like KrishSP Said, when installed the SQL we can chose Windows Authentication only or both, if we choose Both we need create SA password.
but if you forgot the SA password after that you can login the SQL chose Windows Authentication.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close