Reset or remind password for Debco Employee Purchase Program
This solution is to be performed by an Administrator
Issue:
Employee requests a password reset for the Employee Purchase Program
FYI:
Every debco employee should have a shortcut to the employee purchase app on their desktop.
S:\solomon\DotNetApps\EmployeePurchase\EmployeePurchaseApp.exe
If its the employees first time logging into the Employee Purchase Program, they can create a password themselves.
Solution:
Step 1. Find out the employees Solomon ID. If they don't know it, they should speak with their manager. It is NOT their Windows or Solomon username.
Step 2. Connect to DEBCOSQL and launch SQL Server Management Studio
Step 3. Sign in using credentials found in LastPass
Step 4. Click on "New Query"
Step 5. Change database from master to DEBCO
Step 5. See if the employee already has a password set up by ruining the following query.
If the CustPassword field has a value advise the Employee the
Username: SPETGANG E
Password : contents of the CustPassword field
declare @CustID varchar(15), @Password varchar(15)
set @CustID = 'CUSTOMER SOLOMON ID'
SELECT CustID, UserID, PSPassword, CustPassword, Enabled, CustNbr
FROM xDBCustID
WHERE (CustID = @CustID)
Step 6. If the employee needs the password set use the script below.
declare @CustID varchar(15), @Password varchar(15)
set @CustID = 'CUSTOMER SOLOMON ID'
set @Password = 'PASSWORD YOU CREATE'
UPDATE xDBCustID
SET CustPassword = @Password
WHERE (CustID = @CustID)
SELECT CustID, UserID, PSPassword, CustPassword, Enabled, CustNbr
FROM xDBCustID
WHERE (CustID = @CustID)
Step 7. Advise the customer of the credentials
Username: Customer Solomon ID
Password: Password you created