PRB: 'Unable to Connect' Message with SEM Object Transfer (159232)
The information in this article applies to:
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.
| Modification Type: | Major | Last Reviewed: | 10/3/2003 |
|---|
| Keywords: | kbprb kbusage KB159232 |
|---|
|