Hello all!
First of all I hope you guys as restaurateurs could cope the last 3 months and I hope life has given you a chance to reset and re-evaluate your businesses and your family, I definitely have had a big change of heart regarding my businesses, for us here in South Africa it has been a wild ride with even cigarettes and alcohol being banned during the hard lockdown.
My current problem is a old favourite on the forum: Database not connecting on network terminals
I have followed every post about DB connection problems on the forum and I have done my best to research but I can not find the problem to rectify itself. I have installed DB on a few servers in the past so did not think I would struggle, but here I am. Please have a look at my screen shots and see if you can spot a mistake.
server name: SERVER
instance: SAMBAPOS (not SQLEXPRESS)
user: sa
password: sambapos
databse: sambapos5
Firewall off on all pc’s and server
SQL specified ports TCP1433 & UDP 1434
TCP 1433 & UDP 1434 on inbound firewall
Same network, all connected and shared
Server PC sambapos connected to DB and message server connected
SAMBAPOS sql TCP/IP enabled, remote network allowed.
erase your sambasettings file from c:/programdata folder then restart sambapos. Try connecting with the ip by editing the connection string again and give us a screenshot of it.
PS your sql server appears to be on 192.168.1.8 not .16?
How are you changing it? just entering it in the prompt that pops up? You need to change it in the sambasettings text file located in programdata hidden folder under SambaPOS
So my message server on terminal reports IP as sever 192.168.1.8 but sql is on 192.168.1.16 and both work? I’ll take those rules off for now and try and get it back to PC names as I had it pre-lockdown. Thank you again, will try other options now to clean it up.
edit:
Of course SQL and Message service have nothing to do with each other