MS SQL Server users

Cannot see all users

[rayw]

Hi,

I am connecting to one of my SQL Servers from my local machine using Enterprise Manager. I'm able to view all the databases on the server, however, when I try to view the users through my local machine I am unable to view all the users. I know they are there, because I can see them if I logon directly through the machine the SQL Server is located on. Any ideas?

Thanks.

[LifeinAsia]

What account are you using to connect through Enterprise Manager?

[rayw]

I have it set to use the System Account

[LifeinAsia]

And what account are you using on the SQL Server? (Not the account to logon to the Windows server, but the account you use to logon to Enterprise Manager.) And what version of SQL & Windows are you running?

[rayw]

I'm using SQL Server 2000 and Windows Server 2003. On my local machine, i'm running Windows XP.

When I check the SQL Server Properties from Enterprise Manager it says the Startup service account is the System account.

[LifeinAsia]

Just for "fun" try setting up a new connection on the XP to the server and use a different logon. Preferably, use a SQL account with higher rights (sa, if you know the password).

[rayw]

It would not let me use sa, but i specified another account that should have enough rights, and i still don't see the users.

[LifeinAsia]

It would not let me use sa

Not sure I understand. Are you getting some sort of error?

[aspdaddy]

Are you using EM on a different domain to the SQL server? If so its normal as you cant use Windows authentication.

The users are stored in the master.mdf,it likely that you dont have permission on that database. You need to RDC into the Windows 2003 as the Adminsitartor & then logon to SQL using Windows authentication.