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 Server
Enabling enterprise geodatabase functionality in an existing database
As 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."
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.