Re: SA can not create users

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

.

Relevant Pages

  • Detecting secureables in SQL 2005/2008
    ... It is easy to run a query to see which logins, if any are in the sysadmin ... But how do you detect logins that have been granted effective permission to ... for that in SQL 2005/2008? ...
    (microsoft.public.sqlserver.programming)
  • Re: Changing security authentication type.
    ... i'm thinking that yes in time the sa account will ... Create one or more logins for the applications. ... for each database. ... , you really have no security for your ...
    (microsoft.public.sqlserver.security)
  • Re: Server 2003 Group Policies - Affecting Administrative Profile
    ... If I was you I would remove TS Access rights from the Administrator account ... office" logins as well as remote logins. ...
    (microsoft.public.windows.server.general)
  • Re: SQLDTS Transfer File Task
    ... E.g. 20 logins. ... run the logins expire in 5 days. ... Can anyone confirm whether SQLDTS transfer File task uses a single ... I would like the account to last as long as possible (its not actually ...
    (microsoft.public.sqlserver.dts)
  • Re: Account Login
    ... > account. ... I have found several logins that were preceeded by login ... can get into a computer running any operating system. ...
    (microsoft.public.windowsxp.security_admin)