Change Password Database Owner ArcGIS Service SQL Server #108

Open
opened 3 years ago by rbsetiawan · 0 comments
Owner

Change Password Database Owner ArcGIS Enterprise 10.7.1 Service SQL Server 2014

Result

source Dashboard webmap service rest service
ori image image image image
change pass SQL Server image image image image
Update pass register database image image image image
Detail proses

Source

Change Password

  • Database

    • url : upaedbwin.gisportal.id
    • Database mame : rnd_chgpass
    • username : arcpass
    • old.password : geinfomediarnd0010
    • new.password : geonet$123
  • restart rest service (stop - start)
    image
    image

  • Register database :
    image

Change Password from Register Database

  • Update password register database :
    • open server/manager -> site -> Data Stores
    • -> setting
    • Update Password
      image
    • Import a connection file with an updated password
      image
    • import database connection from ArcGIS Desktop
      image
    • Save Settings
    • Validate
    • Validate Register Database from ArcGIS Server Manager
      image

REstart Services:

![image](/attachments/d24b8126-5096-47fa-94bc-fb0aa2f0096b)

- Data view
|source|Dashboard|webmap|service|rest service|
|---|---|---|---|---|
|change pass	|![image](/attachments/7f5ef616-20c0-4a73-a7e3-348cc890abaf)	|![image](/attachments/a2b52f9b-0bf6-4bbe-af69-f6a86741a6b7)	|![image](/attachments/f2f10672-0408-4e35-b3cf-52a5ae2bcb9b)	|![image](/attachments/c1c278dc-d8c5-425d-a1e1-385e93d02d72)	|
|Update pass	|![image](/attachments/7ec939e8-5a2e-426c-a029-c872cf34d58b)	|![image](/attachments/49269a10-ded5-4b1b-b9ed-5b36b780e034)	|![image](/attachments/3658c778-772c-46ab-b645-766ec2a00574)	|![image](/attachments/c5390ca3-ba3e-4c64-b3e1-7dee7a75c172)	|

Change Password Database Owner ArcGIS Enterprise 11.0 Service SQL Server 2017

Result

source Dashboard webmap service rest service
ori image image image image
change pass SQL Server image image image image
Update pass register database image image image image
Detail proses

Source

Change Password

  • Database

    • url : database.gisportal.id
    • Database mame : rnd
    • username : arcpass
    • old.password : geinfomediarnd0010
    • new.password : geonet$123
  • restart rest service (stop - start)
    image

  • Register database :
    image

Change Password from Register Database

  • Update password register database :
    • open database on portal content
    • -> setting
    • Update Password
      image
    • Import a connection file with an updated password
      image
    • import database connection from ArcGIS Pro
      image
    • Validate
      image
    • Save Settings
    • Validate Register Database from ArcGIS Server Manager
      image
    • Data view
      source Dashboard webmap service rest service
      change pass image image image image
      Update pass image image image image

Change Password Database Owner ArcGIS Enterprise 11.0 Service SQL Server 2017

Result

source Dashboard webmap service rest service
ori image image image image
change new pass SQL Server image image image image
change to ori / restore password image image image image
# Change Password Database Owner ArcGIS Enterprise 10.7.1 Service SQL Server 2014 ## Result |source|Dashboard|webmap|service|rest service| |---|---|---|---|---| |ori |![image](/attachments/4ae1c47e-8ca1-4742-80d7-ed3517583d65) |![image](/attachments/fe26b0c6-3cb6-49af-a9e6-da2a2a485cac) |![image](/attachments/f6418a62-3a2b-4cf6-aa75-6d178edab233) |![image](/attachments/1750af67-2152-4375-b66f-0fcc40801f43) | |change pass SQL Server |![image](/attachments/7f5ef616-20c0-4a73-a7e3-348cc890abaf) |![image](/attachments/a2b52f9b-0bf6-4bbe-af69-f6a86741a6b7) |![image](/attachments/f2f10672-0408-4e35-b3cf-52a5ae2bcb9b) |![image](/attachments/c1c278dc-d8c5-425d-a1e1-385e93d02d72) | |Update pass register database |![image](/attachments/4ae1c47e-8ca1-4742-80d7-ed3517583d65) |![image](/attachments/fe26b0c6-3cb6-49af-a9e6-da2a2a485cac) |![image](/attachments/f6418a62-3a2b-4cf6-aa75-6d178edab233) |![image](/attachments/1750af67-2152-4375-b66f-0fcc40801f43) | <details> <summary>Detail proses</summary> ## Source - ArcGIS Desktop 10.7.1 Adv - Database SQL Server 2014 - url : upaedbwin.gisportal.id - Database mame : rnd_chgpass - username : arcpass - password : geinfomediarnd0010 |General |Propertis | |--- |--- | |![image](/attachments/81d1e004-92da-4b5b-957b-1efd817bf552) |![image](/attachments/08cc5aab-bd17-4854-92f0-52df6c8466b7) | - ArcGIS Enterprise 10.7.1 - Account : arcgis - ArcgIS Server : https://upaedbwin.gisportal.id/server - Folder : rnd_chgpass - Service : https://upaedbwin.gisportal.id/server/rest/services/changepass/test_chgpass/FeatureServer - Database register : ![image](/attachments/19f858eb-5446-43e8-9107-264c2bce025b) - Portal for ArcGIS : https://upaedbwin.gisportal.id/portal - Folder : rnd_chgpass - Content : - service https://upaedbwin.gisportal.id/portal/home/webmap/viewer.html?layers=5b3df8b98dce4db1bea09ff7b0c6a112 - webmap https://upaedbwin.gisportal.id/portal/home/webmap/viewer.html?layers=5b3df8b98dce4db1bea09ff7b0c6a112 - dashboard https://upaedbwin.gisportal.id/portal/apps/opsdashboard/index.html#/45ca06787ec54ab6b57e126641afa673 - data view : |source|Dashboard|webmap|service|rest service| |---|---|---|---|---| |ori |![image](/attachments/4ae1c47e-8ca1-4742-80d7-ed3517583d65) |![image](/attachments/fe26b0c6-3cb6-49af-a9e6-da2a2a485cac) |![image](/attachments/f6418a62-3a2b-4cf6-aa75-6d178edab233) |![image](/attachments/1750af67-2152-4375-b66f-0fcc40801f43) | |change pass |![image](/attachments/7f5ef616-20c0-4a73-a7e3-348cc890abaf) |![image](/attachments/a2b52f9b-0bf6-4bbe-af69-f6a86741a6b7) |![image](/attachments/f2f10672-0408-4e35-b3cf-52a5ae2bcb9b) |![image](/attachments/c1c278dc-d8c5-425d-a1e1-385e93d02d72) | Databse Register status ![image](/attachments/2eb8cf78-b105-47dd-af68-9b0acaa5590c) Database details on portal content ![image](/attachments/c423c70f-08e4-45ce-a696-95cde94b05b1) ## Change Password - Database - url : upaedbwin.gisportal.id - Database mame : rnd_chgpass - username : arcpass - old.password : geinfomediarnd0010 - new.password : geonet$123 - restart rest service (stop - start) ![image](/attachments/67e9d62d-a10d-4e2f-bf7d-49faf7d1d914) ![image](/attachments/0bb22ff5-79e7-4727-87c1-f9dd33eff642) - Register database : ![image](/attachments/f35f7399-54a7-450b-adae-dd123fc87abf) ## Change Password from Register Database - Update password register database : - open server/manager -> site -> Data Stores - -> setting - Update Password ![image](/attachments/64b22f89-e9e8-43f0-bffe-759568e8d4f2) - Import a connection file with an updated password ![image](/attachments/04a79a27-ef22-47c4-97f0-f1e6e80e584c) - import database connection from ArcGIS Desktop ![image](/attachments/4b93b670-2f94-4629-a108-37a8d282c04d) - Save Settings - Validate - Validate Register Database from ArcGIS Server Manager ![image](/attachments/449400e1-9c8c-4707-9d1f-b7acb8e84fd7) ## REstart Services: ![image](/attachments/d24b8126-5096-47fa-94bc-fb0aa2f0096b) - Data view |source|Dashboard|webmap|service|rest service| |---|---|---|---|---| |change pass |![image](/attachments/7f5ef616-20c0-4a73-a7e3-348cc890abaf) |![image](/attachments/a2b52f9b-0bf6-4bbe-af69-f6a86741a6b7) |![image](/attachments/f2f10672-0408-4e35-b3cf-52a5ae2bcb9b) |![image](/attachments/c1c278dc-d8c5-425d-a1e1-385e93d02d72) | |Update pass |![image](/attachments/7ec939e8-5a2e-426c-a029-c872cf34d58b) |![image](/attachments/49269a10-ded5-4b1b-b9ed-5b36b780e034) |![image](/attachments/3658c778-772c-46ab-b645-766ec2a00574) |![image](/attachments/c5390ca3-ba3e-4c64-b3e1-7dee7a75c172) | </details> # Change Password Database Owner ArcGIS Enterprise 11.0 Service SQL Server 2017 ## Result |source|Dashboard|webmap|service|rest service| |---|---|---|---|---| |ori |![image](/attachments/7ec939e8-5a2e-426c-a029-c872cf34d58b) |![image](/attachments/49269a10-ded5-4b1b-b9ed-5b36b780e034) |![image](/attachments/3658c778-772c-46ab-b645-766ec2a00574) |![image](/attachments/c5390ca3-ba3e-4c64-b3e1-7dee7a75c172) | |change pass SQL Server |![image](/attachments/7f5ef616-20c0-4a73-a7e3-348cc890abaf) |![image](/attachments/a2b52f9b-0bf6-4bbe-af69-f6a86741a6b7) |![image](/attachments/f2f10672-0408-4e35-b3cf-52a5ae2bcb9b) |![image](/attachments/c1c278dc-d8c5-425d-a1e1-385e93d02d72) | |Update pass register database |![image](/attachments/7ec939e8-5a2e-426c-a029-c872cf34d58b) |![image](/attachments/49269a10-ded5-4b1b-b9ed-5b36b780e034) |![image](/attachments/3658c778-772c-46ab-b645-766ec2a00574) |![image](/attachments/c5390ca3-ba3e-4c64-b3e1-7dee7a75c172) | <details> <summary>Detail proses</summary> ## Source - ArcGIS Pro 3.1 Adv - Database SQL Server 2017 - url : database.gisportal.id - Database mame : rnd_chgpass - username : arcpass - password : geinfomediarnd0010 |General |Propertis | |--- |--- | |![image](/attachments/81d1e004-92da-4b5b-957b-1efd817bf552) |![image](/attachments/08cc5aab-bd17-4854-92f0-52df6c8466b7) | - ArcGIS Enterprise 11.0 - Account : dpradana - ArcgIS Server : https://development.gisportal.id/server - Folder : rnd_chgpass - Service : https://development.gisportal.id/server/rest/services/rnd_chgpass/point_change_pass/MapServer/0 - Database register : ![image](/attachments/013a6a0c-8a0f-49f8-85f3-8985c9fd40fb) - Portal for ArcGIS : https://development.gisportal.id/portal - Folder : rnd_chgpass - Content : - service https://development.gisportal.id/portal/home/item.html?id=0b26e51e29cc469db20b255263ee44f0 - webmap https://development.gisportal.id/portal/home/webmap/viewer.html?webmap=0b26e51e29cc469db20b255263ee44f0 - dashboard https://development.gisportal.id/portal/apps/dashboards/75229ac829ba4b54b199024d9efbdcb9 - data view : |source|Dashboard|webmap|service|rest service| |---|---|---|---|---| |ori |![image](/attachments/7ec939e8-5a2e-426c-a029-c872cf34d58b) |![image](/attachments/49269a10-ded5-4b1b-b9ed-5b36b780e034) |![image](/attachments/3658c778-772c-46ab-b645-766ec2a00574) |![image](/attachments/c5390ca3-ba3e-4c64-b3e1-7dee7a75c172) | |change pass |![image](/attachments/7f5ef616-20c0-4a73-a7e3-348cc890abaf) |![image](/attachments/a2b52f9b-0bf6-4bbe-af69-f6a86741a6b7) |![image](/attachments/f2f10672-0408-4e35-b3cf-52a5ae2bcb9b) |![image](/attachments/c1c278dc-d8c5-425d-a1e1-385e93d02d72) | Databse Register status ![image](/attachments/73c4747c-314e-44f6-a938-7945b780d2b5) Database details on portal content ![image](/attachments/3f93236a-02c5-4913-81ac-3f546af66e8d) ## Change Password - Database - url : database.gisportal.id - Database mame : rnd - username : arcpass - old.password : geinfomediarnd0010 - new.password : geonet$123 - restart rest service (stop - start) ![image](/attachments/e1b8b0cf-6007-47bc-9b2d-efeabb12ff13) - Register database : ![image](/attachments/ea48dacb-180f-4b1f-922f-f25c7015653b) ## Change Password from Register Database - Update password register database : - open database on portal content - -> setting - Update Password ![image](/attachments/35bbe58d-2f28-44ad-b8e1-2f7a49950027) - Import a connection file with an updated password ![image](/attachments/781f5e9b-14f6-4d2c-939a-455f0d4ebaa3) - import database connection from ArcGIS Pro ![image](/attachments/03e79862-8c5d-4745-a236-5e655e4d1cd5) - Validate ![image](/attachments/d5906518-74cb-4932-9026-b5e77970ff7b) - Save Settings - Validate Register Database from ArcGIS Server Manager ![image](/attachments/9cbc5ee6-cfb6-4837-bbd1-ce35502fccf1) - Data view |source|Dashboard|webmap|service|rest service| |---|---|---|---|---| |change pass |![image](/attachments/7f5ef616-20c0-4a73-a7e3-348cc890abaf) |![image](/attachments/a2b52f9b-0bf6-4bbe-af69-f6a86741a6b7) |![image](/attachments/f2f10672-0408-4e35-b3cf-52a5ae2bcb9b) |![image](/attachments/c1c278dc-d8c5-425d-a1e1-385e93d02d72) | |Update pass |![image](/attachments/7ec939e8-5a2e-426c-a029-c872cf34d58b) |![image](/attachments/49269a10-ded5-4b1b-b9ed-5b36b780e034) |![image](/attachments/3658c778-772c-46ab-b645-766ec2a00574) |![image](/attachments/c5390ca3-ba3e-4c64-b3e1-7dee7a75c172) | </details> # Change Password Database Owner ArcGIS Enterprise 11.0 Service SQL Server 2017 ## Result |source|Dashboard|webmap|service|rest service| |---|---|---|---|---| |ori |![image](/attachments/4ae1c47e-8ca1-4742-80d7-ed3517583d65) |![image](/attachments/fe26b0c6-3cb6-49af-a9e6-da2a2a485cac) |![image](/attachments/f6418a62-3a2b-4cf6-aa75-6d178edab233) |![image](/attachments/1750af67-2152-4375-b66f-0fcc40801f43) | |change new pass SQL Server |![image](/attachments/7f5ef616-20c0-4a73-a7e3-348cc890abaf) |![image](/attachments/a2b52f9b-0bf6-4bbe-af69-f6a86741a6b7) |![image](/attachments/f2f10672-0408-4e35-b3cf-52a5ae2bcb9b) |![image](/attachments/c1c278dc-d8c5-425d-a1e1-385e93d02d72) | |change to ori / restore password |![image](/attachments/4ae1c47e-8ca1-4742-80d7-ed3517583d65) |![image](/attachments/fe26b0c6-3cb6-49af-a9e6-da2a2a485cac) |![image](/attachments/f6418a62-3a2b-4cf6-aa75-6d178edab233) |![image](/attachments/1750af67-2152-4375-b66f-0fcc40801f43) |
rbsetiawan added the
ArcGIS Enterprise
Issue
RND
labels 3 years ago
rbsetiawan self-assigned this 3 years ago
rbsetiawan added the
SQL Server
label 3 years ago
rbsetiawan added the
Solvent
label 3 years ago
Sign in to join this conversation.
Loading…
There is no content yet.