When running Point of Sale I get the following error:
Could not remove the required rms groups on server 'SB': A Sql Error occured
Ive spent hours searching on google and trying to fix this with no success. Is there anyone in the group that knows a possible answer to this one?
Noone has any idea? I have found this error nowhere on the net. Everything has been un installed and reinstalled at least 5 times. No errors happed except it will nto run and gives the usual non helping error.
HERE IS WHAT IS IN EVENT VIEWER WHEN SETTING UP A INCLUDED DB: Source: Microsoft.Rms.UI.Manager.Process.Controllers.CreateDatabaseWizardController.CreateDatabase Process ID: 2748 Could not create database test site. Microsoft.Rms.BaseServices.Core.DatabaseManagement.LoadSampleDataException: Failed to create the sample database
FourthCoffee. ---> Microsoft.Rms.BaseServices.Core.DatabaseManagement.SqlScriptException: Unable to execute TSQL command: A
Sql Exception occurred: CommandText = SET IDENTITY_INSERT [Batch] ON Insert INTO [Batch] ( [CustomerDepositMade],
[CustomerDepositRedeemed], [LastUpdated], [StoreID], [BatchNumber], [Status], [RegisterID], [OpeningTime], [ClosingTime], [OpeningTotal], [ClosingTotal], [Sales], [Returns], [Tax], [SalesPlusTax], [Commission], [PaidOut], [Dropped], [PaidOnAccount], [PaidToAccount], [CustomerCount], [NoSalesCount], [AbortedTransCount], [TotalTendered], [TotalChange], [Discounts], [CostOfGoods], [LayawayPaid], [LayawayClosed], [Shipping], [TenderRoundingError], [DebitSurcharge], [CashBackSurcharge], [Voids], [VoidCount], [GiftCardsSold], [GiftCardsSoldCount]) VALUES (0.0000,0.0000,'1/14/2006 6:32:39PM',0,1,7,1,'1/11/2006 3:53:10 PM','1/14/2006 6:32:38
PM',100.0000,227.6800,117.9700,0.0000,9.7100,127.6800,0.0000,0.0000,0.0000,0.0000,0.0000,15,0,0,205.2500,-77.5700,0.0000,51.2
000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0,0.0000,0 ) SET IDENTITY_INSERT [Batch] OFF --->System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_Batch'. Cannot insert duplicate key in object
'dbo.Batch'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream,
BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Rms.BaseServices.Core.DatabaseManagement.SqlDbStep.RunSqlScript(StreamReader reader, String dataPath) --- End of inner exception stack trace --- at Microsoft.Rms.BaseServices.Core.DatabaseManagement.SqlDbStep.RunSqlScript(StreamReader reader, String dataPath) at Microsoft.Rms.BaseServices.Core.DatabaseManagement.SqlStepCreateSampleData.Execute() --- End of inner exception stack trace --- at Microsoft.Rms.BaseServices.Core.DatabaseManagement.SqlStepCreateSampleData.Execute() at Microsoft.Rms.BaseServices.Core.DatabaseManagement.SqlDbManager.CreateSampleDatabase(SqlConnection cn, String
databaseName, String applicationPath, DatabaseType dbType, String sampleDbFolder, IntPtr serverAdminToken) at Microsoft.Rms.UI.Manager.Process.Controllers.CreateDatabaseWizardController.CreateDatabase()Stack trace: at
Microsoft.Rms.BaseServices.Core.DatabaseManagement.SqlStepCreateSampleData.Execute() at Microsoft.Rms.BaseServices.Core.DatabaseManagement.SqlDbManager.CreateSampleDatabase(SqlConnection cn, String
databaseName, String applicationPath, DatabaseType dbType, String sampleDbFolder, IntPtr serverAdminToken) at Microsoft.Rms.UI.Manager.Process.Controllers.CreateDatabaseWizardController.CreateDatabase()
Source: Microsoft.Rms.UI.Manager.Process.Controllers.CreateDatabaseWizardController.CreateDatabase Process ID: 2748 Could not create database test site. Microsoft.Rms.BaseServices.Core.DatabaseManagement.CreateDatabaseException: Failed to create the windows users/groups or add
the sql logins. ---> Microsoft.Rms.BaseServices.Core.DatabaseManagement.CreateRmsWindowsAndSqlGroupsException: Could not
remove the required rms groups on server 'SB': A Sql Error occured. ---> System.Data.SqlClient.SqlException: Windows NT user
or group 'SB\R#_Users' not found. Check the name again. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream,
BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) 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) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean
returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Rms.BaseServices.Core.DatabaseManagement.WindowsAuthenticationHelper.GrantSqlAccess(SqlConnection connection,
ApplicationMode mode, String loginName) at Microsoft.Rms.BaseServices.Core.DatabaseManagement.WindowsAuthenticationHelper.CreateRmsWindowsAndSqlGroups(String
server, SqlConnection connection, ApplicationMode mode) --- End of inner exception stack trace --- at Microsoft.Rms.BaseServices.Core.DatabaseManagement.WindowsAuthenticationHelper.CreateRmsWindowsAndSqlGroups(String
server, SqlConnection connection, ApplicationMode mode) at
Microsoft.Rms.BaseServices.Core.DatabaseManagement.WindowsAuthenticationHelper.CreateServerRmsWindowsAndSqlGroups(SqlConnecti
on connection, ApplicationMode mode) at Microsoft.Rms.BaseServices.Core.DatabaseManagement.SqlDbManager.CreateSampleDatabase(SqlConnection cn, String
databaseName, String applicationPath, DatabaseType dbType, String sampleDbFolder, IntPtr serverAdminToken) --- End of inner exception stack trace --- at Microsoft.Rms.BaseServices.Core.DatabaseManagement.SqlDbManager.CreateSampleDatabase(SqlConnection cn, String
databaseName, String applicationPath, DatabaseType dbType, String sampleDbFolder, IntPtr serverAdminToken) at Microsoft.Rms.UI.Manager.Process.Controllers.CreateDatabaseWizardController.CreateDatabase()Stack trace: at
Microsoft.Rms.BaseServices.Core.DatabaseManagement.SqlDbManager.CreateSampleDatabase(SqlConnection cn, String databaseName,
String applicationPath, DatabaseType dbType, String sampleDbFolder, IntPtr serverAdminToken) at Microsoft.Rms.UI.Manager.Process.Controllers.CreateDatabaseWizardController.CreateDatabase()
AND THIS HAPPENS ALSO AT TIMES:
"Mike" wrote:
remove the required rms groups on server 'SB': A Sql Error occured. ---> System.Data.SqlClient.SqlException: Windows NT user
or group 'SB\R#_Users' not found. Check the name again. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream,
BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) 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) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean
returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Rms.BaseServices.Core.DatabaseManagement.WindowsAuthenticationHelper.GrantSqlAccess(SqlConnection connection,
ApplicationMode mode, String loginName) at Microsoft.Rms.BaseServices.Core.DatabaseManagement.WindowsAuthenticationHelper.CreateRmsWindowsAndSqlGroups(String
server, SqlConnection connection, ApplicationMode mode) --- End of inner exception stack trace --- at Microsoft.Rms.BaseServices.Core.DatabaseManagement.WindowsAuthenticationHelper.CreateRmsWindowsAndSqlGroups(String
server, SqlConnection connection, ApplicationMode mode) at
Microsoft.Rms.BaseServices.Core.DatabaseManagement.WindowsAuthenticationHelper.CreateServerRmsWindowsAndSqlGroups(SqlConnecti
on connection, ApplicationMode mode) at Microsoft.Rms.BaseServices.Core.DatabaseManagement.SqlDbManager.CreateSampleDatabase(SqlConnection cn, String
databaseName, String applicationPath, DatabaseType dbType, String sampleDbFolder, IntPtr serverAdminToken) --- End of inner exception stack trace --- at Microsoft.Rms.BaseServices.Core.DatabaseManagement.SqlDbManager.CreateSampleDatabase(SqlConnection cn, String
databaseName, String applicationPath, DatabaseType dbType, String sampleDbFolder, IntPtr serverAdminToken) at Microsoft.Rms.UI.Manager.Process.Controllers.CreateDatabaseWizardController.CreateDatabase()Stack trace: at
Microsoft.Rms.BaseServices.Core.DatabaseManagement.SqlDbManager.CreateSampleDatabase(SqlConnection cn, String databaseName,
String applicationPath, DatabaseType dbType, String sampleDbFolder, IntPtr serverAdminToken) at Microsoft.Rms.UI.Manager.Process.Controllers.CreateDatabaseWizardController.CreateDatabase()
AND THIS HAPPENS ALSO AT TIMES:
"Mike" wrote:
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.