Act!Diagnostic cannot see database in database list - Username and password not working

[helpnout]

I am using Act 2012 on WIndows 7 laptop. This has happened once before and I was able to fix it but I canno remember how I did it.

For some reason the database has just recently gone into the the mode of asking for the user name and password in order to open it up. Like I said it happened a year or so ago and now again. The big challenge is the username and password I originally used does not work... grr. Now I cannot get in at all. I have been looking all over the net to see if there is a fix or a solution...

I have also tried going in to Actdiag to try and detach and reattach the database but I cannot even see it in the database list. I am at wits end with this and looking for a possible solution outside of paying for the tech support system to fix it for me.

Any help would be greatly appreciated.

Thank you

[dshaw111]

You can only see the databases with actdiag on the PC/Server where they are hosted.

[helpnout]

Yes I understand that. The database is on the same machine as the install of ACT. Its all running local on a single machine.

[dshaw111]

Is SQL running?

[helpnout]

Yup... Started and stopped it numerous times and double checked a couple times over... Going thru the services.msc route

I am starting to think maybe the db is having an issue. Is there anyway of checking the db outside of running it thru ACT. Seems strange that I cannot even see it thru ACTDiag... hmmmm and grrrr

[Roy_Laudenslager]

In ACT! have you tried to open the database using the ADF option rather than the PAD?

[helpnout]

Yup tried that as well. Originally when this all started I was getting the usename and pwd box (As per original post). After hours of scouring the web and K-Bases I have attempted a few things such as moving the db and trying to open various ways.

Now when I try to open it via ACT and the adf file the following is the result:

First this comes up:

Click ok and then the following:

Any ideas?

Thank you

[wellmet]

That means there is most likely a problem with the log file for the database.  Sometimes you can delete the log and use actdiag to attach a database missing a log file and get it to work.  Sometimes it requires more work.  If using actdiag doesn't work I can help you get it reattached but it would be billable.  If you're interested send me a private email or give me a call.

Stan