6/3/2024 9:34:27 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss SQL Server or Oracle database administration related to SalesLogix databases. View the code of conduct for posting guidelines.
|
|
|
|
Changing the sysdba password
Posted: 24 Jan 07 10:39 AM
|
fiogf49gjkf0d Hi,
Has anyone ever come across the need to change the password for the sysdba account to something more secure than the ubiquitous "masterkey". Our DBA's are demanding that all SQL logins have a complex password consisting of alphanumeric, case changes and special characters. My question is, has anyone come across any issues with SalesLogix after changing the sysdba password? We are running 6.2 Service Pack 3. My users access exclusively via the web client, and the backend is SQL 2000 SP4.
Thanks in advance. 
|
|
|
|
Re: Changing the sysdba password
Posted: 24 Jan 07 12:05 PM
|
fiogf49gjkf0d Honestly, this is great to hear. NO implementation should have masterkey as the password, not even development environments.
Assuming the web client is the only application hitting the database, you simply need to update the SalesLogix Connection definition.
If other applications are connecting with the sysdba login they will need to be updated as well. If they are using the SalesLogix OLEDB connection they will not require an update. Unless of course you are chaging the SalesLogix user passwords as well.
Timmus |
|
|
|
Re: Changing the sysdba password
Posted: 01 Oct 07 4:25 PM
|
This is kind of funny to me. I am researching doing the same thing...changing the sysdba password. However, when we first purchased SLX, I asked about doing this and it was recommended that we didn't make that change....so we dropped the issue. However, due to all of the security requirements from our corporate office that we are implementing, this issue came up again. So, I have started my research all over and have now come across this posting!! It makes me laugh...frustrated but funny!
I do have a question regarding the remotes that wasn't quite clear to me. Will this mean that new databases will need to be cut? I wasn't sure if that username and password are actually stored in the remote database as I know we use it to cut the database. Please advise....Thanks! |
|
|
| |
|
Re: Changing the sysdba password
Posted: 03 Jan 08 9:07 AM
|
Hi,
Sorry... but when you refer to Host, you refer at the main database or remote office database's computers.
I need to change the sysdba password on main and remote offices. I did the change on both and syncronization started working wrong, so I reset the masterkey sysdba password.
Can tell me the procedure, step by step to change the sysdba password on main office and remotes???
I don´t Know, what I am doing wrong ???
Thanks for advance.
Patty |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|