Ok that looks good can you show the error message your getting?
BTW on the new terminal change Terminal Name to something other than Server.
To do that go to Settings > terminals and create a new terminal then go back to Settings > Local Settings and select the new terminal for Terminal Name.
YOu may already know but dont be confused by Message Server saying its not connected that actually is different and has nothing to do with the Database.
When you connect it to the switch via cable what is your error message? That could be a firewall issue or blocked port etc. Could be a number of things. If its working via wifi but not cabled network then its not a SQL Server issue or a SambaPOS issue it sounds like the switch or something hardware based.
currently (when its working) they are on same wifi. however, there is no internet at my restaurant. so i netwrok PCs through network switch. they connect and can see/access each others files/folders
With the networking issue how did you open the firewall on the server?
Did you specify work and home networks on the rule?
Check that the wired network has not been set to public or unassigned as if there is no gateway or network type not selected this can happen and if your firewall rule is set to work/home only the firewall might be blocking when connected by wire.
i used this and all went well…however, when i selected the newly created database and tried to create a ticket on migrated customer…system threw an error and closed. thats what happens whenever i try a ticket against a customer on newly created database. however, if i revert back to my database which was there before migration…it works OK…but it has no data as data is imported into the newly created database. name of my default data base is SAMBAPOS4 which works ok…name of database created for migrated data is Mydata3…this shows everything from the legaly system, however can process a ticket. screen shots attached below