Install the Microsoft SQL Server Native client on the ArcGIS client machine, and connect to the database from the ArcGIS client.
To use the data stored in SQL Server in services published to ArcGIS Server, you must also register the database with ArcGIS Server.