Setting Up System For a Restaurant? (Adding up 2nd Terminal)

kadymp · June 20, 2015, 12:17am

I got really confused I am sorry I am pretty new on sambapos and all database types

soonest I change my connection string on 2nd computer I receive error.

I am using sambapos4 should I install SQL EXPRESS 2014 or SQL EXPRESS 2012 on main computer,
do I need to install anything but sambapos4 on the main computer and 2nd computer I am planning to use as 2nd terminal also

can somebody tell me which software I need to install on main computer and on the 2nd computer I am planning to use as 2nd terminal
the tutorial I have seen was on sambapos3 is it same for sambapos4
can someone please give me a little more detailed explanation “how I can add second computer as 2nd terminal on same server”

Thanks very much.

Jesse · June 20, 2015, 2:21am

Look here:

You install SQL Express on ONE machine all other terminals will connect to that server. All other terminals you simply install SambaPOS and then set the connection string to connect to the main server SQL Express instance.

Can you show us the error? Copy and paste the details from the error here. Also read what we said about connection string.

kadymp · June 20, 2015, 7:24pm

I don’t understand what I am doing wrong

I have only install sql express 2014 on main computer and did all the configs

I have deleted all the samba files and sql files on the 2nd computer I still get this message when I am trying to open up for first time, I don’t understand even thoug I have deleted all the files why I still see this error message
@Jesse

kadymp · June 20, 2015, 7:41pm

[General Info]

Application: SambaPOS
Version: 4.1.82
Region: en
DB: SQ
Machine: GREENOLIVE2-PC
User: Green olive 2
Date: 6/20/2015
Time: 7:10 PM

User Explanation:

Green olive 2 said “”

[Exception Info 1]

Top-level Exception
Type: System.Data.ProviderIncompatibleException
Message: An error occurred while getting provider information from the database. This can be caused by Entity Framework using an incorrect connection string. Check the inner exceptions for details and ensure that the connection string is correct.
Source: EntityFramework
Stack Trace: at System.Data.Entity.ModelConfiguration.Utilities.DbProviderServicesExtensions.GetProviderManifestTokenChecked(DbProviderServices providerServices, DbConnection connection)
at System.Data.Entity.ModelConfiguration.Utilities.DbConnectionExtensions.GetProviderInfo(DbConnection connection, DbProviderManifest& providerManifest)
at System.Data.Entity.DbModelBuilder.Build(DbConnection providerConnection)
at System.Data.Entity.Internal.LazyInternalContext.CreateModel(LazyInternalContext internalContext)
at System.Data.Entity.Internal.RetryLazy`2.GetValue(TInput input)
at System.Data.Entity.Internal.LazyInternalContext.InitializeContext()
at System.Data.Entity.Internal.InternalContext.ForceOSpaceLoadingForKnownEntityTypes()
at System.Data.Entity.DbContext.System.Data.Entity.Infrastructure.IObjectContextAdapter.get_ObjectContext()
at Samba.Infrastructure.Data.SqlData.EFWorkspace…ctor(CommonDbContext context)
at Samba.Persistance.Data.WorkspaceFactory.Create()
at Samba.Presentation.Services.Common.DataGeneration.DataCreationService…ctor()
at Samba.Presentation.Bootstrapper.InitializeShell()

Inner Exception 1
Type: System.Data.ProviderIncompatibleException
Message: The provider did not return a ProviderManifestToken string.
Source: System.Data.Entity
Stack Trace: at System.Data.Common.DbProviderServices.GetProviderManifestToken(DbConnection connection)
at System.Data.Entity.ModelConfiguration.Utilities.DbProviderServicesExtensions.GetProviderManifestTokenChecked(DbProviderServices providerServices, DbConnection connection)

Inner Exception 2
Type: System.Data.SqlClient.SqlException
Message: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Source: .Net SqlClient Data Provider
Stack Trace: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, Boolean withFailover) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource1 retry)
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.Open() at System.Data.SqlClient.SqlProviderServices.UsingConnection(SqlConnection sqlConnection, Action1 act)
at System.Data.SqlClient.SqlProviderServices.UsingMasterConnection(SqlConnection sqlConnection, Action`1 act)
at System.Data.SqlClient.SqlProviderServices.GetDbProviderManifestToken(DbConnection connection)
at System.Data.Common.DbProviderServices.GetProviderManifestToken(DbConnection connection)

[Assembly Info]

PresentationFramework, Version=4.0.0.0
System.Xaml, Version=4.0.0.0
Microsoft.Practices.Prism.MefExtensions, Version=4.0.0.0
mscorlib, Version=4.0.0.0
System, Version=4.0.0.0
WindowsBase, Version=4.0.0.0
System.Configuration, Version=4.0.0.0
Samba.Services, Version=1.0.0.0
Samba.Presentation.Services, Version=1.0.0.0
Samba.Presentation.Common, Version=1.0.0.0
Samba.Domain, Version=1.0.0.0
PresentationCore, Version=4.0.0.0
DevExpress.Xpf.Core.v14.1, Version=14.1.6.0
Microsoft.Practices.ServiceLocation, Version=1.0.0.0
Samba.Infrastructure, Version=1.0.0.0
Microsoft.Practices.Prism, Version=4.0.0.0
System.ComponentModel.Composition, Version=4.0.0.0
System.Core, Version=4.0.0.0
Samba.Localization, Version=1.0.0.0
FastButton, Version=1.0.0.0

[System Info]

Operating System
-Microsoft Windows 7 Home Premium
–CodeSet = 1252
–CSDVersion = Service Pack 1
–CurrentTimeZone = -420
–FreePhysicalMemory = 2261936
–OSArchitecture = 64-bit
–OSLanguage = 1033
–ServicePackMajorVersion = 1
–ServicePackMinorVersion = 0
–Version = 6.1.7601

Machine
-GREENOLIVE2-PC
–Manufacturer = Dell Inc.
–Model = OptiPlex GX620
–TotalPhysicalMemory = 3747758080
–UserName = Greenolive2-PC\Green olive 2

Jesse · June 20, 2015, 7:54pm

On the computer that has SQL Express running check for the Windows Service called SQL Browser make sure it is running. If SQL Browser is not running then it will not accept connections from other computers. Ensure the windows firewall for both pc’s is turned off.

kadymp · June 20, 2015, 7:59pm

its says stopped" on thesql server config manager @Jesse

I have double clicked and how do I config SQL Server Browser Properties.?

Jesse · June 20, 2015, 7:59pm

You need it running. If it says stopped your other computers cant connect to it.

Do not use SQL server config manager… use windows… just go to run or search and type services. Start SQL Server Browser make sure its running. Or go to Control Panel > System and Security > Administrative Tools and click on Services

kadymp · June 20, 2015, 8:04pm

it says disabled should I make startup type auto or manuel?

JTRTech · June 20, 2015, 8:07pm

I would say go for auto

kadymp · June 20, 2015, 8:08pm

there are also buttons log on recovery and dependences do I need to make any config on those options?

JTRTech · June 20, 2015, 8:09pm

Dont know about those, I just remember setting that to auto.

Jesse · June 20, 2015, 8:09pm

Auto

No the only thing you need to do is start the service and set it to auto. Usually its started by default you must have changed something in the SQL Install when you installed SQL Express.

kadymp · June 20, 2015, 8:15pm

I have disabled the firewalls and did the config on main about sql browser , Do I need to install sql browser on the second one because i don’t see sql browser on the second computer

JTRTech · June 20, 2015, 8:18pm

No, you dont need any SQL stuff on the client PC

kadymp · June 20, 2015, 8:25pm

still getting connection string error" ;(

I cant even open the sambapos test.sdf

Jesse · June 20, 2015, 8:25pm

you shouldnt be using .sdf files

kadymp · June 20, 2015, 8:27pm

I cant even start the sambapos not even trying to pair but just start open it gives me an eror message I think its finding the old database infos so I am trying to open with test.sdf but its not opening

Jesse · June 20, 2015, 8:27pm

Do not try to use .sdf files if you have it connected to sql.

kadymp · June 20, 2015, 8:29pm

I really don’t know what to do I have deleted and reinstall sambapos like 5 times I cant even open up it starts with connection string error

kadymp · June 20, 2015, 8:30pm

Main computer connected the sql and running but 2nd computer I am trying to connect is not opening sambapos at all