|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Jobs cannot running
SQL 2005 SP3 I have an issue concerning the server security, I do not need any windows authentication (I know that is not recommended). Anyhow, SQL server agent does not run any jobs that defined on that server coz I deleted all associated windows users. In older version (2000), I always delete windows users, only sql users exists. and configure the sql agent to run by "sa" in the connection tab in SQL Server Agent. which is disabled in SQL 2005. I need to enable SQL authentication for SQL agent property, and delete windows users. Can you help me on this.... -- Mahmoud Amin SQL Agent runs as a Windows service, which knows nothing about SQL
authentication. What Windows account is the SQL Server service running as? On 6/21/09 10:07 AM, in article D4D809F4-CA87-4242-943E-05D3BDE4F***@microsoft.com, "m_ami***@hotmail.com" <m_ami***@hotmail.com> wrote: Show quoteHide quote > Hi All, > > SQL 2005 SP3 > > I have an issue concerning the server security, I do not need any windows > authentication (I know that is not recommended). > Anyhow, SQL server agent does not run any jobs that defined on that server > coz I deleted all associated windows users. > In older version (2000), I always delete windows users, only sql users > exists. and configure the sql agent to run by "sa" in the connection tab in > SQL Server Agent. > which is disabled in SQL 2005. > > I need to enable SQL authentication for SQL agent property, and delete > windows users. > > Can you help me on this.... Thanks Aaron for quick response,
SQL server service running as local administrator -- Show quoteHide quoteMahmoud Amin "Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message news:C663B93E.1D86C%ten.xoc@dnartreb.noraa... > SQL Agent runs as a Windows service, which knows nothing about SQL > authentication. What Windows account is the SQL Server service running > as? > > > On 6/21/09 10:07 AM, in article > D4D809F4-CA87-4242-943E-05D3BDE4F***@microsoft.com, "m_ami***@hotmail.com" > <m_ami***@hotmail.com> wrote: > >> Hi All, >> >> SQL 2005 SP3 >> >> I have an issue concerning the server security, I do not need any windows >> authentication (I know that is not recommended). >> Anyhow, SQL server agent does not run any jobs that defined on that >> server >> coz I deleted all associated windows users. >> In older version (2000), I always delete windows users, only sql users >> exists. and configure the sql agent to run by "sa" in the connection tab >> in >> SQL Server Agent. >> which is disabled in SQL 2005. >> >> I need to enable SQL authentication for SQL agent property, and delete >> windows users. >> >> Can you help me on this.... > Well that's not exactly best practice either. Can you explain why SQL Agent
can't run under the "NT Authority\Network service"? On 6/21/09 10:22 AM, in article 61009F2F-64FD-4291-BB78-DB709C585***@microsoft.com, "m_ami***@hotmail.com" <m_ami***@hotmail.com> wrote: Show quoteHide quote > Thanks Aaron for quick response, > > SQL server service running as local administrator You can't, per SQL2005 documentation:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/8f5017df-29b3-4164-a02b-ac8e8785040d.htm "In SQL Server 2005, SQL Server Agent does not support SQL Server Authentication. This option is available only when you administer an earlier version of SQL Server." Linchi Show quoteHide quote "m_ami***@hotmail.com" wrote: > Hi All, > > SQL 2005 SP3 > > I have an issue concerning the server security, I do not need any windows > authentication (I know that is not recommended). > Anyhow, SQL server agent does not run any jobs that defined on that server > coz I deleted all associated windows users. > In older version (2000), I always delete windows users, only sql users > exists. and configure the sql agent to run by "sa" in the connection tab in > SQL Server Agent. > which is disabled in SQL 2005. > > I need to enable SQL authentication for SQL agent property, and delete > windows users. > > Can you help me on this.... > > -- > Mahmoud Amin > > > >  
Other interesting topics
change date from Mon dd yyyy
HELP, RAN OUT OF DISK SPACE How to narrow down the failure message Backup and restore sql server 2005 Query is much slower in 2008 than in 2005 c2 files/sysxmitqueue SQL Server 2005 database monitoring SQL 2008 not starting Sql Server Shared Hosting Active/Active cluster with bcv disks |
|||||||||||||||||||||||
