EM access error when DB name is a GUID

I am receiving a connection error when I use EM to try to
open a table is my database. I am connecting to SQL Server
as a SA user. I don't have any access errors if I use
Query Analyzer. The problem occurs trying to access tables
in a database that has a GUID for the database name
{910216B1-6186-4F13-A626-D1D4D811F3B1} The brackets are
part of the name. Any GUID name will fail. All other EM
functions work correctly. EM works correctly for all non-
GUID named databases.
The error message is "Connection failed: SQLState '08004'
SQL Server Error: 4060 Server rejected the connection;
Access to selected database has been denied.
I am running SQL Server 2000, version 8.00.818 on a
Windows 2000 server system with SP 4. The same thing
happens on a Windows XP Pro system running SQL Server 2000
Tobin Schuster wrote:
> I am receiving a connection error when I use EM to try to
> open a table is my database. I am connecting to SQL Server
> as a SA user. I don't have any access errors if I use
> Query Analyzer. The problem occurs trying to access tables
> in a database that has a GUID for the database name
> {910216B1-6186-4F13-A626-D1D4D811F3B1} The brackets are
> part of the name. Any GUID name will fail. All other EM
> functions work correctly. EM works correctly for all non-
> GUID named databases.
> The error message is "Connection failed: SQLState '08004'
> SQL Server Error: 4060 Server rejected the connection;
> Access to selected database has been denied.
> I am running SQL Server 2000, version 8.00.818 on a
> Windows 2000 server system with SP 4. The same thing
> happens on a Windows XP Pro system running SQL Server 2000
Since the name you are using contains invalid characters, it must be
delimited. I'm guessing that SQL EM is not putting brackets around the
name to get past this.
David Gugick
Imceda Software
www.imceda.com