Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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?

Thanks all..!

share|improve this question
    
that sounds like a timeout in sql server. –  Brad Nesom Aug 3 '11 at 4:14
    
webhelp.esri.com/arcgisserver/9.3/dotnet/… I'll be right back with the 10 version. –  Brad Nesom Aug 3 '11 at 14:53
    
Sounding to me to be a Driver version issue, like your machine trying to do the Direct-Connect is not using the right driver. Did you update your SQL drivers recently? –  D.E.Wright Aug 3 '11 at 15:27
    
Why do you change from SDE.Default to dbo.Default? –  Jamie Nov 2 '11 at 3:50
    
Are you checking the box in the Connection Properties dialog to save the Username and Password? –  Timothy Michael Jan 30 '12 at 19:18
add comment

1 Answer 1

link to connection string parameters
Not sure how to get this into arccatalog dialog though.
Users and Roles Overview

share|improve this answer
    
Anyone have a link that shows esri's preferred way to configure users accounts in sql server? –  Justin Aug 3 '11 at 13:29
    
Woohoo... very loaded question... the way ESRI Prof services does this; and much of Tech-Marketing versus BPs goes diffenent paths. help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//… points to a high-level doc, but keep in mind that RDBMS-DBAs often prefer things a little different and you can easily start a blood-fued if you can't have them understand why things need to be a certain way. –  D.E.Wright Sep 2 '11 at 17:55
1  
@Justin, you have to assign privs on feature classes using ArcCatalog. That is the only reliable way. ArcSDE is going to take the most restrictive privs. The only reliable way that I have seen is to drop all privs on the feature class from the db then add them back using ArcCatalog. –  Jamie Nov 2 '11 at 3:49
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.