Posted by sanjitg via SQLMonster.com on 09/28/05 16:29

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

• Next in forum: Re: SA can not create users
• Prev in forum: Re: SA can not create users
• Thread view: Re: SA can not create users

[Reply to this message]