the domain computer account of the cache server to authenticate remotely to the computer running SQL Server. If the cache server installation was occurring on the same physical computer as the SQL Server, this example would have to change and use NT AUTHORITY\Network Service instead of CorporateDomainName\CacheServerComputerName$. Note The installation program only supports Windows Authentication when creating SQL Server logins. -- create for cache host service CREATE LOGIN [CorporateDomainName\CacheServerComputerName$] FROM WINDOWS WITH DEFAULT_DATABASE=[CacheConfigDatabase] GO -- create user account for host service USE [CacheConfigDatabase] GO CREATE USER [CorporateDomainName\CacheServerComputerName$] FOR [CorporateDomainName\CacheServerComputerName$] -- permissions for cache host service EXEC sp_addrolemember N'db_datareader', N'CorporateDomainName\CacheServerComputerName$' EXEC sp_addrolemember N'db_datawriter', N'CorporateDomainName\CacheServerComputerName$' GRANT EXECUTE TO [CorporateDomainName\CacheServerComputerName$] GO The following is an example of the SQL Server script that needs to run for the security identity of the person performing the Distributed Cache installation. System administrator permissions are required because the installation program attempts to create new accounts in the instance of SQL Server for each of the cache servers. In this example, the name of the security identity used by the person performing the cache server installations is PersonInstallingCacheServer. That security identity is a member of the corporate domain named CorporateDomainName. The name of the database used to store the cluster configuration settings is CacheConfigDatabase. -- create login for security identity of person installing
the domain computer account of the cache server to authenticate remotely to the computer running SQL Server. If the cache server installation was occurring on the same physical computer as the SQL Server, this example would have to change and use NT AUTHORITY\Network Service instead of CorporateDomainName\CacheServerComputerName$. Note The installation program only supports Windows Authentication when creating SQL Server logins. -- create for cache host service CREATE LOGIN [CorporateDomainName\CacheServerComputerName$] FROM WINDOWS WITH DEFAULT_DATABASE=[CacheConfigDatabase] GO -- create user account for host service USE [CacheConfigDatabase] GO CREATE USER [CorporateDomainName\CacheServerComputerName$] FOR [CorporateDomainName\CacheServerComputerName$] -- permissions for cache host service EXEC sp_addrolemember N'db_datareader', N'CorporateDomainName\CacheServerComputerName$' EXEC sp_addrolemember N'db_datawriter', N'CorporateDomainName\CacheServerComputerName$' GRANT EXECUTE TO [CorporateDomainName\CacheServerComputerName$] GO The following is an example of the SQL Server script that needs to run for the security identity of the person performing the Distributed Cache installation. System administrator permissions are required because the installation program attempts to create new accounts in the instance of SQL Server for each of the cache servers. In this example, the name of the security identity used by the person performing the cache server installations is PersonInstallingCacheServer. That security identity is a member of the corporate domain named CorporateDomainName. The name of the database used to store the cluster configuration settings is CacheConfigDatabase. -- create login for security identity of person installing
InstallationGuide.docx