I have ArcGIS Server 10 with SP1 and SP2 on windows server 2008 and ArcSDE (from an edn liscense) installed on top of MS SQL Server 2008.
When I make a spatial db connection in ArcCatalog (direct connect) using DB Auth as user sde, then I change the version to dbo.Default instead of the sde.Default and the connection is in place. When I come back to the connection later and double-click the connection, ArcCatalog doesn't retain the user and password credentials for SQL Server and I am asked with a different looking dialogue (not the normal spatial db connection dialog) to re-enter credentials. Why would ArcCatalog not retain the info?
And how would this affect creating a feature service if at all?
Also I have the arcgissoc user with SQL Server instance login privileges as windows authentication only (not db authentication at the instance level) how would this affect creating a edit-able feature service?