sql server connect: I need help on this one.
I have 1 instance of SQL7.0 with SP2 and several SQL2000
with SP3 on 1 Server. Using SQL2000 Enterprise Manager, I
login from my client using the DBO login for a certain
database.

When expanding the Database, I could not see any
databases, sometimes using Refresh (F5) does the trick,
sometimes not. And I do notice that my ODBC could not
even see the databases using some of these DBO logins.

But using sa, I have not problem at all. Can anyone
advise me pls? My email is shihtzu13sg@yahoo.com

Thanks

DBO is not a login name, it is a user name in a database. Please read about
logins and user names in the Books Online.

A login name is used to log in to your SQL Server. When you then use a
particular database, whatever login you used is mapped to a user name in the
dataase (if you have access to the database). If you login as 'sa', your
user name in every database is automatically DBO, but you do not use DBO for
a login name. SQL Server just uses that as your user name inside a database.

If you have created a login name DBO there will be nothing special about it.

Can you please clarify if you are really logging in as DBO. If so, open a
query window, use one of the databases you are having problems with, and
run:

exec sp_helpuser

and let us know what result you are getting.


--
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com


[quoted text, click to view]