Both of my workstations can’t access my server. Server works fine but both workstations get the data source error message on samba startup. Only thing different I can think of was that there was a customer ticket left on the server last night (nothing rang in but screen was left in the actual ticket) then the work period was closed from one of the workstations this morning. This afternoon I found the server still in the ticket so I just closed it. Workstations seemed to lose connection shortly after that. Anyone run into anything like this? I’m hoping restoring an old backup in the morning will fix this but I’d like to avoid that if possible.
Are you running SQL Server? Restoring backup will have no affect the only thing that affects it connecting is your computers network setup and the connection string. Can you show the actual error message?
Typically when it happens in the scenario you explained its usually the SQL server stops responding or accepting connections sometimes you need to get the SQL server running again.
Hi Chipwagon, sometimes easy solution. Shut down all computers, and start with restarting the Master with sql database and once running switch on the workstations. Good luck.
I have tried restarting everything but no luck. I have SQL server 2012 and it appears to be running and the connection string shouldn’t have changed?? Open in 2 hours and I’m really at a loss on what to do next…
Check the firewall on the server machine…
Tried turning off the firewall too with no luck
Check if you can ping server from workstations, also network cables, router power…
1 Like
Have you restarted all computers?
As said above, shutdown, turn server machine on first any allow time to boot fully before turning other machines on.
I have restarted all comps numerous times with no luck. Network seems fine. Server and one workstation on wifi and other workstation is plugged in. How do I ping server from workstation?
Do you have any shared folders on the till that are on the server? Can you access those?
Did you say Samba works fine on the server (localhost)?
Ping is a network tool, you can do in cmd promp; ping 192.168.1.100 where the ip is your server, or server hostname.
You would get something like this;
Samba works fine on the server. Can’t ping the server from either workstation. I get request timed out. Sent=4 Received=4 Lost=4 100% loss. Internet works fine though??
Sounds like either firewall blocking it or router blocking it.
1 Like
That defiantly sounds like a network issue to me.
Without knowing more detail on your network and config its hard to suggest solutions.
@Jesse has the right first place to start.
This is an internal network issue, and it can be caused by many things.
Just because the Internet is working does not mean that the computers in your network can communicate with each other. One of the things that can cause this is the network type setting on your machines… are they set to Public, Private, Work, or?
What OS are you running on your machines?
I got it working now. Definitely network related. I think I have a conflict between 2 routers. Had to turn on the main router which for some reason only gave me a local network then I turned on all computers which connected to my database. Then I plugged in the other router which somehow supplied internet to the first router?? All is well for the moment…
Thanks to all for the help! Never cease to amaze!!
Depending on your wiring having two routers is a little odd, you might have conficiting dchp servers etc with they are both full routers, usually you might have a router for internet access and dchp and a switch to give more ethernet ports.
I would have a look into this at another time when your closed…
Generally I try to set static IP for any fixed terminal and configure the hosts file to exact IP on each terminal but dont try that if you dont know what your doing. Static IPs might be a good thing to look into, if you had a robust switch and static IP the internet router could be replaced/restarted without effecting the network.
2 Likes
The idea behind the 2 routers was so I could run all my computers on one and have the other for public access but so far it’s proving to be a nightmare! Hopefully it holds up until I’m closed for a day!! Thanks again!!!
That is a novel idea but if you have the routers hooked to each other then it defeats the purpose.
I have a similar setup at a place I help out at.
They have a very large network with 15 Wifi AP, 12 IP CCTV, about 10 office/PCs, 5 Tills, 12 live-in staff with their own PCs and phones etc etc and at times up to 150 customers/guests on wifi with phones and tablets etc.
What they have is two subnets on one infrastructure as a large property and limited cabling routes.
I have installed there hotspot/wifi and CCTV part of the network.
What I did was install a PFsence box which does all DHCP of 10.0.1.1 - 10.0.2.250, all the internal network (offices PC and CCTV etc is on 192.168.1.x subnet.
While they are on the same physical network subnet doesn’t provide additional security but keeps the general public in seperate ip range of the hotel.
All hotel devices are password protected and firewalls enabled and server is set to only accept connections from specified devices.
Pretty much there is one internet connection, all hotel devices connect directly to the main router, the PFsence box was WAN to the internet router and LAN back into the core network with DHCP on separate subnet.
That is where the 10.0.1.x - 10.0.2.x range comes in as over 24 hrs a standard 254ip subnet would get filled with leases.
This means any unaccociated device receives an IP from the PFsence box.
I used the pfsence box to limit bandwidth on a per device basis to 4Mb/s to reduce the effect of a single hotel guest slowing all internet with hi bandwidth thing like downloading but enought for general normal use and Wifi subnet to a total 12Mb/s which caps the public bandwidth useage to that the hotel office etc always have a respectable speed/bandwidth remaining of the respectable 16-18Mb/s they get in centre of town.
TO BE CLEAR THIS IS NOT A METHOD FOR SECURITY BUT TO ORGANISE TH NETWORK MORE EFFICIENTLY - A EXPERIENCED TECH/HACKER COULD STILL CAUSE ISSUES
2 Likes
I may do wifi at my restaurant sometime in the future but I was looking at a router that provides dualband simply use the 5ghz band for the Wifi and the 2.4ghz band for my SambaPOS computers. I mean the tablets. Of course the main computers will be ethernet.
Personally I am not too worried about security too much where I am at. The built in firewall and port control is enough for me.
The two router idea is not a bad one but it sounds like you may not have configured it well if they are competing for DHCP like that. Are they both assigning IP’s? I have used a linksys as a bridge before allowing the main router to run all the DHCP it worked great but required an open source firmware.
1 Like