English Boards > Support

Installing SQL Database

<< < (2/2)

emre:
Hmm it is a general error message so it is hard to understand the exact problem. Since you can connect with SQLCMD you should be able to connect with SambaPOS too. If SQL Express installed as default instance you should only type server name as data source. You can try adding an additional ";" at the end of the password maybe...

md7rlz:
Johan, check you TCP/IP is enable in your SQL Express configuration. (when you install SQL Express for default  TCP/IP is disable)

bosonmez:
i had the same problem but i solved it.
first check the sql server to get the tcp/ip port that sambapos uses.  my sqlexpress uses tcp/ip=2487.
then open sambasettings.txt. (click start-> programs->sambapos->samba data ...)
find the sentence "data sourse=......... "
and and change to:

"data source=[servere]\[Instance],[port no]; user id=[userid]; password=[password]"
for example my settings is
"data source=BOS\SQLEXPRESS,2487; user id=sa; password=123"
you should write tcp/ip port number. it worked for me.

JohnS:
SQL Express can be difficult to get going. I have found also that sometimes if SQL Server Browser is not running (usually disabled after install) you can experience remote connection issues to the database.

computserve:
Hi everyone,

Thank you for take your time to read this message. I really appreciated.

I'm really new to SambaPOS and we have three computers need to work. It need to be network.

My goal: I need your help how to setup three PCs to run SambaPOS.
   -Server
   -Client1
   -Client2

What I did:
step 1:   I installed SambaPOS2 =SambaSetup299a into a Server=hostname and Client1=hostname.
step 2: I installed SQLEXPRWT_x86_ENU
step 3: I enable TCP/IP like here: On the right, you'll see TCP/IP. Right click into “Properties." Click on the second tab that says "IP Addresses." Scroll to the very bottom and make sure that "TCP Dynamic Ports" under "IPAll" has the port number you're using. Click ok.

Done installation!

I went Server=hostname and change the default string into  data source=Server\SQLEXPRESS according to instruction here: http://sambapos.org/en/content/client-server-baglantisi-nasil-yapilir


I went to computer Client1=hostname and click on SambaPOS2 icon on desktop and open the program:
-Typed default password
-Manage => Settings  => Local Settings  and changed data source=Server\SQLEXPRESS the same as server ten I got this error message pop up say" Error message: the provider did not return a providermanifesttoken string "
How can i fix it? what is the right way to start it.
Please help, Thank you!

Navigation

[0] Message Index

[*] Previous page