I’ve turn off the firewall both on laptop & tablet.
In sql configuration manager I’ve check the protocol for sambapos all enabled.
In sql server management studio, I’ve tested connect to server. All doing fine.
Should i try deleting all sql things then reinstall it back? Where did im missing
You have tried SQLMS from tablet to SQL Instance on laptop?
U mean install sqlexpress on the tablet then make the laptop follow the string from tablet ?
No, install sql managment studio on tablet and check that it can connect to sql instance on laptop.
Am going to hazard a guess kendash got it with the mixed mode auth.
In the mean time double check a ping from table to laptop to be sure they can see eachother
That’s a new thing for me
i’ll try it
Ping is easy from cmd prompt so try that first.
Then try MSSQL Manager from tablet to connect to laptop SQL.
As I said the more is discussed more I suspect the mixed mode auth as kendash said…
Or try and make a new user on tablet with exact user and pasword as laptop and then try from within that user, or add tablet user to SQL auth list but its much easier just to use mixed mode.
hello JTRTech
i’ve solve the problem.
my tablet can connect to database when i browse for server in sqlms and then select network servers.
here is the photo. i did not try sqlms from tablet so sql instance on laptop.
thanks a lot for spending time to help me
I just select the network server and it’s working
I dont se how thats solved it… is samba now working on the tablet?
Connecting via SQL manager wouldn’t have fox it itself…
What did you find? What was the problem?
I’m sorry. I think it is just about router problem.
overall i think it is about that.
Hello! Connecting to database server tested with udl file, its OK, but sambapos can’t connect Any ideas?
id say your connection string is wrong. Check your instance name is correct.
Post your connection string here
1 Like
Data source=vekonykliens-pc\SAMBAPOS3; User Id=sa; Password=sambapos
The connection string to sql server at the server terminal is OK.
Open Sql Server Configuratin Manager and check the Server Services are running…
If they are, open services (services in the start menu) and check the SQL Server instance is running.
Thats whats needed to connect to the server, windows 10 has a habit of disallowing the user on boot. Might be worth changing it to Delayed Automatic.
Matt
1 Like
Sir/Madam (?)! This needs to be in a topic of its own: Firewall Friendly Samba. Thanks a tonne. Much obliged!