Re: Enterprise Manger Crash Creating user



Patrik
Open Query Analyzer and use
sp_adduser ,sp_dropuser system stored procedures






"Patrick" <Patrick@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:899B491A-819F-4435-9CF5-6E5EB47BB13C@xxxxxxxxxxxxxxxx
Please can you help with this?

I created a new users for the first time in SQL Server 2000. While
doing
that, Enterprise Manager crashed....and:

1. If I try to add the user again, I get an error because the User already
exists....yet I cannot see it on the console.
2. The user name does not show under Users (or Roles)

Any idea what I need to do to fix it - or what I might be doing wrong???
Is there a problem with Enterprise manager, how can it be fixed? (Looks
to
me like it fails while waiting for a response from NT...)




.



Relevant Pages

  • Re: Error when refreshing Taskpad view
    ... I recall that being a bug.....??? ... > When the view of a database in Enterprise Manager has been ... > a script error reported the first time. ...
    (microsoft.public.sqlserver.tools)
  • invalid value specified for STOPAT parameter
    ... I too had problems when trying to perform a Point in Time restore ... Enterprise Manager, I receive a error message "Invalid value specified ... "YDM" by SQL Server where as the value supplied by the SQL Server ... Select "British English", then hit OK. ...
    (microsoft.public.sqlserver.server)
  • Re: Tools with/for Express
    ... Enterprise Manager does not work with SQL Server 2005. ... Analyzer is pretty dumb and just passes on what you type, ... But Enterprise Manager tries to write it's own code and it doesn't use SQL ... I then attempted to use Query Analyzer. ...
    (microsoft.public.sqlserver.tools)
  • Re: Replication problems
    ... machine than SQL Server as you must reference a share on the machine and not ... You can't create a publication due to the 1038 error. ... > not yet have any Publications in my Enterprise Manager. ... > start the SQL Server Agent service manually". ...
    (microsoft.public.sqlserver.ce)
  • Re: MSSQL$MSFW :: How to connect to it with SQL Server Enterprise Manager?
    ... > The question is - can I connect to this instance with either SQL Server ... The firewall MSDE is a SQL 2000 instance. ... W3WALL\MSFW as the SQL Server in Enterprise Manager. ... Install the client tools on the firewall, login as ...
    (microsoft.public.isaserver)