ACT Database will not open... no error message

[jeremyp]

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 16.1.207.0, Hot Fix 2

[jeremyp]

help please :/

[jeremyp]

It has now been 8 months and we are still unable to open the database. Can anybody help please?

[Scott Baker]

jeremyp,

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:

1. What operating system are you currently running?
2. Is this a shared Database over a network?

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:

1. 26854 Using the ACT! Diagnostics Utility (ACTDiag) to Repair and Rebuild Your Sage ACT! Database - http://kb.swiftpage.com/app/answers/detail/a_id/26854

[jeremyp]

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.

Thanks

[Scott Baker]

jeremyp,

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