There may be times when you would like to update the Organization names in the Password Server.
Updating the Organization name requires a SQL Database change, we can make this change using SQL Management Studio.
Note: If need to install SQL Management Studio please try this link.
Step 1
Open a New Query in SQL Management Studio
To update the OrgName in dbo.OrganizationTable we first need to disable the trigger. Copy and paste the following in to the New Query Window.
USE [AuthAnvilPasswordServer]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--Drop OrganizationTable Triggers
IF EXISTS (SELECT * FROM sys.triggers WHERE object_id = OBJECT_ID(N'[dbo].[TR_OrgTableBlock]'))
DROP TRIGGER [dbo].[TR_OrgTableBlock]
--Clear OrganizationTable
DELETE FROM [AuthAnvilPasswordServer].[dbo].[OrganizationTable]
where OrgName = ''
GO
Step 2
With the Trigger dropped you can now update the Organization Name in dbo.OrganizationTable.
You can do this by Selecting Edit Top 200 rows on dbo.OrganizationTable.
In Edit Mode we can update the OrgName field.
Step 3
Once we have the OrgName update complete we need to recreate the trigger. This is done by copy and pasting the following in a New Query.
--Create OrganizationTable Triggers
CREATE TRIGGER [dbo].[TR_OrgTableBlock]
ON [AuthAnvilPasswordServer].[dbo].[OrganizationTable]
FOR INSERT, UPDATE, DELETE
AS
IF OBJECT_ID('tempdb..#Disable') IS NOT NULL RETURN
PRINT 'Trigger Executed'
ROLLBACK TRAN
RAISERROR ('You cannot directly access this table. Please use the stored procedures',14,1);
GO
You can verify the the Organization name is correctly entered by navigating to https://(your domain)/AAPS and checking the Orgnizaiton list drop down menu.
Questions?
If you have any questions or need some help, we would be happy to assist. Open a case at help.scorpionsoft.com or send an email to support@scorpionsoft.com.