Problem for connecting client computer to server database?

[saedawke]

i setup the server successfully with windows Pro 32 bit, as i fallow the guide from SambaPOS club, Server installation was successfully completed, also i started the client computer i installed windows 7 pro 32 same as previous one, i disabled firewall and the like and installed .NET framework plus sambaPOS then, i try to connect the remote database by goint to local settings. please look below shot.

Server works well and also has green connection status at left side down corner.

any help please

[Jesse]

So your SQL Express instance is SAMBAPOS3? What version of SQL Express?

EDIT Obviously it is since its connected on main terminal… So do you have TCP/IP enabled for the SQL Server also is SQL Server Browser service running? Did you check to make sure your SQL Server is accepting outside connections?

SQL Express trough network

The Server name and Instance shows up in MSSMS when you connect to your database it looks like this. [image] So as you can see my Connection String would look like this: Data Source=MANCOW2\SQLEXPRESS; Database=DairyCreme I did not include Password or User Id because I am using windows authentication. However if your using mixed mode you can include those. You need to ensure a few things are working first. 1. in MSSMS right click your server and choose properties then go to Connections a…

[saedawke]

Yes of course;
MSSQL Express 2012, and instance is SAMBAPOS3

[Jesse]

Look at the steps i provided at bottom of my post above.

PS. While your at it you might as well upgrade to SQL Express 2014 its the current version and 2016 will be released later this year.

[saedawke]

ok; browser service is not running let me check it other steps thank you very much

[saedawke]

[Jesse]

THe SQL Server browser is the main one you need running.

[saedawke]

Yes; Great; connected successfully after starting sql browser;
Dear Kendash your support and help it outstanding.
thank your very much;
appreciated your volunteer.