Re: SA can not create users

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
.

Relevant Pages

  • Re: Client tools installation
    ... Your client tools should at least match the server, ... running SPx, I would update the client tools to SPx as well. ... Analyzer or Enterprise Manager? ...
    (microsoft.public.sqlserver.setup)
  • Re: Can both SQL 2000 and 2005 exist on the same Windows 2000 Server
    ... If you have SQL Server 2000 client tools on the machine you may find ... that Enterprise Manager throws a wobbly. ... >We have only one test server at our disposal and I was wondering if both SQL ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server Management Studio is one of the worst UIs I have de
    ... > migration. ... > tools I see no reason to upgrade. ... > have the "latest and greatest" version of SQL server. ... back-end benefit, you're right, that the client tools could play into the ...
    (microsoft.public.sqlserver.clients)
  • Re: sql server 2000 tools
    ... First you need to register production server with your username and password ... You don't need to access *.ldf files ... Then you should do a Transaction Log backup from Enterprise Manager. ...
    (microsoft.public.sqlserver.tools)
  • Re: Linked Server (Oracle 9i)
    ... >enterprise manager registration properties if you are using sa or windows ... >> Microsoft ODBC for Oracle ... >> When I try to connect to the linked server in Enterprise Manager I get ...
    (microsoft.public.sqlserver.odbc)
Loading