Could not remove the required rms groups on server 'SB': A Sql Err

M

Mike 19 years ago

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?

Vote

M

Mike 19 years ago

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:39

PM',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:

Vote

C

CptSoft 19 years ago