Hi Russell,
Yes, it's possible to access the view you created in Management Studio and publish it to ArcGIS for Server. Are you connected to the database as the same user that created the view in SQL Server Management Studio?
Also what version are you using? Ex:
ArcSDE 10.2.2
SQL Server 2008