PLease HELP
I installed SQL SERVER 2014 on windows 10
dont know how to connect SambaPOS Database
I tired the tutorials
Please give us more info, like errors, or whats going on?
did you create a DDBB?
G.
SERVER NAME
ADAM\SAMBASQL
DATABASE NAME : SAMBAPOS
USERNAME:
ADAM\Adam
Data Srouce =ADAM\SAMBASQL ;User Id=ADAM\Adam ; Password samba2016 ; Database = SAMBAPOS
ok, so far so good…
Do you have SQL SERVER Managment Studio installed? that way we can test DB connection…
What does Samba do? just blue screen?
Is SQL Server Service already started? In my machine with windows 10, sometimes I have to start it manually…
G.
SAMBA sayes connection error provider named pipes provider , error : 40
SQL running and all okay
Do you have SQL SERVER Managment Studio installed?
yes installed and running
ok, start SQL SERVER MANAGMENT STUDIO and print a connection screen so I can see the connection
but error 40:
pc not connected to internet now , i`m on mac
If you copied and pasted that here in the forum, then it could be your problem.
- the
=symbol is missing after “Password” - “Data Srouce” is also incorrect. Should be “Data Source”
- The password is caSe-seNsiTive as well
- And the User Id … is that the computer logon account or did you create that in SSMS. By default, the “sa” account should be used.
It should be something like:
Data Source=ADAM\SAMBASQL; User Id=sa; Password=samba2016; Database=SAMBAPOS
Did you set it for mixed-mode authentication during installation?
Use SSMS to test connection to the DB. Once you get that working, then adjust SambaPOS connection string as required.
2 Likes
thank a lot
i did connected successfuy to database to samba
but when i intaled samba , i installed samba alone without sql expres
i installed full sql server 2014 seperatly
the thing is when connection is okay fom samba to sql , samba says message error missing tables??
should i have a tables instlled ??
thanks