Post reply

Unable to see complete list of users with client tools.

  • January 24, 2008 at 8:26 am

    #76885

    I have sql server 2000 enterprise edition installed on sever A. Database1 is on server A. I have installed sql sever 2000 standard edition client tools only on sever B. On server A, when I run enterprise manager and drill down the object list for Database1 and look at the users I see all users associated with the database. On server B, when I run enterprise manager and drill down the object list for Database1 and look at the users I do not see all the users associated with the database, but I can use query analyzer select * from sysusers from server b and see all users associated with the database. What would be causing this problem?

  • January 24, 2008 at 8:40 am

    #771315

    This has the makings of a permissions issue are are both servers registered in EM using the same user name?

    Facts are stubborn things, but statistics are more pliable - Mark Twain
    Carolyn
    SQLServerSpecialists[/url]

  • January 24, 2008 at 8:57 am

    #771324

    If you mean the user that can start and run sql server; then yes they are.

    The database has been moved from one server to another. The users I can see from enterprise manager on sever B have login Names. Could that make a difference.

    Thanks

  • January 24, 2008 at 9:12 am

    #771342

    You could have orphaned users (no mapped login). Run sp_change_userslogin to see what the issues are. Look up the report switches in books online.

  • January 24, 2008 at 10:07 am

    #771390

    Thanks Steve that was it.

    I appreciate yours and Carolyn’s suggestions.

    Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply