03-21-2017 08:34 AM
I am running Act 2011 on a laptop running Windows 7 as a local database. My email is Lotus notes but I use Linkpoint 360 to attach lotus notes emails to Act. I have detached the.pad files and re attached using actdiag. I still get the unable to open the database. When I use the open database option it gives me a failed to connect to database, click on ok and I get object reference not set to an instance of the object. I have restarted the SQL server. Any suggestions?
04-10-2017 08:16 AM - edited 04-11-2017 01:50 AM
Go to this thread and follow the instructions to remove the zero sized database.
http://kb.act.com/app/answers/detail/a_id/38647
The syntax must be followed exactly for it to work.
Once removed go back to my original suggestion below.
Saturday
Now that you can create a database we know that SQL is running.
I know you did this before but please try again the following -
Find the .PAD file you database and rename .OLD
Now in ACT select File - Open Share Database - (Ignore database in the list) Click Browse for Database
At bottom right change by selecting from PAD to ADF file type.
Now browse to your database and try and open it.
.
03-21-2017 10:45 AM
03-21-2017 11:13 AM
The error occurs in act. It comes when I'm trying to open the database ADF file. I am unable to create a database, the error is unable to create database.unable to connect to the microsaft SQL server
03-21-2017 01:43 PM
03-21-2017 01:58 PM
Yes I'm on a local machine, the ADF file is on my hard drive
03-22-2017 04:20 AM
Hi kelleym1,
Please download the attached ResetSQL.bat file and run it as administrator in Windows.
Test accessing the database again after completing this.
Watch for any error messages that appear while running the .bat file. Let us know what they are if you see any.
04-06-2017 01:45 PM
Sorry long process, our new corporate security level would not allow me to run this program, just got my security level changed and ran it but still not working. get the same error
04-07-2017 03:12 AM
04-07-2017 08:54 AM
Gary,
Thanks for all your help. I did not see any errors running the bat file. I just tried it again and I had not selected turn of password policy. I did it this time and I can now create a database. I am not able to access my existing database. I brings up the log in screen with my user name, when I click ok I get this message.
04-08-2017 02:41 AM
Now that you can create a database we know that SQL is running.
I know you did this before but please try again the following -
Find the .PAD file you database and rename .OLD
Now in ACT select File - Open Share Database - (Ignore database in the list) Click Browse for Database
At bottom right change by selecting from PAD to ADF file type.
Now browse to your database and try and open it.