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