Even Sa account is in sysadmin role it is not able to create users using enterprise manager
Also not able to create users from local admin who is alo on sysadmin role
But using query analyzer we can create users
Re: SQLServerAgent Service ... These are the minimum requirements to run the SQL agent and SQL services ... It is my understanding that I need to use the same account to launch ...SQLServerAgent reports the following error when attempting to start... ...internal SQL SysAdmin role it works fine... ... (microsoft.public.sqlserver.security)
Best Practice - BuiltinAdministrators SQL account - Im confused ... but MBSA reports that it is part of the sysadmin role... of people are going so far as to remove the account altogether from SQL ... we intend for two of them, the DBA and the senior sys admin, to have access - ... two staff.... (microsoft.public.sqlserver.security)
Re: SQL Server ... It is true that in order to apply, for example, a service pack to SQL Server... one has to login as a member of the sysadmin role,... The "sa" login is useful only when SQL ... > which the sa account was being used was inappropriate. ... (microsoft.public.sqlserver.security)
Schedule a DTS package ... I know that I have to schedule a DTS package under an account which is in ...sysadmin role in order not to face security problems.Dose sysadmin role mean ... What type of account you guys use for you oleDBConnections insode the ... (microsoft.public.sqlserver.dts)
Re: SQLServerAgent Service ... > member of the sysadmin role... ... > But that kind of contradicts the best practice that the account that sql ... > What is the point of changing the sql service accounts if the account used ... > The MSSQLServer Service does not have to be a member of the Sysadmin role... (microsoft.public.sqlserver.security)
