When a data replication app runs and records are written to the target SQL Server database, the app will use the settings for the SQL Server user selected in the TIBCO Scribe Online Connector For Microsoft SQL Server connection settings. Tables are created with the Default Schema prefix defined under the SQL user's properties in SQL Server. Depending on what the default schema value is set to, tables being created by the data replication app may appear as domain\serviceaccount.D365entityname or dbo.D365entityname. 



The default schema may not be what is desired and there will be a tables created by the data replication job that have an unwanted schema. 

• Open Microsoft SQL Server Management Studio and connect to the database.
• Expand the SQL Server Security folder.
• Expand Logins and find the user being used in the connection.
• Right click the user and select Properties.

• Select User Mappings.
• Find the database that you are working with and make changes to the Default Schema field as needed. 
• Click OK to save changes. 

• Reset the connection metadata for the Microsoft SQL Server connection so new tables are created with the new desired schema prefix. 

• in Object Explorer, right-click on the table and then click Design.

• Press F4 to open the Properties window. In the Schema box, select a new schema.

• Close the properties window and the design window and save changes.

• Refresh the database to verify the new schema on the table.