You’re offline. This is a read only version of the page.
639
I am attempting to change the authentication type to Windows this morning in SL2011 FP1 on Windows Server 2012 running SQL 2012. I received "Process completed unsuccessfully" from DB Maintenance. I checked the dbbuild.log and I see in the ErrorText: ExecuteNonQuery failed for database 'SystemDB'. I successfully changed the databases in their test environment and am a little stumped. They only difference between their production and test environments is sql replication is enabled in their production environment.
I checked that the windows login was associated with the SYSADMIN account correctly, was able to create an ODBC, verified the user in SQL - Security - Login was setup correctly with access to all SL databases and public was checked in the lower section.
I tried to change it back to SQL Authentication and received "Process completed unsuccessfully" again however, the users are still able to login and process.
Later this morning I stopped the replication job's and tried it again with the same results.
Here are the results from the log file:
Start Time: 2:18:52 AM
Database Name: System
Error Code: 0
Error Text: ExecuteNonQuery failed for Database 'System'.
Statement: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[getAuthenticationType]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)drop procedure [dbo].[getAuthenticationType]
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
Create Proc getAuthenticationType as
select 'Windows'
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
Database Name: System
Error Code: 0
Error Text: ExecuteNonQuery failed for Database 'System'.
Statement: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[getVersion]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)drop procedure [dbo].[getVersion]
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
Create Proc getVersion as
select '8.10.30917 '
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
Database Name: System
Error Code: 0
Error Text: ExecuteNonQuery failed for Database 'System'.
Statement: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[getSecurityType]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)drop procedure [dbo].[getSecurityType]
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
Create Proc getSecurityType as
select '2'
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
Database Name: SUPPLYDB
Error Code: -2146232060
Error Text: Cannot drop the view 'vs_AcctSub' because it is being used for replication.
Statement: IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vs_AcctSub]'))
drop view [vs_AcctSub]
GO
IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_AcctSub]'))
drop view [vw_AcctSub]
GO
CREATE VIEW [dbo].[vw_acctsub] AS SELECT * FROM System..acctsub
GO
End Time: 2:21:13 AM
Start Time: 3:09:05 AM
Database Name: System
Error Code: 0
Error Text: ExecuteNonQuery failed for Database 'System'.
Statement: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[getAuthenticationType]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)drop procedure [dbo].[getAuthenticationType]
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
Create Proc getAuthenticationType as
select 'SQL'
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
Database Name: System
Error Code: 0
Error Text: ExecuteNonQuery failed for Database 'System'.
Statement: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[getVersion]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)drop procedure [dbo].[getVersion]
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
Create Proc getVersion as
select '8.10.30917 '
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
Database Name: System
Error Code: 0
Error Text: ExecuteNonQuery failed for Database 'System'.
Statement: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[getSecurityType]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)drop procedure [dbo].[getSecurityType]
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
Create Proc getSecurityType as
select '2'
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
End Time: 3:09:42 AM
Any help is appreciated.
Cherie
*This post is locked for comments
I have the same question (0)
FYI - Removed the replication jobs and the process ran just fine.
Cherie
Share
Report
All responses (
Answers (
