3.6.0 MxDB for SQL Server Installation and Administration Guide (5697-7088, December 2007)

Chapter 3: Install SQL Server Instances 33
Copyright © 1999-2007 PolyServe, Inc. All rights reserved.
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.