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

Troubleshooting

This chapter describes the following issues:

• Install/uninstall issues:

– SQL Server 2005 installation takes too long

– Installations via a Microsoft Terminal Services client

– Installer reports a failure

– Uninstall problems

• Connection issues:

– DNS misconfiguration causes Virtual SQL Server connection to fail

– Connection error with Windows authentication

– Windows authentication fails with SQL Server replication

– Client receives error when connecting via an alias

– Cannot authenticate on local machine with virtual hostname

• Error when creating a Virtual SQL Server

• An attempt to virtualize a SQL Server instance fails with the error “A

member could not be added to or removed from the local group

because the member does not exist”

• Cannot access a Virtual SQL instance from the active node

• SQL Server 2005 instance does not start

• Error when creating a distributor for replication

• MS DTC is not configured for Windows 2003