To continue, provide valid credentials for the SQL Server Agent Service

This was driving me crazy. We’re performing a fresh installation on a fresh server; Microsoft Office SharePoint Server 2007 on a Windows Server 2008. I’ve reached the part of the installation where I’m installing SQL Server 2008. No matter what I put in for the UserName, I’d get the error “Invalid or missing username or password. To continue, provide valid credentials for the SQL Server Agent service.”

Looking at the forums, it wasn’t just me. Several people provided answers or reporting not having any issue, but it was obvious, from the continuous pleas for help, that the responses weren’t providing the help asked for. Maybe they’re like me; I need pictures. So here’s my error:

Peter Saddow from MSFT listed the answer, but it took me a few tries to understand it.


 invalid or missing username or password. To continue, provide valid credentials for the SQL Server Agent Service – MSDN Forums

I suppose won’t know until later if this was completely the correct action to take, but it did get me beyond this screen, which after umpteen tries is all I really wanted at this point:

About these ads

31 Responses to To continue, provide valid credentials for the SQL Server Agent Service

  1. Matthew says:

    Thanks! Got me past that screen too… :-)

  2. Sunkavalli says:

    thanks a lot!..got past that frustrating screen! :-)

  3. sharepointdiva says:

    Glad to be of help!

  4. Murat says:

    thanks mate
    thats been annoying me!!
    i’ve done it through your help
    thnaks again

  5. Dave Reeder says:

    Thanks, that was driving me nuts!

  6. saran says:

    HI,

    thank you very much, i was struggling to pass through that screen for hours….

    Thank a ton , grt work

    Saran

  7. kattie says:

    I just looooooooove you :)

    mmmm I feel really dumb right now lolol

  8. Anonymous says:

    Thanks Buddy

  9. Brett says:

    Thanks, much appreciated!

  10. aditya says:

    could u mention why do we need to provide that user name… i mean what is the significance

  11. Paul TAN says:

    Thanks a lot
    It was very helpful!!!

  12. Menon says:

    Thanks a lot. This installation of SQL Express has become a real nightmare.
    I was almost to give up.

  13. zain says:

    thanks bro.

  14. There is obviously a lot to learn. There are some good points here.

    -Robert Shumake

  15. thavaht says:

    Real! It was a nightmare until i find this article. Thanks a lot.

    thavaht

  16. Jason G says:

    Thanks so much. This helped me install sqlserver 2008 at work.

  17. Anonymous says:

    I can’t believe they can’t make a useful error message!

    Lifesaver there :)

  18. Raghu says:

    Thanks a lot. Your posting here helped me out to complete the installation.

  19. Frank says:

    Well sadly I’m still stuck. I’m installing on Win7 and have tried
    - No user/pass
    - My user/pass
    - My user with domain and pass
    - Administrator with no pass

    No joy. What should I use?

    • sharepointdiva says:

      You have to install on a server (SharePoint Server 2007 runs on Windows Server 2003 with SP1 or later). Win7 is never going to give you any joy.

  20. Christina says:

    Thank you SOOOO MUCH…I need this program for a class I am taking and for the life of me could not get passed that screen!!!

  21. Syed Wajahat says:

    One of the best way of handling this is to install it with a local account first.

    Once SQL Server installed, now you can change the service account by changing the user at services.msc

    Change the service account, stop & start it. Its now working with your service account.

    Thanks.
    Syed Wajahat
    Principal Consultant
    Techerz.

    SharePointGulf

  22. sara says:

    thanks alooooooooot

  23. Parameshwar says:

    Thanks a Lot

  24. Anonymous says:

    Its 09/2011 and your time & effort to create this post is still helping………………………..thankyou

  25. JOE says:

    Excelente, me ayudó mucho este articulo!

  26. can’t say how much i thank you ,
    i don’t understand why working on ms always is that hard
    thank to people like you we can go one
    thanks

  27. marwa moaz says:

    thnx it fifxs the error and everything is ok

  28. Anonymous says:

    On parallels, I just made a new account ‘Admin’ and added a password. The default ‘Administrator’ account wouldn’t let me set a password.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 127 other followers

%d bloggers like this: