topic Re: SDE user password. in Data Management Questions

SDE user password.

QuinnMcCarthy — Tue, 13 Mar 2012 13:11:30 GMT

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

Re: SDE user password.

VinceAngelo — Tue, 13 Mar 2012 13:55:41 GMT

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

Re: SDE user password.

QuinnMcCarthy — Tue, 13 Mar 2012 14:54:31 GMT

Vince,

We are on windows server 2008 SP2 and SQLserver 2008 sp2

How do you get to the service startup utility?

Thanks

Quinn

Re: SDE user password.

VinceAngelo — Tue, 13 Mar 2012 15:50:39 GMT

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

- V

Re: SDE user password.

EoinRyan — Tue, 13 Mar 2012 19:43:49 GMT

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.

Re: SDE user password.

QuinnMcCarthy — Wed, 14 Mar 2012 15:53:42 GMT

Thanks eryan.

I will give that a try.