Question

AssystWeb User Login Setup

  • 12 October 2023
  • 5 replies
  • 127 views

Userlevel 1
Badge +6

Hi All,

I have created an assyst user but I couldn’t find where I can setup the username and the password for the user. What am I missing? 

Note: I’m creating this user to log in to AssytWeb.

          

Regards,

Nuwanthika 

 


5 replies

Userlevel 2
Badge +5

Hi 

 

What authentication mechanism are you intending to use (i.e. which did you pick when installing assyst)?

 

 (https://wiki.axiossystems.com/assyst11-7Wiki/index.php/Installation:assyst_Server_Definition)

Userlevel 1
Badge +6

Hi Alan,

It’s 

Assyst installer: Authentication Mapping 

AssystWeb*  Default [Database]

 

Hope this is what you are asking. 

 

Regards,

Nuwanthika

Userlevel 2
Badge +5

Hi

 

So if you are using database authentication you are delegating the authentication step to the database itself. If that is SQL Server it would (probably) mean what SQL Server refers to as “SQL Server Authentication”, which typically would be a user in the database sharing the same name as the assyst user you are trying to log in as. Password is set against the SQL Server login object associated with that user.

Hope that makes sense?

   

Userlevel 1
Badge +6

Hi Alan,

I’m not clear on what do you mean by " would be a user in the database"? Should be created a DB record for the same Assyst user? If so, where it should be updated the username and password?  

OR where else user should be updated? 

 

Regards,

Nuwanthika

Userlevel 2
Badge +5

Hi

 

If you are using database authentication, and your database is SQL Server, all assyst is doing is delegating to the database to authenticate the user. So the database will need a user matching your assyst user short code (https://learn.microsoft.com/en-us/sql/t-sql/statements/create-user-transact-sql?view=sql-server-ver16) and this user will need associated with a login (again, a SQL Server concept not assyst https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/create-a-login?view=sql-server-ver16).  

Reply