SQL SERVER help

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