Differences

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

--- audina:oncontact:oncontact_user_administration [2016/02/12 13:50]
ajdavis [OnContact User Administration]
+++ audina:oncontact:oncontact_user_administration [2017/07/28 17:09] (current)
smayr [MS SQL Management (potentially unnecessary)]
@@ Line 39: / 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 53: / 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.