Latest Contributions by EoinRyan

Everything is direct connect User has data reader on the database and server roll is public We gave him permission of "grant" using the change privilege tools on the feature class within the feature dataset owner scheme with domain\username Thanks Ken Post a screenshot of the User Mapping under the SQL Server login properties. and a screenshot of your ArcCatalog spatial connection properties. ... View more

Hello, I'm running Arcserver SDE and SQL server 2008 R2 standard. I have my databases setup and can connect using "sde", "sa" and myself using operating system authentication. Of course all three are owners of the databases. I go to set up another user just like I did with myself but as a database reader not owner and can't connect and get the error "Failed to connect to the specified server operation failed. But, when I change the new user to database owner he can connect just fine. Also, when we try to connect the user as a database reader we can see under the SQL server Logs we can see "Login succeeded for user domain\user Connection made using Windows Authentication" But, we get the error "Failed to connect to the specified server operation failed" in the spatial database connection window "test connection" Things I have tried consist of granting the users privileges using the Change Privieges tool and under the verision manger added the user which not sure if this even matters at the station cause were just try to get connection to the SDE/geodatabase Any help would be great just to get pasted the connect error to the database Thanks Ken Hi Ken, Test if the OS user can log using MS Management Studio. The steps to add windows authenticated logins are here: Adding Windows-authenticated logins or groups to a SQL Server database ... View more

Vince, We are on windows server 2008 SP2 and SQLserver 2008 sp2 How do you get to the service startup utility? Thanks Quinn Hi Quinn, The easiest way to check the SDE login would be to open SQL Management Studio or Arccatalog and try to log into your database using the SDE credentials you have. If neither work, log into the SQL Management Studio as a sysadmin user and reset the SDE password. If you're still using application connect (e.g. a Windows ArcSDE service), delete it, and recreate with the new SDE password. You can use the ArcSDE postinstall (choose custom) to create the new service. ... View more

yes, several times What OS are you using? Have you checked the log files (e.g. windows logs and ArcGIS Server logs) for any errors? If you're using IIS make sure the app pools are configured correctly. ... View more

Hello after the SP1 update for the ArcGis Server 10.0 Java i can't reach the rest/services anymore. everytime i get a 404 not avaliable. the manager console is working and i can add new services. Also a connection from ArcMap via Catalog is not possible. I also switched the firewall off. All Windows Services are running. Hello, Have you re-ran the post installs after the upgrade? ... View more

HI Eoin I can't get past create spatial database window with a new database name keeps given me natuve errors. Ken Hi ken, Okay some more questions..... Are you using a SQL sysadmin user to connect at the "user information" stage of the post install? Check this in SQL management Studio Have you changed your SDE password to be a strong password? Try checking the setup log:  SDEHOME\etc\sde_setup.log ... View more

Yes I got through the create spatial database window and all the way through to the repository setup but this is not what I expected. I thought I was creating an addition GDB with a totally different name. But it just allowing me to update my existing GDB. I put a new name in the databse name/repository setup window and it unsuccessfully. So, can I make another SDE/GDB? I have it created up SDE scheme as all the write-up state to do. So far I have SDE/GDB up and running and being directly connected to it. I just can't get another SDE/GDB going. The instructions are very miniumial when it comes to creating an additional SDE/GDB. Any thoughts? Thanks Ken Hi Ken, The process should be pretty much the same for any additional databases. You need to specify a new name for the database in the "create spatial database" stage. Does this complete successfully? After this, the post install will setup the spatial repository within the newly created database. Next stage is authorize. all these stages must complete successfully. The last stage "create ArcSDE service" is optional and only used for application connect. You dont need this if you're using direct connect. If creating a service, remember to use a different port. i.e if you've used the default 5151 for your first database, use 5152 for the second. ... View more

Hi Eoin, I m new at this SDE/SQL stuff and learning as I go. I get my errors at the second window when I go to create Spatial database. When I say make a new folder I mean in the Create in folder option I created a new folder to see if that would fix it. It didn't. I think my problem is in the strong password that I didn't create when I did the install. Plus I can't log in under the 'sa' account cause I don't know the password either I didn't right it down during the install or something. Since I wrote this tread I been looking how to find my 'sa' password I found it in SQL but it is dotted out but what is strange my password for my 'sde' in SQl that is dotted out also doesn't match my password. So, I'm confused. Is there a default password they put in for you? So, I need to figure out my 'sa' password before I do anything. So I'm going to do what you suggested to see if it fixes it. Thanks Ken Hi Ken, The number of dots wont correspond to the number of characters in your password. It's just a standard way of hiding the password. If you're getting to the create database stage and able to log into SQL management studio you must be logging in as another sysadmin user. Your operating system user account? You could reset the sa user and sde user using that account. And create a new ArcSDE database using that account. ... View more

Hello Anyone, I can't add an addition GDB into SQLserver via SDE post install. I've tried a strong password in the second database and made a new empty folder for the database and still no luck. Keep getting native errors. My SDE password in not a strong password for my SDE administrator would that cause a problem? I've read other threads and tried those fixes but not luck. Is there other issues I havn't read about. Thanks Ken Hi Ken, It's probably as you suggested; an issue with the sde password. But at what stage of the post install are you getting the error? Also, I'm not sure what you mean by making "a new empty folder for the database"? At "user information" it requests a username or password to connect to your sql server. Try using the sa or another sysadmin user at this stage. On the next stage, you need to enter your existing sde password at the "create spatial database stage". If this is not strong, you may need to change it. You can easily change the password in SQL Server but you will need to update any connection strings that use the SDE user. Dont forget, if you use application connect(an ArcSDE service), you will need to delete and recreate the service with the new password. This can e dine by running the post install, choose the custom setup and select create ArcSDE service option. Regards, Eoin. ... View more

Yes, the LDAP section is correctly commented-out and the Simple Authentication section is fine. you could try removing whole ldapAdapter section rather than commenting it out in the xml? ... View more

Hi Robin, If you open your gpt.xml in a web browser does it display okay? ... View more

***UPDATE*** OK, I see where I had a problem: I used the same user for the database owner as the geoportal admin user.  I have separated them out now. ...which leads to a new problem!  When I log in as gptadmin in the Geoportal login page, I now get "Unable to connect to LDAP." where I should get "Welcome, gptadmin".  Just to reiterate, I am not using LDAP; instead, I am using simple authentication, so it shouldn't even be trying to access LDAP. Apologies if you've spent time thinking about this; the new problem is where it's at now! Cheers, Robin Hi Robin, The authentication method is specified in your gpt.xml file: <!-- User Management configuration. simpleAdapter OR ldapAdapter. - simpleAdpater: configures geoportal with one administrative user - ldapAdapter: configures geoportal to connect to LDAP user directory store. --> Make sure that the ldapAdaper element is commented out and you have simpleAdapter configured. Regards, Eoin ... View more

Hi John, Are you using MS SQL Server for your INSPIRE database? If so, I believe this might be due to the GEOMETRY_STORAGE parameter. From the GDB install guide: Note: If you are installing on SQL Server you will have to change the configuration string of the GEOMETRY_STORAGE parameter from SDEBINARY to GEOMETRY prior to importing data. This can be done by running the sdedbtune command using the alter operation and then the export command to update the dbtune file or altering the value in the dbtune table within the database. For syntax on running the sdedbtune command see - http://help.arcgis.com/en/geodatabase/10.0/admin_cmds/support_files/serveradmin/sdedbtu ne.htm Edit, for Oracle The GEOMETRY_STORAGE type in the dbtune file needs to be ST_GEOMETRY ... View more