Unable to open up a database

[fader5]

After a reinstall of windows 7 and Act pro 2013 I'm unable to open up any database. Error

The "(local)" computer could not be reached because the IP address " " could not be resolved. Verify the"(local)" computer is available on the network, that it has the correct IP address, and that Microsoft SQL Server is properly installed may resolve this issue.

Just install hotfix 1 did not help.

[ghollister]

Hello fader5,
If these are local databases on your machine:
- First, verify the SQL Server service running. See this Knowledgebase article:
http://kb.Sagesoftwareonline.com/cgi-bin/Sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=2704...
- If it is started, then the issue be with the database .pad files, which may now be invalid after reinstalling Windows. See this KB article for instructions to recreate the .pad file for each database:
http://kb.Sagesoftwareonline.com/cgi-bin/Sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=2895...

[fader5]

ghollister, thanks for the info. I did the the first one as you asked and did not work. I tried to create a new db and was unble to do that.

Reinstalled ACT Pro 2013

Tried to create a NEW Database and recieve the error

The database{0} could not be accessed. in order to access this database, check your network connection and verify that your database server is available. it may be necessary to disable firewall software on your computer or the server.

I feel i'm getting closer to fixing this.

Bill

[fader5]

Greig, couple of questions

1. Why does the error show:

            The "(local)" computer and not the name of my pc

2. I ran actdiag and I'm unable to connect to  to SQL Service Instance

[ghollister]

It did not name your computer because the SQL Server could not be accessed. Is the SQL Server (ACT7) service listed in your services list? If so, is it started and can you start it?

[fader5]

my  SQL server (ACT7) - Local system     is started

my  SQL Server (SQLEXPRESS) - Network Service is started

my SQL server Agent (ACT7) - Network Service        is not --- error windows could not start  SQL server Agent (ACT7) service on local computer. Error 1067: the process terminated unpectedly

my SQL server Agent (SQLEXPRESS) - Network Service        is started

my SQL Server Browser - Local Service           is started

[ghollister]

Browse to the ACT! program directory:
32-bit machine: C:\Program Files\ACT\ACT For Windows
64-bit machine: C:\Program Files (x86)\ACT\ACT for Windows

locate and run the "SecurityCmdLnApp.exe" file by right-clicking on it and selecting Run As Administrator

Also, in your services, did you see SQL Server VSS Writer?

[fader5]

ran SecurityCmdLnApp.exe as administator.  A DOS window opened and closed

and

SQL Server VSS Writer - Local System         and Started

Running on a 64-bit machine.

under my sql server network configuration (32 bit) there's nothing

[fader5]

Do I need .net framework 3.5?

[ghollister]

ACT! 2013 requires .NET 4.0