SQL Database not found

[frase]

Unsure if anyone will be able to assist. Though have something I have no idea about. It is a program called "Coach Manager" - used by a travel agency.

https://www.distinctive-systems.com/au/products/coach-manager/



That is the error received - It is SQL based, which I have no Idea about. It is linked to another system.

 

[Sky-Knight]

Do you have a working system? If so, that one probably has the database on it. You'll have to figure out how to configure the SQL connection string to fix this one. Honestly, this is where I usually just pick up the phone and call the company that made that mess, and get their techs to help me.

 

[HCHTech]

I agree with @Sky-Knight. Something about the path to the original database has probably changed. Without more information, it's impossible to troubleshoot. Try to figure out where the database was originally, that would help.

 

[RCHavok797]

It is possible the SQL service on the server hosting the SQL database has stopped. Go into the services console and check if it is running.

 

[brandonkick]

Also possible that the remote machine (if it's remote) is no longer accessible, or the DB is no longer online for whatever reason.

I often wonder about software like this... is it a scenario where you have to roll your own SQL server / database and then simply connect the software to the instance allowing it to do the rest? Or is it a situation where all this stuff happens on it's own under the hood so to speak?

Without knowing how the initial setup was done... it'll be hard to say what the issue is. It could be a bad / missing connection string, it could be a remote machine no longer accessible, it could be issues with SQL services, it could be issues with the database itself....

 

[cypress]

I am assuming it is set up a P2P network? I would honestly reach out to the vendor and ask for assistance they know their software better.

 

[frase]

Thanks all finally sorted the issue out. I found out where the server was located (as I did not even know where it was located, neither did staff). It was in all places in the bookcase

So found out logon to server and ran SQL Admin. Added a new string for new USER and added RDP for new user to logon to server.

YAY!