12-08-2008 12:45 PM
Last week, I was asked to install SQL Server 2008 on the same machine that was have our main install of ACT!2006 (v220.127.116.11).
This of course hosed our ACT install. On Friday, I uninstalled SQL Server 2008. ACT still would not work, so I uninstalled ACT and then did a new install. I then updated to the version that it was prior to the SQL Server 2008 install.
I receive the following error when I try to connect.
The client machines, located on the network are still not able to connect to the database. The database [DB Name] 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 any firewall software on your computer or the server.
I've tried many of the things that I can find out on the net to resolve this and I am pulling my hair out now. Originally, I was getting this on the machine that the DB is on, but the uninstalls and then the reinstall of ACT resolved it on the server machine.
The server is located on a machine running W2003 Server. The client machines are running XP.
Any suggestions/help would be appreciated. Everything was working fine prior to the install of SQL Server 2008.
12-11-2008 12:55 PM
We're you able to try all the steps in this knowledge base article?