Can't see NT Groups

Question

Post reply

Can't see NT Groups

scoia

SSC Enthusiast

Points: 158
More actions
September 22, 2003 at 12:21 pm

#82262

My project partner and I both have system admin rights on a SQL Server. We did not set up the server nor this particular database we are looking at. However, when we look at the users of the database, he can see some users that I can't. These users do not have log-in names. Possibly when the vendor set up the database, they copied the database users, but not server log-ins. But why can he see them and I can't? Any thoughts on this? Thanks.

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

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

Steve Jones - SSC Editor SSC Guru Points: 736173 More actions · Answer 1

Shouldn't be any different. If you query syslogins, do you both seem the same rows?

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

Steven. SSCrazy Eights Points: 9806 More actions · Answer 2

I have seem this once before, and I seem to remember that doing an autofix on those accounts (sp_change_users_login) sorted them out.

Try running the stored procedure

sp_change_users_login 'report'

in the database, and see if they show up in the report.

Steven

scoia SSC Enthusiast Points: 158 More actions · Answer 3

My partner and I can both see the same users if we use a query to get them. However, where I'm not seeing them and he is is in the Enterprise Manager under Users for the database. We have this problem in a couple of databases on different servers.

I just logged onto the server through another computer and can see these users in Enterprise Manager that I can see on my computer. Is there a setting somewhere in SQL Server maybe that controls this as apparently it has nothing to do with my permissions?

Thanks so much for your help with this.

jamyer Default port Points: 1433 More actions · Answer 4

Is this a SQL 7 box you are viewing with EM? The SQL 7 tools don't show orphan users while the SQL 8/2000 tools do. So my guess would be you have the SQL 7 tools and your partner has the 8 tools.

scoia SSC Enthusiast Points: 158 More actions · Answer 5

I have SQL 8/2000. I had SQL 7 originally and then installed SQL 2000 and actually have both, but am using SQL 2000. My partner has the same exact installation.

I think I am going to reformat my computer and reinstall everything. I think it has to have something to do with my installation.