Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2002
    Posts
    2

    Red face Unanswered: sa can not start SQL Server Agent!

    Hi

    Need help. I cant start SQL Server Agent by using sa. It will run if I use windows autho!

    Any ideas?

    Thanks
    Ly

  2. #2
    Join Date
    Apr 2002
    Posts
    16
    Check if the user 'sa' exists by running from QA:
    use yourDB( use Master to find out the opt for SQL Agent permissions)
    go
    select master..syslogins.name as login_name,
    sysusers.name as user_name
    from master..syslogins inner join sysusers
    on master..syslogins.sid = sysusers.sid

    It probably was deleted, so create that user or a more specific login.
    Last edited by elel; 04-10-02 at 17:41.

  3. #3
    Join Date
    Apr 2002
    Posts
    2

    Did not help

    Hi,

    Thanks for your answer. Sa exists and I cant logon with it unless I change the sa password to empty string.

    The problem is that I cant use Indexing services, when I try a search I got unspecified error. And I get the following msg when I try to full text search

    Server: Msg 7619, Level 16, State 1, Line 1
    Execution of a full-text operation failed. Unspecified error

    Greatfull for any help.
    /Ly

  4. #4
    Join Date
    Apr 2002
    Posts
    16
    I had the same problem several months ago, I remember the problem was with permissions.
    check the link below: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q308787

    Also, it looks like your 'sa' account does not have a password. Why don't you use some distinctive account and rid of banal 'sa'? Establish an account with permissions and pass, verify everything, syncronize accounts throughout the servers you use, etc.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •