01-23-2015 11:47 AM
So I am attempting to open an existing ACT database, but when I select the database to open absolutely nothing happens. It goes back to the screen asking you to create or open a database. I checked to make sure all ACT and SQL services are running, and they are. I have rebooted the server multiple times to no avail. Any idea what may be causing this?
We are on this version of Act: Act! Premium (Web) Version 220.127.116.11, Hot Fix 2
08-27-2015 01:04 PM
Thank you for submitting your post. Sorry for the lack of communication on this issue. The issue you are having may be resolved by checking out our Knowledgebase at http://kb.act.com.
I have a few questions:
This problem could be caused by the database not being local to the computer. Look into the issue by going into the ActDiag. Start > Search ActDiag > Database List. Make sure it says ONLINE. Act Please view the link below for a solution that may fix the issue:
08-28-2015 11:50 AM
Scott, many thanks for your reply. This helped me get the database back online and I am now able to connect to it. The problem I am now having is: It prompts for a username and password when I connect. It has the users name in the username field, however the user does not remember the password. I've tried logging in with no password and that does not work. I have also tried creating a new SQL users under Security > user logins for the act database, but I receive an error: "test1 IS NOT A VALID LOGIN OR YOU DO NOT HAVE PERMISSION. (Microsoft SQL Server, error: 15007)
Is there a way for me to reset her password or create a new account to access the database? I have already tried detaching and reattaching. Also tried a rebuild and repair, didnt help.
08-28-2015 12:04 PM
Do you have a User that has Administrative rights to the database? If so you can login with that User and change the password for the user that cant login under Manage Users in the Tools Menu. Below there is link to a Knowledgebase Article that will walk through this process. If you do not have a Administrative User, please contact the Sales Team so they can go over your options for a password reset. They can be contacted at 1-866-873-2006.
19474 How To Manage Database Users in Act! - http://kb.swiftpage.com/app/answers/detail/a_id/19474