Change from Windows Auth to XSPOC Auth

In SSMS either insert OR update UseXSPOCAuthentication=1 (only run one of the below)

–INSERT
INSERT INTO tblSystemParameters VALUES( ‘UseXSPOCAuthentication’,1,null)

–UPDATE
UPDATE tblSystemParameters set value=1 where  parameter=’UseXSPOCAuthentication’

Then insert a user (change the username and password)

INSERT INTO tblUserSecurity VALUES(‘username’,1,1,1,1,1,1,’password’,null,null,null,null,0)

In a command window run

c:\xspoc\pwhash /s localhost /n /d xspoc

c:\xspoc\pwhash /s host.xspoc.com /d xspoc /u SpocWrite /p password