You must change the configuration of SQL Server Management Studio (SSMS). SSMS defines defaults for the connection parameters it uses when making a connection with SQL Server.
In the Tools menu, click Options.
In the left-hand pane, open Query Execution, open SQL Server and then click Advanced. In the right-hand pane, check the box of the SET CONCAT_NULL_YIELDS_NULL field.
In the left-hand pane, click ANSI. In the right-hand pane, check the boxes of the fields SET QUOTED_IDENTIFIER, SET ANSI_PADDING, and SET ANSI_NULLS. Then click OK.