Differences

This shows you the differences between two versions of the page.

--- audina:oncontact:oncontact_user_administration [2009/02/03 12:04]
smayr
+++ audina:oncontact:oncontact_user_administration [2017/07/28 17:09] (current)
smayr [MS SQL Management (potentially unnecessary)]
@@ Line 4: / Line 4: @@
  * Click on button < + > to add a new user.
  * New user should have the following settings:
-    {{.:oncontact-admin-newuser-login.jpg|OnContact Administration: New User > Login}}{{.:oncontact-admin-newuser-system.jpg|OnContact Administration: New User > System}}{{.:oncontact-admin-newuser-email.jpg|OnContact Administration: New User > E-mail}}
- * Create same user in MSSQL OnContact database.
+{{.:oncontact-admin-newuser-login.jpg|OnContact Administration: New User > Login}}
-    * Open MS SQL Management Studio.
+{{.:oncontact-admin-newuser-system.jpg|OnContact Administration: New User > System}}
-    * Connect to CRMSERVER\ONCONTACT database.
+{{.:oncontact-admin-newuser-email.jpg|OnContact Administration: New User > E-mail}}
-    * In the Object Explorer, open OnContact > Security > Users, and right-click to Add User.
-    * Enter username and login name: ''//DOMAINNAME\username//''
+ * Note: If the user is created with a blank password you must go to the Login tab and re-enter the username and password and then click the save button.
-    * Enter default database schema: ''dbo''
-{{.:oncontact-mssql-usercreation.jpg|MS SQL: User creation for OnContact database}}
+== Automatically Fill Username at Login ==
-    * In the Object Explorer, open Security > Logins, and right-click to Add Login.
-{{.:oncontact-mssql-usersecurity-general.jpg|MS SQL: Security > Logins for OnContact database}}
-{{.:oncontact-mssql-usersecurity-serverroles.jpg|MS SQL: Security > Logins for OnContact database}}
-{{.:oncontact-mssql-usersecurity-usermappings.jpg|MS SQL: Security > Logins for OnContact database}}
-{{.:oncontact-mssql-usersecurity-securables.jpg|MS SQL: Security > Logins for OnContact database}}
-{{.:oncontact-mssql-usersecurity-status.jpg|MS SQL: Security > Logins for OnContact database}}
  * Enable Integrate Login, to avoid entering username and password each time:
      * Go and edit the file ''C:\Program Files\Oncontact Software\bin\oncontact.cfg'' to include the following: <code xml><Oncontact>
@@ Line 37: / Line 31: @@
      * Open Outlook, and verify it connects.
+== License Limit ==
-=== License Limit ===
 If there are too many users defined in the OnContact users database (i.e. more than 30 users), then the following message shows up when connecting to OnContact:
 <code>
@@ Line 46: / Line 39: @@
 To fix this, connect to the SQL database (using SQL Administration), and perform the following queries:
 To view all users:
 <code sql>
-SELECT * FROM dbo.onca_user
+SELECT *
+FROM dbo.onca_user
 </code>
-To delete the offending user (eg 'Tony'):
+To deactivate the offending user (eg 'missy'):
 <code sql>
-DELETE FROM dbo.onca_user
+UPDATE dbo.onca_user
-  WHERE dbo.onca_user.user_code = 'tony'
+SET active='N'
+WHERE dbo.onca_user.user_code = 'missy'
 </code>
@@ Line 60: / Line 56: @@
 <code sql>
 UPDATE dbo.onca_user
-  SET dbo.onca_user.password_value = 'ZxL4Pwi7iNi5RpIYFPH9VxyU3fs='
+SET dbo.onca_user.password_value = 'ZxL4Pwi7iNi5RpIYFPH9VxyU3fs='
-  WHERE dbo.onca_user.user_code = 'missy'
+WHERE dbo.onca_user.user_code = 'missy'
 </code>
+== MS SQL Management (Only for Manual Queries and Data Migration) ==
+ * Connect with Remote Desktop to ONCONTACT server using administrator credentials.
+ * Create same user in MSSQL OnContact database.
+    * Open MS SQL Management Studio (Start > All Programs > Microsoft SQL Server 2005 > SQL Management Studio).
+    * Connect to CRMSERVER\ONCONTACT database.
+    * In the Object Explorer, open OnContact > Security > Users, and right-click to Add User.
+    * Enter username and login name: ''//DOMAINNAME\username//''
+    * Enter default database schema: ''dbo''
+{{.:oncontact-mssql-usercreation.jpg|MS SQL: User creation for OnContact database}}
+    * In the Object Explorer, open Security > Logins, and right-click to Add Login.
+{{.:oncontact-mssql-usersecurity-general.jpg|MS SQL: Security > Logins for OnContact database}}
+{{.:oncontact-mssql-usersecurity-serverroles.jpg|MS SQL: Security > Logins for OnContact database}}
+{{.:oncontact-mssql-usersecurity-usermappings.jpg|MS SQL: Security > Logins for OnContact database}}
+{{.:oncontact-mssql-usersecurity-securables.jpg|MS SQL: Security > Logins for OnContact database}}
+{{.:oncontact-mssql-usersecurity-status.jpg|MS SQL: Security > Logins for OnContact database}}