1E 23.7 (SaaS)

If the connector is using Windows Authentication, then you can use one of the following:

1. Create a SQL Login for the 1E server's computer$ account, and explicitly grant it the above rights.

2. Add the 1E server's computer$ account to the ConfigMgr_DViewAccess localgroup on the Configuration Manager database server - this is the preferred method.

   Note

   You may already be familiar with configuring ConfigMgr_DViewAccess if you have previously set up Configuration Manager access for older versions of Content Distribution Dashboard which used ActiveEfficiency Server, or the ActiveEfficiency Scout, as used for AppClarity 5.x or Shopping 5.x and 6.0

   The existence of the ConfigMgr_DViewAccess localgroup depends on the version of Configuration Manager. It should exist for a Primary Site, but may not exist for a CAS. If it does not already exist, it is safe for you to manually create the localgroup on the SQL Server used by the Configuration Manager database. If it already exists, you will need to confirm it has a SQL Login and all the necessary rights, as the Configuration Manager setup does not always configure this group correctly.

   The following SQL script can be used to create a SQL Login for ConfigMgr_DViewAccess and grant it permissions on the Configuration Manager database. Before you run the SQL script, you must first:

   • Manually create the localgroup on the SQL Server

   • Add the Tachyon server's computer$ account to the localgroup.

   Click here to download - ConfigMgr_DViewAccess_permissions.SQL

   ConfigMgr_DViewAccess_permissions.SQL

   -- Connect to the SQL instance using an account that has sysadmin rights.
   -- Execute this SQL script on the Configuration Manager database.
   -- The script creates a SQL Login on the instance for [hostname\ConfigMgr_DViewAccess]
   -- and grants it the following rights on the Configuration Manager database:
   -- [db_datareader]
   -- EXECUTE on [dbo].[fn_GetAppState]
   -- EXECUTE on [dbo].[fnGetSiteNumber]
    
   DECLARE @SqlLogin nvarchar(2000)
   DECLARE @SqlString nvarchar(max)
    
   SET @SqlLogin = CAST(host_name() AS varchar(512)) + '\ConfigMgr_DViewAccess'
   PRINT 'Granting permissions for ''' + @SqlLogin + ''' on database ' + DB_NAME() + ' ...'
    
   SET @SqlString = '
   IF NOT EXISTS ( SELECT schema_name FROM information_schema.schemata WHERE schema_name = '''+@SqlLogin +''' )
   EXEC (''CREATE SCHEMA [' + @SqlLogin + ']'')
   '
   EXEC sp_executesql @SqlString
    
   SET @SqlString = '
   IF NOT EXISTS (SELECT * FROM sys.server_principals WHERE name = '''+ @SqlLogin +''')
   CREATE LOGIN [' + @SqlLogin + '] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
   '
   EXEC sp_executesql @SqlString
    
   SET @SqlString = '
   IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = '''+ @SqlLogin +''')
   CREATE USER [' + @SqlLogin + '] FOR LOGIN [' + @SqlLogin + '] WITH DEFAULT_SCHEMA=[' + @SqlLogin + ']
   '
   EXEC sp_executesql @SqlString
   PRINT 'SQL Login created.'
    
   SET @SqlString = '
   ALTER ROLE [db_datareader] ADD MEMBER [' + @SqlLogin + ']
   GRANT EXECUTE ON [dbo].[fn_GetAppState] TO [' + @SqlLogin + '] AS [dbo]
   GRANT EXECUTE ON [dbo].[fnGetSiteNumber] TO [' + @SqlLogin + '] AS [dbo]
   '
   EXEC sp_executesql @SqlString
   PRINT 'Permissions granted.'
   

   When you run 1E Server Setup, the Content Distribution screen will attempt to validate the existence of the ConfigMgr_DViewAccess localgroup and membership of the Content Distribution server's computer$ account. The validation test will fail if the installation account does not have sysadmin rights on the SQL Server instance used by Configuration Manager. This is not a fatal error as long as you are sure the computer$ account is a member of the ConfigMgr_DViewAccess localgroup.

If the connector is using a SQL Login, then create the login on the Configuration Manager database and grant it the above rights.