Cannot open database after reinstall on new server

[debsw1]

We have installed a new server (SBS 2008) and had to reinstall ACT 2009, have created new databases from a restore all ok and these can be accessed from the server but we cannot access the database from any of the workstations, we get the following error: "The database <Database 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..." We have run through the standard document that is on act.com and this has made no difference.

We have also created a brand new database on the server and this also doesn't work so I'm quite happy with my databases and that the restore / database is all ok.

Any help would be gratefully received.

Regards
Debbie

 

[GLComputing]

Can be a range of options... you need to try these one at a time till you try them all...

http://kb.sagesoftwareonline.com/cg...ine.cfg/php/enduser/std_adp.php?p_faqid=19640

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Aust

http://www.GLComputing.com.au

http://blog.glcomputing.com.au

Join the LinkedIN ACT! Fanatics Group

http://www.linkedin.com/e/gis/49896

 

[debsw1]

Mike

Thanks for your advice, the firewall was the cause of the issues we were experiencing.

Regards
Debbie

 

[GLComputing]

Yup, that will do it

If ACT! is blocked from connecting to the database, you'll get that error

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Aust

http://www.GLComputing.com.au

http://blog.glcomputing.com.au

Join the LinkedIN ACT! Fanatics Group

http://www.linkedin.com/e/gis/49896