3.6.0 Matrix Server Release Notes (5697-7087, February 2008)

PolyServe Matrix Server Release Notes 24

11133 SQL instance cannot be joined to domain while the instance is

virtualized

After a SQL instance is virtualized, it cannot be joined to the

domain.

Workaround. Complete the following steps:

1. Log into the domain controller.

2. Open “Active directory users and computers.”

3. Ensure that the SQL Server account is configured as follows:

a. The “Account is sensitive and cannot be delegated” check

box must not be selected. The “service Account is trusted

for delegation” check box must be selected.

4. Create a computer object in active directory for the virtual

name of your Virtual SQL Server.

5. Select the “Trusted computer for delegation” check box for

the server running an instance of Microsoft SQL Server.

6. Download the setspn.exe utility from Microsoft and install

it.

7. Create a registry SPN for SQL Server in active directory

using the setspn command:

setspn -A MSSQLSvc/Host:port serviceaccount

For example:

C:\setspn>setspn -A MSSQLSvc/vsql2.px.ps.com 40006

Administrator

Registering ServicePrincipalNames for

CN=Administrator,CN=Users,DC=px,DC=ps,DC=com

MSSQLSvc/vsql2.px.ps.com:40006

Updated object

You can now join the SQL instance to the domain.

Bug

Description