EM showing (No Items)

Having made no changes to the database server we are now getting no
database list when connecting via EM from client machines, as well as
locally on the database server. I've researched the problem to no
success. The database list shows up fine in QA, however. I used the
following script in QA:
use master
go
select * from sysdatabases
go
And this is the error message I received:
(36 row(s) affected)
Server: Msg 220, Level 16, State 1, Line 1
Arithmetic overflow error for data type smallint, value = 51805.
I saw a similar message when trying to delete an outdated Login
account.
Anyone have any ideas? Thanks in advance!
Jon Brookins
Paragon New Media, Inc.What version? Have you run DBCC CHECKDB recently?
"Jon Brookins" <jonathan@.pnmi.com> wrote in message
news:fa11c6b4.0310101200.58233742@.posting.google.com...
> Having made no changes to the database server we are now getting no
> database list when connecting via EM from client machines, as well as
> locally on the database server. I've researched the problem to no
> success. The database list shows up fine in QA, however. I used the
> following script in QA:
> use master
> go
> select * from sysdatabases
> go
> And this is the error message I received:
>
> (36 row(s) affected)
> Server: Msg 220, Level 16, State 1, Line 1
> Arithmetic overflow error for data type smallint, value = 51805.
> I saw a similar message when trying to delete an outdated Login
> account.
> Anyone have any ideas? Thanks in advance!
> Jon Brookins
> Paragon New Media, Inc.|||CHECKDB sounds like a good suggestion. Also, you might want to prepare yourself for restoring a
clean backup of the master database.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Jon Brookins" <jonathan@.pnmi.com> wrote in message
news:fa11c6b4.0310101200.58233742@.posting.google.com...
> Having made no changes to the database server we are now getting no
> database list when connecting via EM from client machines, as well as
> locally on the database server. I've researched the problem to no
> success. The database list shows up fine in QA, however. I used the
> following script in QA:
> use master
> go
> select * from sysdatabases
> go
> And this is the error message I received:
>
> (36 row(s) affected)
> Server: Msg 220, Level 16, State 1, Line 1
> Arithmetic overflow error for data type smallint, value = 51805.
> I saw a similar message when trying to delete an outdated Login
> account.
> Anyone have any ideas? Thanks in advance!
> Jon Brookins
> Paragon New Media, Inc.

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