3.4.3 MxDB for SQL Server Installation and Administration Guide

Chapter 2: Install SQL Server 39
Copyright © 1999-2007 PolyServe, Inc. All rights reserved.
Requirement for BUILTIN\Administrators Group
PolyServe uses Windows authentication (LocalSystem) to connect to SQL
Server to make changes. This means that the BUILTIN\Administrators
local NT group should be enabled on the primary instance and be part of
the SQL Server SysAdmin role. If the BUILTIN\Administrators group
must be removed from SQL Server, the following script must be run to
explicitly allow LocalSystem account access to SQL Server.
-- Giving LocalSystem account access to sqlserver
IF NOT EXISTS (SELECT * FROM master.dbo.syslogins WHERE
loginname = N'NT Authority\System')
EXEC sp_grantlogin N'NT Authority\System'
GO
-- Set default database
EXEC sp_defaultdb N'NT Authority\System', N'master'
GO
-- Add LocalSystem to SQL SysAdmin group
EXEC sp_addsrvrolemember N'NT Authority\System', N'sysadmin'
GO
--CHECK SYSLOGINS after adding LocalSystem Acct
SELECT name FROM master.dbo.syslogins
GO
TCP/IP Assignments on Backup Nodes
The TCP/IP port selected for a SQL Server installation on a primary node
must also be available on the backup nodes for the associated Virtual SQL
Server. When you are installing SQL Service on a backup node, verify that
no other applications are currently using that port. To see the port
assignment for a SQL Server, select Programs > Microsoft SQL Server >
Server Network Utility. Then, on the SQL Server Network Utility
window, click on TCP/IP. The port assignment will then be displayed.
You can change the port assignment if necessary.