English Boards > Support

Installing SQL Database

(1/2) > >>

ani:
Hi,

I installed sambapos with compact sql and it works fine.  Now I install sql express to use it on a network, ,but where and when do sambapos creates the sql database?  I use  SQL Server Managment Studio, but can´t find sambapos database, thanks, -Ani

emre:
Hello ani, welcome to SambaPOS forums.
SambaPOS will automatically create database as soon as it connects to your SQL Express. Most probably you didn't configured SambaPOS to connect to SQL Express installation.

You can configure SambaPOS to use SQL Express from Management > Settings > Local Settings screen.

You can find more information from
http://doc.sambapos.org/doku.php/en/dbase/client_server_baglantisi_nasil_yapilir

ani:
Thanks for the soon response,

I am using:

data source=ANI-PC; user id=sa; password=sasql   

(this user and password works in SQL Server Management studio)
and I get this error:

Hata Mesaji:
The provider did not return a
ProviderManifestToken string.

Am I missing somethin?  Thanks, -Ana Maria

ani:
I tried with:

data source=localhost\SQLEXPRESS

and now it works fine, thanks.

Johan Hartono:
dear emre,

I am trying to install a client and connect to SQL Express server. I use connection string with the following format: data source=[Server Computer Name]\[SQL Express Instance Name]; user id=[User Name]; password=[Password]
but I got error message as follow:
Hata Mesaji:
The provider did not return a
ProviderManifestToken string.

I tried using SQLCMD to connect to the server and it works. pls adv. Thanks

BR.

Navigation

[0] Message Index

[#] Next page