That's a standard Windows error that appears whenever the ArcSDE service has beenmisconfigured in any way. Unfortunately, you didn't provide any of the information whichwould be necessary to help you:RDBMS product, version, and service pack/patchsetArcSDE version, service pack, and any additional patchesThe output from 'sdeservice -o list'The contents of your SDEHOME/etc/dbinit.sde fileAny error messages from the SDEHOME/etc/giomgr.logAn architecture description (the OS type and relative location of the ArcGIS Server,ArcSDE, and database components)All in text form, not as graphics, please -- It's important to place error messages in the message text block, because that's how others would be able to find your solution.In fact, if you had searched on the key words of the message ("arcsde service startedthen stopped"), you would have found a number of useful postings. - V
Don't know if this is the issue (I don't have ArcSDE at hand right now), but I did notice that in the screenshot of the windows "services" file in notepad, that you copied the"esri_sde 5151/TCP"line at the end of the text file.If I remember it well, the line needs to be inserted in the rising order of port numbers, so in your case in between two other port number entries of the file.
if the place of �??esri_sde 5151/tcp�?� in the service file is an issue then where should it be positioned?
In the rising order based on port number, so in betweenipsec-msft 4500/udpandllmnr 5355/tcpI would also refrain from using empty lines in the services text file.Marco
Marco -While it is probably wise to populate the services file in port order, it certainly isn't required.The only thing that's necessary is a terminal newline (otherwise the last line in the file is discarded). Empty lines are legal (and ignored, just like lines with leading octothorpes).- V
An instructor provided me the answer! What follows the �??p should be sde123 but not sde
Hi Jamal,Good to hear you got it up and running. However, since -p is the ArcSDE database admin password, as in:sdemon -o start {[-i {<service> | <port#>}] [-s <server_name>] | [-H <sde_directory>]}[-p <ArcSDE_admin_password>]I understand you entered "sde123" as the SDE user's password in SQL server or during ArcSDE install. That is of course fine for a quick personal test setup like you are probably creating, but anyone reading this may prefer entering a strong password for more serious applications.
Thank you for the elaboration Marco. This is helpful.I�??m not sure at which step of the installation of the ArcSDE we are required to enter the users name/password. For example, during the installation of the sqlserver, there is a dialogue box at which we determine our user name and password as shown in the screenshot below:[ATTACH=CONFIG]20026[/ATTACH]
How about the ArcSDE? Does such dialogue box exist in the ArcSDE while being installed (I can�??t�?? remember)? And then where might I have chosen the user name/password for the ArcSDE to be sde/sde123 respectively?
Jamal,This is the SQL Server administration, not the ArcSDE administration as from within ArcGIS. You can probably change the password for an already existing SDE user in here somewhere, but this is not where you initially set it. See below.You set the SDE user password upon creation of the geodatabase structure in your SQL Server database. It is done in the Create Enterprise Geodatabase tool that you ran from ArcToolbox. If I look at the "q.pdf" file with screenshots you created, I see an entry line in that tool for "Geodatabase Administrator Password", this is probably the SDE user's password. The dialog seems to default to a 6 digit password, which corresponds with the "sde123" password the ESRI instructor gave you. I guess "sde123" is just the default password filled in by ESRI / the Create Enterprise Geodatabase tool, and you forgot to change it. It would have been better if there was no default password, and you were forced to enter one yourself, that way, you would have been aware of setting it, instead of running into the issue with a wrong / unknown password like you did.
Thank you Marco the prompt reply. This is very useful.I do absolutely agree with you. I couldn�??t be able to know how the ArcGIS could take the password for the sde user by default! And why we are not able to change the user name (sde) in this case?
At the �??beginning of life�?�, how the sde login is created? is it ceated even before using the "create enterprise geodatabase" tool?
ArcGIS just by default assumes that the geodatabase administrator is a user called SDE (this is a very old convention of ArcSDE), and automatically creates one if you choose "SDE owned schema" in the "Create Enterprise Geodatabase" tool. If you don't want that, you CAN define a geodatabase administrator yourself by creating a user with any name you desire, but this user must be granted specific rights if it can function as a geodatabase administrator. In that case, you will also need to create the database yourself, and than run the "Enable Enterprise Geodatabase" to create the necessary geodatabase system structure in your database.See the following Help topics for the difference between "Create Enterprise Geodatabase" and "Enable Enterprise Geodatabase"Creating a database and geodatabase in SQL ServerEnabling enterprise geodatabase functionality in an existing databaseAs this Help page clearly states:"The Create Enterprise Geodatabase tool creates a database, storage locations, and a database user (EDIT: THIS IS BY DEFAULT THE "SDE" USER, AND IT SEEMS WITH DEFAULT PASSWORD "SDE123") to be used as the geodatabase administrator and owner of the geodatabase depending on the database management system (DBMS) used. It grants the geodatabase administrator privileges required to create a geodatabase, then creates a geodatabase in the database."
"The Create Enterprise Geodatabase tool creates a database, storage locations, and a database user (EDIT: THIS IS BY DEFAULT THE "SDE" USER, AND IT SEEMS WITH DEFAULT PASSWORD "SDE123") to be used as the geodatabase administrator and owner of the geodatabase depending on the database management system (DBMS) used. It grants the geodatabase administrator privileges required to create a geodatabase, then creates a geodatabase in the database."
Hi,I wanted to add a small clarification to this:There is no default password for the sde user. If you are running the Create Enterprise Geodatabase tool against a SQL Server instance and have "Sde Owned Schema" checked, you must type a password in the Geodatabase Administrator Password field. If you do not, the tool returns "Error 000152: Administrator username and password are required."
Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
