# Can 2 different user run 2 database on Smabapos at a time **URL:** \ **Category:** V4 Question\ **Created:** [March 2, 2015, 12:58am UTC](https://forum.sambapos.com/t/can-2-different-user-run-2-database-on-smabapos-at-a-time/4436 "2015-03-02T00:58:52Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![madiha](https://forum.sambapos.com/user_avatar/forum.sambapos.com/madiha/32/13950_2.png) [@madiha](https://forum.sambapos.com/u/madiha)\ **Post date:** [March 2, 2015, 12:58am UTC](https://forum.sambapos.com/t/can-2-different-user-run-2-database-on-smabapos-at-a-time/4436/1 "2015-03-02T00:58:52Z")
i have a very strange question i have setup a server with database A and i want user A to use it then can User B access the server with database B using rdp? so basically can user run samba with different database on one machine using rdp connection? ---
**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\ **Post date:** [March 2, 2015, 1:15am UTC](https://forum.sambapos.com/t/can-2-different-user-run-2-database-on-smabapos-at-a-time/4436/2 "2015-03-02T01:15:19Z")
So just to be sure. Your server has 2 databases. A and B. You want user A to use the actual server. but User b connect to the server but access database B? If you are running SQL Express you can have 2 databases at same time yes. I want to ask though why do you have 2 databases? The way you would do this is you would have to allow multiple instances in your sambasettings.txt file Meaning you would run 2 instances of SambaPOS on the server. One connected to Database A one connected to Database B and the second Samba Instance is the one you connect to with rdp. I can not think of a reason why you want 2 databases though? ---
**Author:** ![madiha](https://forum.sambapos.com/user_avatar/forum.sambapos.com/madiha/32/13950_2.png) [@madiha](https://forum.sambapos.com/u/madiha)\ **Post date:** [March 2, 2015, 1:22am UTC](https://forum.sambapos.com/t/can-2-different-user-run-2-database-on-smabapos-at-a-time/4436/3 "2015-03-02T01:22:25Z")
the main purpose is to have independent user based sale report and when they end the work poriod their reports are printed. i know i can use custom reports but currently its having the formatting issue so for Manager i set database A for Cashier set database B using rdp Cashier can access his terminal while Manager is using his terminal correct? i thought i would face problem coz only one instance of samba can run ---
**Author:** ![neko](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/n/7ab992/32.png) [@neko](https://forum.sambapos.com/u/neko)\ **Post date:** [March 2, 2015, 1:23am UTC](https://forum.sambapos.com/t/can-2-different-user-run-2-database-on-smabapos-at-a-time/4436/4 "2015-03-02T01:23:46Z")
why don’t you just use this? > [@Tracking 2 Till Cash and Shifts](http://forum.sambapos.com/t/tracking-2-till-cash-and-shifts/1256): > > I wrote it as an answer to a question [Cash 2 tills seperately](http://forum.sambapos.com/t/cash-2-tills-seperately/1232) but later I decided to move it to a tutorial topic to increase visibility. This tutorial is about tracking 2 till cash accounts separately and consolidating them to a main cash account on shifts. If you need to know a total of “something” it will be a good idea to focus on accounting system. Now I’ll try to implement my idea by using accounting features and add step by step instructions. Please keep in mind I’m just trying to show … ---
**Author:** ![madiha](https://forum.sambapos.com/user_avatar/forum.sambapos.com/madiha/32/13950_2.png) [@madiha](https://forum.sambapos.com/u/madiha)\ **Post date:** [March 2, 2015, 1:28am UTC](https://forum.sambapos.com/t/can-2-different-user-run-2-database-on-smabapos-at-a-time/4436/5 "2015-03-02T01:28:01Z")
this wont be suitable because i want the item sale report to be user based also ---
**Author:** ![madiha](https://forum.sambapos.com/user_avatar/forum.sambapos.com/madiha/32/13950_2.png) [@madiha](https://forum.sambapos.com/u/madiha)\ **Post date:** [March 2, 2015, 1:31am UTC](https://forum.sambapos.com/t/can-2-different-user-run-2-database-on-smabapos-at-a-time/4436/6 "2015-03-02T01:31:20Z")
> [@Jesse](#): > > I can not think of a reason why you want 2 databases though? sometimes you just have to follow instructions while knowing a better solution does exists 🙂 ---
**Author:** ![madiha](https://forum.sambapos.com/user_avatar/forum.sambapos.com/madiha/32/13950_2.png) [@madiha](https://forum.sambapos.com/u/madiha)\ **Post date:** [March 2, 2015, 1:32am UTC](https://forum.sambapos.com/t/can-2-different-user-run-2-database-on-smabapos-at-a-time/4436/7 "2015-03-02T01:32:10Z")
> [@Jesse](#): > > allow multiple instances in your sambasettings.txt file how will i achieve to do that? ---
**Author:** ![neko](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/n/7ab992/32.png) [@neko](https://forum.sambapos.com/u/neko)\ **Post date:** [March 2, 2015, 1:47am UTC](https://forum.sambapos.com/t/can-2-different-user-run-2-database-on-smabapos-at-a-time/4436/8 "2015-03-02T01:47:03Z")
do you mean that each ticket need to be assigned to a user? do you want to track the sales or the cash? ---
**Author:** ![madiha](https://forum.sambapos.com/user_avatar/forum.sambapos.com/madiha/32/13950_2.png) [@madiha](https://forum.sambapos.com/u/madiha)\ **Post date:** [March 2, 2015, 1:47am UTC](https://forum.sambapos.com/t/can-2-different-user-run-2-database-on-smabapos-at-a-time/4436/9 "2015-03-02T01:47:35Z")
need to track both cash and sale ---
**Author:** ![neko](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/n/7ab992/32.png) [@neko](https://forum.sambapos.com/u/neko)\ **Post date:** [March 2, 2015, 1:49am UTC](https://forum.sambapos.com/t/can-2-different-user-run-2-database-on-smabapos-at-a-time/4436/10 "2015-03-02T01:49:07Z")
would be best if you can give a bit more detail of your process? who and when? what to track at the end of the day ---
**Author:** ![madiha](https://forum.sambapos.com/user_avatar/forum.sambapos.com/madiha/32/13950_2.png) [@madiha](https://forum.sambapos.com/u/madiha)\ **Post date:** [March 2, 2015, 1:50am UTC](https://forum.sambapos.com/t/can-2-different-user-run-2-database-on-smabapos-at-a-time/4436/11 "2015-03-02T01:50:19Z")
got a link to di it!! > [@Some requests for better use on the touch. Use Sambapos on touch devices. Use Sambapos in RDP](http://forum.sambapos.com/t/some-requests-for-better-use-on-the-touch-use-sambapos-on-touch-devices-use-sambapos-in-rdp/2199/2): > > When you copy SambaSettings.txt file from App Path to User Path SambaPOS Local Settings becomes windows user account based. So you can assign different terminals per windows user. This is the most important thing to know when you need more control on RDP configurations while running RDP devices and also use SambaPOS as a regular terminal on same computer. You can read more about it at the end of this tutorial. When you assign a terminal for each windows user you can configure se… > [@Step by step on how to Configure multiple concurrent RDP clients to run SambaPOS (IPHONE ,IPAD, Galaxy tablet)](http://forum.sambapos.com/t/step-by-step-on-how-to-configure-multiple-concurrent-rdp-clients-to-run-sambapos-iphone-ipad-galaxy-tablet/769): > > Here’s a step by step guide on how to run multiple concurrent RDP sessions. My Test system configuration: Laptop running Windows 7 Enterprise (Windows Pro is recommended) - Main System Other Devices (clients): Iphone 3 Ipad Galaxy Tab 3 Required Software Patch: 2X Client for Desktops, Mobile Devices - [http://www.2x.com/rdp-client/](http://www.2x.com/rdp-client/) Patch/crack Required to enable-concurrent-multiple-RDP-sessions: Windows 7 patch: \ Windows 8/8.1 Patch: \ **Author:** ![madiha](https://forum.sambapos.com/user_avatar/forum.sambapos.com/madiha/32/13950_2.png) [@madiha](https://forum.sambapos.com/u/madiha)\ **Post date:** [March 2, 2015, 1:51am UTC](https://forum.sambapos.com/t/can-2-different-user-run-2-database-on-smabapos-at-a-time/4436/12 "2015-03-02T01:51:22Z") > [@neko](#): > > would be best if you can give a bit more detail of your process? who and when? what to track at the end of the d i have here its above > [@Can 2 different user run 2 database on Smabapos at a time](http://forum.sambapos.com/t/can-2-different-user-run-2-database-on-smabapos-at-a-time/4436/3): > > the main purpose is to have independent user based sale report and when they end the work poriod their reports are printed. i know i can use custom reports but currently its having the formatting issue so for Manager i set database A for Cashier set database B using rdp Cashier can access his terminal while Manager is using his terminal correct? i thought i would face problem coz only one instance of samba can run ---
**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\ **Post date:** [March 2, 2015, 2:09am UTC](https://forum.sambapos.com/t/can-2-different-user-run-2-database-on-smabapos-at-a-time/4436/13 "2015-03-02T02:09:34Z")
How are you going to reconcile the two databases? Manually? Are you tracking inventory? You can do this yes but you may want to explore other options once you get that working. What you are doing is not efficient and there is plenty of support to do what you want from within SambaPOS. But I understand if you feel this is your only route atm due to your issue. However it would be better if we could work out your issue though wouldnt it? So basically what your doing is not user tracking your tracking terminals. What if manager signs into users computer to do sales? Or what if user signs into computer manager is using and does sales… that messes up your entire process. It just seems like to me your going to cause yourself more issues than just formatting issue if you go this route. Obviously you can do what you feel you need too but why not focus on fixing the formatting issue? ---
**Author:** ![madiha](https://forum.sambapos.com/user_avatar/forum.sambapos.com/madiha/32/13950_2.png) [@madiha](https://forum.sambapos.com/u/madiha)\ **Post date:** [March 2, 2015, 2:48am UTC](https://forum.sambapos.com/t/can-2-different-user-run-2-database-on-smabapos-at-a-time/4436/14 "2015-03-02T02:48:39Z")
i wont be reconiling, wont be tracking inventory and yes you are right it will be tracking terminal. the purpose to keep track of the sales on terminals. ---
**Author:** ![madiha](https://forum.sambapos.com/user_avatar/forum.sambapos.com/madiha/32/13950_2.png) [@madiha](https://forum.sambapos.com/u/madiha)\ **Post date:** [March 2, 2015, 3:07am UTC](https://forum.sambapos.com/t/can-2-different-user-run-2-database-on-smabapos-at-a-time/4436/15 "2015-03-02T03:07:28Z")
@Jesse how can i assign database to terminal ---
**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\ **Post date:** [March 2, 2015, 3:10am UTC](https://forum.sambapos.com/t/can-2-different-user-run-2-database-on-smabapos-at-a-time/4436/16 "2015-03-02T03:10:44Z")
with connection string. ---
**Author:** ![madiha](https://forum.sambapos.com/user_avatar/forum.sambapos.com/madiha/32/13950_2.png) [@madiha](https://forum.sambapos.com/u/madiha)\ **Post date:** [March 2, 2015, 3:38am UTC](https://forum.sambapos.com/t/can-2-different-user-run-2-database-on-smabapos-at-a-time/4436/17 "2015-03-02T03:38:34Z")
@Jesse [quote=“Jesse, post:16, topic:4436, full:true”] with connection string. [/quote] recceving this error when i am setting terminal ith different database > [Exception Info 1] > Top-level Exception > Type: System.Data.SqlClient.SqlException > Message: Invalid object name ‘VersionInfo’. > Source: .Net SqlClient Data Provider > Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) > at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) > at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) > at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() > at System.Data.SqlClient.SqlDataReader.get\_MetaData() > at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) > at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) > at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader() at System.Data.Objects.ObjectContext.ExecuteStoreQueryInternal[TElement](String commandText, String entitySetName, MergeOption mergeOption, Object[] parameters) at Samba.Persistance.Data.Initializer.InitializeDatabase(DataContext context) at System.Data.Entity.Database.<>c__DisplayClass2`1.b\_\_0(DbContext c) > at System.Data.Entity.Internal.InternalContext.\<\>c\_\_DisplayClass8.b\_\_6() > at System.Data.Entity.Internal.InternalContext.PerformInitializationAction(Action action) > at System.Data.Entity.Internal.InternalContext.PerformDatabaseInitialization() > at System.Data.Entity.Internal.LazyInternalContext.b\_\_4(InternalContext c) > at System.Data.Entity.Internal.RetryAction`1.PerformAction(TInput input) at System.Data.Entity.Internal.LazyInternalContext.InitializeDatabaseAction(Action`1 action) > at System.Data.Entity.Internal.LazyInternalContext.InitializeDatabase() > 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.Modules.SettingsModule.SettingsViewModel.ForceConnectionUpdate() > at Samba.Modules.SettingsModule.SettingsView.ButtonInfo\_Click(Object sender, RoutedEventArgs e) > at DevExpress.Xpf.Editors.ButtonInfo.RaiseClickEvent(Object sender, RoutedEventArgs e) > at DevExpress.Xpf.Editors.ButtonInfo.OnButtonClick(Object sender, RoutedEventArgs e) > at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs) > at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised) > at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args) > at System.Windows.UIElement.RaiseEvent(RoutedEventArgs e) > at System.Windows.Controls.Primitives.ButtonBase.OnClick() > at System.Windows.Controls.Button.OnClick() > at System.Windows.Controls.Primitives.ButtonBase.OnMouseLeftButtonDown(MouseButtonEventArgs e) > at System.Windows.UIElement.OnMouseLeftButtonDownThunk(Object sender, MouseButtonEventArgs e) > at System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget) > at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target) > at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs) > at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised) > at System.Windows.UIElement.ReRaiseEventAs(DependencyObject sender, RoutedEventArgs args, RoutedEvent newEvent) > at System.Windows.UIElement.OnMouseDownThunk(Object sender, MouseButtonEventArgs e) > at System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget) > at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target) > at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs) > at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised) > at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args) > at System.Windows.UIElement.RaiseTrustedEvent(RoutedEventArgs args) > at System.Windows.UIElement.RaiseEvent(RoutedEventArgs args, Boolean trusted) > at System.Windows.Input.InputManager.ProcessStagingArea() > at System.Windows.Input.InputManager.ProcessInput(InputEventArgs input) > at System.Windows.Input.InputProviderSite.ReportInput(InputReport inputReport) > at System.Windows.Interop.HwndMouseInputProvider.ReportInput(IntPtr hwnd, InputMode mode, Int32 timestamp, RawMouseActions actions, Int32 x, Int32 y, Int32 wheel) > at System.Windows.Interop.HwndMouseInputProvider.FilterMessage(IntPtr hwnd, WindowMessage msg, IntPtr wParam, IntPtr lParam, Boolean& handled) > at System.Windows.Interop.HwndSource.InputFilterMessage(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled) > at MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled) > at MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o) > at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs) > at MS.Internal.Threading.ExceptionFilterHelper.TryCatchWhen(Object source, Delegate method, Object args, Int32 numArgs, Delegate catchHandler) > at System.Windows.Threading.Dispatcher.LegacyInvokeImpl(DispatcherPriority priority, TimeSpan timeout, Delegate method, Object args, Int32 numArgs) > at MS.Win32.HwndSubclass.SubclassWndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam) > at MS.Win32.UnsafeNativeMethods.DispatchMessage(MSG& msg) > at System.Windows.Threading.Dispatcher.PushFrameImpl(DispatcherFrame frame) > at System.Windows.Threading.Dispatcher.PushFrame(DispatcherFrame frame) > at System.Windows.Threading.Dispatcher.Run() > at System.Windows.Application.RunDispatcher(Object ignore) > at System.Windows.Application.RunInternal(Window window) > at System.Windows.Application.Run(Window window) > at Samba.Presentation.App.Main() * * * > [Assembly Info] > Samba.Services, Version=1.0.0.0 > mscorlib, Version=4.0.0.0 > System, Version=4.0.0.0 > Microsoft.Practices.Prism, Version=4.0.0.0 > WindowsBase, Version=4.0.0.0 > Samba.Infrastructure, Version=1.0.0.0 > Samba.Infrastructure.Data, Version=1.0.0.0 > PresentationFramework, Version=4.0.0.0 > System.Xaml, Version=4.0.0.0 > Samba.Presentation.Services, Version=1.0.0.0 > FluentValidation, Version=3.4.0.0 > Samba.Domain, Version=1.0.0.0 > DevExpress.Xpf.Grid.v14.1, Version=14.1.6.0 > DevExpress.Xpf.Grid.v14.1.Core, Version=14.1.6.0 > PresentationCore, Version=4.0.0.0 > Stateless, Version=1.0.0.0 > System.Core, Version=4.0.0.0 > System.Drawing, Version=4.0.0.0 > DevExpress.Xpf.Core.v14.1, Version=14.1.6.0 > EntityFramework, Version=4.4.0.0 > System.Windows.Forms, Version=4.0.0.0 > System.ComponentModel.Composition, Version=4.0.0.0 > Samba.Localization, Version=1.0.0.0 > Microsoft.CSharp, Version=4.0.0.0 > Microsoft.Practices.ServiceLocation, Version=1.0.0.0 > Samba.Persistance, Version=1.0.0.0 > Microsoft.Practices.Prism.MefExtensions, Version=4.0.0.0 > PropertyTools, Version=2012.4.14.1 ---
**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\ **Post date:** [March 2, 2015, 3:44am UTC](https://forum.sambapos.com/t/can-2-different-user-run-2-database-on-smabapos-at-a-time/4436/18 "2015-03-02T03:44:04Z")
Be sure they are same version etc. You connect to any database the same using connection string. How did you make the 2nd database? Hint connection string should be same only difference is database name. You are running 1 version of sql express right? It should house both databases. ---
**Author:** ![madiha](https://forum.sambapos.com/user_avatar/forum.sambapos.com/madiha/32/13950_2.png) [@madiha](https://forum.sambapos.com/u/madiha)\ **Post date:** [March 2, 2015, 3:48am UTC](https://forum.sambapos.com/t/can-2-different-user-run-2-database-on-smabapos-at-a-time/4436/19 "2015-03-02T03:48:05Z")
well i backup the db 1 and create a new db2. then restore db1 on db2 ---
**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\ **Post date:** [March 2, 2015, 3:48am UTC](https://forum.sambapos.com/t/can-2-different-user-run-2-database-on-smabapos-at-a-time/4436/20 "2015-03-02T03:48:56Z")
And how did you do this? With mssms or backup tool? [Next page](https://forum.sambapos.com/t/can-2-different-user-run-2-database-on-smabapos-at-a-time/4436.md?page=2)