2

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?

5
  • that sounds like a timeout in sql server.
    – Brad Nesom
    Aug 3, 2011 at 4:14
  • webhelp.esri.com/arcgisserver/9.3/dotnet/… I'll be right back with the 10 version.
    – Brad Nesom
    Aug 3, 2011 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, 2011 at 15:27
  • Why do you change from SDE.Default to dbo.Default?
    – Jamie
    Nov 2, 2011 at 3:50
  • Are you checking the box in the Connection Properties dialog to save the Username and Password? Jan 30, 2012 at 19:18

1 Answer 1

2

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

3
  • Anyone have a link that shows esri's preferred way to configure users accounts in sql server?
    – Justin
    Aug 3, 2011 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, 2011 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, 2011 at 3:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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