Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SQL Login User Permission

2 views
Skip to first unread message

Hemant

unread,
Nov 24, 2009, 11:14:12 AM11/24/09
to
Hi ,

I have a problem.
I have two sql server . If I login to one server and go to tab
Security-->Login In one server I can see all the user
but in the other server i can see only two server .
Is there any permission issue or anything else.
Please help me

Thanks,
Hemant


Erland Sommarskog

unread,
Nov 24, 2009, 5:35:04 PM11/24/09
to
Hemant (Hem...@nomail.com) writes:
> I have a problem.
> I have two sql server . If I login to one server and go to tab
> Security-->Login In one server I can see all the user
> but in the other server i can see only two server .
> Is there any permission issue or anything else.

Could be. Are you the administrator for both servers? Should you see all
logins? What version of SQL Server are you using? In what tool do you go
this tab?


--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Hemant

unread,
Nov 25, 2009, 1:21:41 AM11/25/09
to
Hi,
Thanks for your reply.
I am working on SQL server 2005 .
Yes he is admin for both server.
I go to sql server management studio -->Server-->Security-->Login.
On one server i can see all the user but at the other server i am not able
to see all login name?

thanks ,
Hemant

"Erland Sommarskog" <esq...@sommarskog.se> wrote in message
news:Xns9CCDEFF1B...@127.0.0.1...

Uri Dimant

unread,
Nov 25, 2009, 1:54:05 AM11/25/09
to
Hemat
Hmm, that is strange, are you sure that both edition are the same and have
SP , just guessing....

Are you sure you are connecting to the the second one with admin
permissions?


"Hemant" <Hem...@nomail.com> wrote in message
news:OYSMecZb...@TK2MSFTNGP02.phx.gbl...

Erland Sommarskog

unread,
Nov 25, 2009, 5:40:42 PM11/25/09
to
Hemant (Hem...@nomail.com) writes:
> Thanks for your reply.
> I am working on SQL server 2005 .
> Yes he is admin for both server.
> I go to sql server management studio -->Server-->Security-->Login.
> On one server i can see all the user but at the other server i am not able
> to see all login name?

On both servers, open a query window and run:

SELECT is_srvrolemember('sysadmin')

Does it return 1 on both servers?

How do you login? Windows Authentication or SQL Authentication?

0 new messages