MS SQL Server users

Forum Moderators: open

Message Too Old, No Replies

MS SQL Server users

Cannot see all users

rayw

5:25 pm on Oct 30, 2008 (gmt 0)

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

6:15 pm on Oct 30, 2008 (gmt 0)

What account are you using to connect through Enterprise Manager?

rayw

6:25 pm on Oct 30, 2008 (gmt 0)

I have it set to use the System Account

LifeinAsia

6:34 pm on Oct 30, 2008 (gmt 0)

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

6:49 pm on Oct 30, 2008 (gmt 0)

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

6:57 pm on Oct 30, 2008 (gmt 0)

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

7:07 pm on Oct 30, 2008 (gmt 0)

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

9:17 pm on Oct 30, 2008 (gmt 0)

It would not let me use sa

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

aspdaddy

10:27 pm on Nov 1, 2008 (gmt 0)

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.