PRB: 'Unable to Connect' Message with SEM Object Transfer
Article ID: 159232
Article Last Modified on 10/3/2003
APPLIES TO
- Microsoft SQL Server 6.5 Standard Edition
This article was previously published under Q159232
SYMPTOMS
The Object Transfer methods exposed by the GUI interface in SQL Enterprise
Manager (SEM) may report either of the following errors:
- Unable to connect.
-or-
- The name 'My-Server' is not a valid object identifier, or not a valid
format for this property or method.
The Transfer facility will generate all the necessary scripts from the
source server, and it may report either of these errors when it attempts to
connect to the destination server.
CAUSE
SEM uses the SQL-Distributed Management Objects (DMO) to perform the
Transfer operations. The Transfer object contains the DestServer property.
When an attempt is made to set the value of DestServer, it is validated.
DestServer must be a valid SQL Server Identifier, or SEM will return the
error. See SQL Server Books Online for specific details on what makes a
valid SQL Server Identifier.
WORKAROUND
To work around this problem, use a valid SQL Server identifier for the name
of your destination server. This can be facilitated by placing an Advanced
Entry in the SQL Client Configuration Utility.
Keywords: kbprb kbusage KB159232