Community
Showing results for 
Search instead for 
Do you mean 
Reply

SQL Database Instance is Unavailable

New Member
Posts: 1
Country: United States

SQL Database Instance is Unavailable

[ Edited ]

We recently switched over to ACT! 2011 and have one person using a laptop with a remote database. When we first set it up, it was synching fine, but now we seem to be having issues. Every time we try it says "The SQL Database instance is unavailable. Contact your administrator for assistance." I have followed the steps to make sure the Protocols for ACT7 are enabled, and everything seems to be working fine. The SQL server says it is started. Any suggestions on what else to do?

New Member
Posts: 8
Country: USA

Re: SQL Database Instance is Unavailable

Any answers for this?  I am getting the same thing.  I just want to get this working.

Copper Elite Contributor
Posts: 233
Country: USA

Re: SQL Database Instance is Unavailable

Hello Jess,

 

I would take a look at the windows firewall, or any antivirus firewall you maybe running.

 

Then add exceptions for sqlserver.exe and the browser as well. Below is the path to the files if you installed SQL on your c drive

 

C:\Program Files\Microsoft SQL Server\MSSQL##_##.ACT7\MSSQL\Binn.

 

You can also get more info from this KB Using your Anti-Virus/Firewall Software with ACT! by Sage

 

Let me know how it goes

Kurt Rosemann

Platinum Act! Consultants
Kurt@ActiveSales.net | www.ActiveSales.net | 877-569-8005
New Member
Posts: 8
Country: USA

Re: SQL Database Instance is Unavailable

In my case I have disabled the firewall with no efftect.

 

Thank you for your help, any other Ideas?

Copper Elite Contributor
Posts: 233
Country: USA

Re: SQL Database Instance is Unavailable

Hello Acole,

 

I need more information from you, which version of ACT! are you running, What version of windows, are you running any kind of virus protection, and if so does it have a firewall built in?

 

What version of windows are you running?

 

If you running windows XP please click on start then run, in the run box type services.msc, if you're running vista or windows 7 just type it in the search box, when the services come up is look for SQL Server (ACT7) is it started?

 

Thanks,

Kurt Rosemann

Platinum Act! Consultants
Kurt@ActiveSales.net | www.ActiveSales.net | 877-569-8005
New Member
Posts: 8
Country: USA

Re: SQL Database Instance is Unavailable

I am running:

 

ACT 2012 Pro SP1 (just downloaded and installed from the Sage site)  I purchased full versions but have not gotten the serials yet.

The database is from ACT 2009 Premiun what has been downgraded and moved from a different system.  Computer 1 (the Host) is working just fine, Computer 2 (the remote, in the same domain on the same LAN)

 

Both computers are both brand new Windows 7 64bit with no previous copies of ACT.

 

SQL Server (ACT7) is it started on both systems

 

Thank you for your help!

Copper Elite Contributor
Posts: 233
Country: USA

Re: SQL Database Instance is Unavailable

Acole,

 

What exactly are you trying to do, Synch a database?

 

What is the exact error message you are getting?

 

 

Kurt Rosemann

Platinum Act! Consultants
Kurt@ActiveSales.net | www.ActiveSales.net | 877-569-8005
New Member
Posts: 8
Country: USA

Re: SQL Database Instance is Unavailable

All I want to do is be able to open the database on the second computer. Smiley Sad

Copper Elite Contributor
Posts: 233
Country: USA

Re: SQL Database Instance is Unavailable

Acole,

 

So you're not trying to sync?

Are you trying to share a database across the network?

 

Can you open the demo database or create a new database on the second machine?

 

And if you have a error message that would help me a great deal

 

Thanks,

Kurt Rosemann

Platinum Act! Consultants
Kurt@ActiveSales.net | www.ActiveSales.net | 877-569-8005
New Member
Posts: 8
Country: USA

Re: SQL Database Instance is Unavailable

No I am not Syncing.

 

No error message on the local ACT Demo data base on Computer 2 and I can open the demo database of computer 1 on computer 2.  I never opened the demo database on computer 1 with computer 1.

 

This is really fustrating, it should work.