SA can not create users

[sanjitg via SQLMonster.com]

Even Sa account is in sysadmin role it is not able to create users using
enterprise manager
Also not able to create users from local admin who is alo on sysadmin role
But using query analyzer we can create users

Is some thing wrong with master database

Sanjit

[Simon Hayes]

If it works correctly from Query Analyzer, then the problem is most
likely Enterprise Manager, but you don't say exactly what happens - is
there an error message? If you haven't applied the latest MSSQL
servicepack (SP4) to your client, then that would be worth a go - if
that doesn't help, then you could try uninstalling and reinstalling the
client tools completely.

Even if you fix the problem, I would continue to work with QA for this
purpose, because then you can save your admin scripts, put them in
source control, run them against multiple servers and databases etc. EM
is certainly useful, but QA is preferable for many tasks:

http://www.aspfaq.com/show.asp?id=2455

Simon

[sanjitg via SQLMonster.com]

Yes i have SP4 installed
In security—logins when you right click to create new login that option is
disabled
I am not able to se properties of existing users
There is no error msg or error number

I also thought it may be enterprise manager but if I register different
server on same enterprise manager I am able to create users for that new
server
Sanjit
Simon Hayes wrote:

If it works correctly from Query Analyzer, then the problem is most
likely Enterprise Manager, but you don't say exactly what happens - is
there an error message? If you haven't applied the latest MSSQL
servicepack (SP4) to your client, then that would be worth a go - if
that doesn't help, then you could try uninstalling and reinstalling the
client tools completely.

Even if you fix the problem, I would continue to work with QA for this
purpose, because then you can save your admin scripts, put them in
source control, run them against multiple servers and databases etc. EM
is certainly useful, but QA is preferable for many tasks:

http://www.aspfaq.com/show.asp?id=2455

Simon

[Simon Hayes]

It sounds as if the server was registered in EM with a non-sysadmin
account, but I assume you've already checked that? You might try
removing the registration and re-creating it with a sysadmin account,
just to be sure.

Simon

[dbahooker]

do you have SP4 installed on the client AND the server?

you need that right?

[sanjitg via SQLMonster.com]

i try to reregiter server using local admin and Sa account
and both accounts are in sysadmin
and i have sql 7 with sp4 on server and i am trying this directly on server

Simon Hayes wrote:

It sounds as if the server was registered in EM with a non-sysadmin
account, but I assume you've already checked that? You might try
removing the registration and re-creating it with a sysadmin account,
just to be sure.

Simon

[Simon Hayes]

If you're absolutely sure that the registration is using a sysadmin
account, then I have no idea why you can't create logins. Can you do
other sysadmin tasks successfully in EM, such as creating scheduled
tasks owned by sa?

It may be a bug of some sort, but if so it's very unlikely that you'll
find a fix - there will be no mainstream support available for SQL 7
from the end of this year. And since you can manage logins from QA
anyway, it's probably not a critical issue.

Simon

[sanjitg via SQLMonster.com]

i also saw sp_columns was not working
there are other admin function i was not able to do

so i did rebuild master database and it worked out fine
Simon Hayes wrote:

If you're absolutely sure that the registration is using a sysadmin
account, then I have no idea why you can't create logins. Can you do
other sysadmin tasks successfully in EM, such as creating scheduled
tasks owned by sa?

It may be a bug of some sort, but if so it's very unlikely that you'll
find a fix - there will be no mainstream support available for SQL 7
from the end of this year. And since you can manage logins from QA
anyway, it's probably not a critical issue.

Simon

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...neral/200509/1