SDE user password.

[QuinnMcCarthy]

We have an application that needs the sde password to run. I have 2 writen down for the 2 services but not sure if they are right. Is there a way to check those sde login's?

If they are not correct is there a way to change the sde password without knowing the old one?

Thanks

Quinn

[VinceAngelo]

There are several issues here, but they all depend on your environment --
+ Which operating system are you using?
+ Which database are you using?

In general, the DBA (or SysAdmin) can change a lost password, but you need
to make sure the service start-up utility (as appropriate to the OS) has the
new password, or there will be trouble down the line.

- V

[QuinnMcCarthy]

Vince,

We are on windows server 2008 SP2 and SQLserver 2008 sp2

How do you get to the service startup utility?

Thanks

Quinn

[VinceAngelo]

See the documentation for the 'sdeservice' command (Windows only).

- V

[EoinRyan]

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.

[QuinnMcCarthy]

Thanks eryan.

I will give that a try.