You are here: Re: SA can not create users « MsSQL Server « IT news, forums, messages
Re: SA can not create users

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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация