Views:
This procedure requires logging on to the production. Consider this process as critical to the customer experience and to IOTAP. Be meticulous and cognizant of the actions you are going to perform.

Connecting to the Work 365 Server

Follow the instructions in this article to connect to the Work 365 server. Note the server names as follows:

  1. ​Production Server: AZW365F01
  2. Log in to Work 365 server using Remote Desktop​
  3. ​Start Microsoft SQL Server​​​​​ (Start--> type 'Microsoft SQL server')​​​​ 

  1. Select Authentication type as Windows Authentication. Enter User name and Password and click Connect.

  1. Select W365_Config Database and run the below query to check whether Application User has been enabled or not. Make sure Username for that respective EndPointUrl has ‘e4b1a995-abe3-4350-a61c-65fccd32e8bd’ value and password can be NULL .


SELECT TenantId,EndPointUrl,Username,Password
FROM Tenant (NOLOCK)
WHERE Username = 'e4b1a995-abe3-4350-a61c-65fccd32e8bd'


  1. If the username doesn’t have a value specified in step 5 then request the client to follow this article to enable it.
  2. Sign out of the server when you're done (PLEASE DO NOT SHUTDOWN!)

Note:

  • Work365 from version 3.5 onwards support S2S authentication

            S2S - Server to Server authentication.

  • Please make sure the App version is not null in the Tenant table. If it is null, then please update it. Steps to find out AV given below

 

Find AV version

  • Go to any of the popup forms in the Work365 app.
  • Grab the URL and you can find the App version in it.
  • If it is 3.5 then AV could be 3.5.1.0. make sure the AV which you are planning to update exists in the Tenant table.