Issue: The Connector for Microsoft SQL Server cannot alter a table in a Data replication target database to add new columns from the source system when using Windows authentication with the fully qualified domain name (FQDN) format “Username@domain.com”.

Error: The following error has occurred in the SQL Connector: To accomplish this action, set property RowGuidCol.: Error in call CreateOrUpdateObjectForReplication Exception Type : InvalidExecuteMethodException Message : The following error has occurred in the SQL Connector: To accomplish this action, set property RowGuidCol. StackTrace : at Scribe.Adapter.Sql.SqlAdapter.ExecuteMethod(MethodInput input) at Scribe.Core.Access.Connection.ExecuteMethod(MethodInput input) at Scribe.Core.Processor.ProcessSupport.ExecuteMethod(Guid processId, Guid processDefinitionConnectionId, MethodInput input)

 

• Ensure that the Microsoft SQL Server account you are connecting with via the Microsoft SQL Server connector in TIBCO Cloud Integration - Connect (Scribe), has the necessary permissions for Create, Read, Update, and Delete operation and authenticate using either "Windows authentication with the format “domain\Username” or "SQL authentication".
• In Microsoft SQL Server, ensure that the Server Role for the user you are connecting with via the Microsoft SQL Server connector is set to 'sysadmin' and the User mapping is 'dbo'.
• Please note that this resolution was validated against Microsoft SQL Server on-premise and applies only to the versions below: 

- Microsoft SQL Server 2017: Enterprise, Standard, and Express
- Microsoft SQL Server 2016: Enterprise, Standard, and Express
- Microsoft SQL Server 2014: Enterprise, Standard, and Express
- Microsoft SQL Server 2012: Enterprise, Standard, and Express
- Microsoft SQL Server 2008 R2: Enterprise and Standard
- Microsoft SQL Server 2008: Enterprise and Standard

**Note: See your Database Administrator for more information about permission/configuration settings in Microsoft SQL Server**