When creating a geodatabase by connecting to a MS SQL Server database, does a native client need to exist on the client machine if SSMS and/or SQL Server itself does not reside there?
Yes, you need to ensure that SQL Server native client is available on the client machine. We use this to connect to the database instance to create your geodatabase.