Differences

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

--- audina:oncontact:oncontact_user_administration [2014/09/16 14:50]
ajdavis [OnContact User Administration]
+++ 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}}
+{{.: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}}
  * 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.
@@ Line 35: / 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 49: / 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 (potentially unnecessary) ==
+== 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.
+    * 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.