If you author the map to use windows authentication, that will carry through to the service creation. As long as the account running ArcGIS Server has access to the SQL Server instance/data the service will render. You will need to register the OS Authentication to the database as a registered database in ArcGIS Server.
Adam Z