Setting Up System For a Restaurant? (Adding up 2nd Terminal)

[JTRTech]

.sdf is nothing to do with the SQL on your host machine.

Uninstalling samba will not reset as the connection string is saved in the settings file…

What is your connection string?

Can you PING the server/host machine from the second terminal?

[Jesse]

Restart your computer after you started the service.

[kadymp]

my connection string is on main computer

Data Source=Greenolive1-PC\SAMBAPOS; Database=SAMBAPOS1

[JTRTech]

Your using windows authentication then?
Is the user name and password for the second machine identical as the host machine?

[kadymp]

no main computer user name for the 2nd computer Green Olive 2 and the password are the same for both copmputers

[JTRTech]

Pretty sure you will have to make the username the same or add Green Olive 2 to the autherised users in SQL.
@Jesse can you confirm?

[Jesse]

Or set it to run mixed mode and create a specific user for that terminal.

[marannorama]

Hi everybody. I try to set up client PC to connect main PC maybe in the future i need it.
I use Win8.1
I set all settings up but when i try to connect, client PC does not it gives error. I check all my settings and read all topics but i did not manage.
The two PC at my home now, i connected wi-fi with my PCs. Do i need set network to connect both PCs each other or wi-fi connection enough?
Also i connect SQL with Windows authe… Do i need with SQL server authe…

[JTRTech]

Have seen few people struggle with windows auth on 8.1.
Think it’s because of windows trying to get you to use Microsoft account rather than traditional local user.
You would need to be sure the server gives access to the user of the client pc.
Easiest option is to enable mixed mode and set a single user and password.
There was a post the other day explaing how to do that.
Other points.
Test if you can ipf server from client, if not a network issue most likely. Try host name and IP address if fails, if ip works and host name doesn’t it’s a DNS issue, but you can bypass with host file or I believe use IP in connection string.
While testing if trouble connecting disable firewall on server machine - if works it’s firewall causgin problem.

[marannorama]

I tried but not succeded… I make TCP/IP enable. I tried to connect with IP…My main PC firewall close, SQL running…But there is connection string error

[JTRTech]

Can you ping the server machine from the client?

[marannorama]

So sorry what does ping mean?? How can i do that?

[JTRTech]

Data source error message

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; [image]

[marannorama]

Yes my sever PC working well there is not any problem. Only client PC… My server PC Ip is 192.168.1.105
and from my client pc i write ping 192.168.1.105 the result is above

[emre]

You can test SQL Server connectivity outside SambaPOS with this simple trick. If you can connect via UDL SambaPOS setup will be quite easier.

Sambapos4 string problem

OK so you can do it to test if your client computer can actually access to your SQL Server or not. On your client computer Create a new empty text file on desktop by right click and New > Text Document Change the extension of that text file from .txt to .udl It’s icon should change. Double click on it and you should see a dialog like this. [image] Fill details and click Test Connection button to test if your SQL Server is accessible.

[JTRTech]

So network connection seems ok.
Were you still using windows auth for SQL?

[marannorama]

Yes…windows auth i am using

[marannorama]

ok i am going to try now

[JTRTech]

Handy tip, will remember that one.
I hazard a quest auth with be the problem…

[marannorama]

@emre when i click test connection the result is