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

Question

Hello:

 

I've got a problem at Server Configuration, I can't install SQL SERVER 2008 November CTP, because accounts for the SQL Server Agent Service, Database Engine Service and also for Reporting Service (Invalid user credentials for the Reporting Service service account) are invalids or missing. ????

 

I used the same account for all

 

Please help me.

 

 

Excuse me. My english isn't very good.

 

Thanks

 

Ralph

Answer 1

Moved to 2008 forum

Answer 2

I got this error when I provided credentials for my domain-user and the domain controller was not available.
When I connected my computer to my network again the credentials worked

Answer 3

Just for note,

I made my installation while I'm connected to the network and used my domain user for the Agent service and the SQL Engine service accounts.

And I did not get any problem during the installation. And also after the installation when I'm not connected to the network, CTP5 worked without a problem.

 

Eralper

http://www.kodyaz.com

 

Answer 4

 

I think the problem is invalid user name and pasword, first enter your domain username and password, then in database engine configuratin screen enter a strong user name and password.

 

 

Heba El-Desouky

Answer 5

hi friend did u find the solution becuse im having the same problem if u have solved it may u plz provide me some information
thank u

Answer 6

I'm having the same problem, though it says to provide valid credentials for the "Database Engine Service".  I'm on the SERVICE ACCOUNTS tab of the Sql Server Express 2008 install.  I have tried both individual and same account for all.

 

Only two services are shown - SQL Server (where I enter a strong id and password) and SQL Server Browser.  The SQL Server Browser is preset to username NT AUTHORITY\LOCAL SERVICE without a password shown.  I cannot edit this line.   I'm running Win XP Professional. 

 

Anyone have ideas?

Thanks,

Molly

 

Answer 7

Man, I have the same issues.  Even if I get past that screen using a combo of NT AUTHORITY accounts I get setup failed errors with the main SQL service and reporting services.  Frankly I really hate that screen and its totally useless.   I tried the good old command line to which works except that the services don't show in the config tool and the tools don't seem to install.  I'm using WinXP SP2.

 

Answer 8

1081

 

I used my current windows user id/password and it worked for me.

Answer 9

there are 2 screens, first one asks for your domain/windows username and password; and the next one "Data configuration "asks you to cchoose a user name and strong password for the database which can be any strong password.

Answer 10

EDIT: This is a reply to sm1908 above.

Didn't work for me.  The first one I tried didn't have a password, and when I changed that it still didn't do it.

 

Answer 11

Fourth screen in SQL Server 2008 installation is "Server Configuration" screen, in which two tabs are there.

1. Server Accounts

2. Collation

 

Under the tab "Service Accounts", There are two services

1. SQL Server (instance_name)

2. SQL Server Browser

 

For service "SQL Server (instance_name)", I entered my current windows UserID/Password. (Its strong)

For SQL Server Browser , "NT AUTHORITY\SYSTEM" is pre-entered.

 

I entered different UserID/Password. in the text-boxes below, which are under "Use Same Account for All".

 

I have done installation successfully second time this way only. Dont select "Apply to All". This changes UserID/Password for "SQL Server" service. which must be your windows User ID/Password.

 

 

Answer 12

 

Okay here is the solution.  What you will need to do to move on to the next screen will be to utilize your domain name and a user account in the following form: domain name\user.  For example, your domain name could read as: bigbiz and the user account you want to use is the administrator account.  So you will write on the account field, bigbiz\administrator please ensure to utilize the administrator password in the password field.

Answer 13

Jesus E Colon wrote:

Okay here is the solution.  What you will need to do to move on to the next screen will be to utilize your domain name and a user account in the following form: domain name\user.  For example, your domain name could read as: bigbiz and the user account you want to use is the administrator account.  So you will write on the account field, bigbiz\administrator please ensure to utilize the administrator password in the password field.

I had this error too, but solved until I find this post.
Thanks

Answer 14

Just use the windows account

Answer 15

Solution:
      you need use your current windows user id and password.

Answer 16

([e-mail]) writes: > Solution: > you need use your current windows user id and password. Or you could create a new Windows account. I would recommend this, as this account would only have the priviledges it needs (SQL Server Setup takes care of that). And you don't run the risk that SQL Server does not start one day because you have changed your password. -- Erland Sommarskog, SQL Server MVP, [e-mail] Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Answer 17

On the service configuration page, you need to specify a built-in account (NT Authority\System or NT Authority\Network Service) with no password needed, domain account with password, or local user account with a password. In a later CTP release, we will be improving the usability of this dialog. In the Database engine configuration page, you need to specify a strong password for the SA account if you use mixed-mode authentication and you need to provision a user within the database. You don’t need to specify a password for this account.

 

Thanks,

Peter Saddow [Microsoft]

 

Answer 18

This is absolutley appalling. I've tried everything on here and none theexamples have worked. Doesn't make good reading when your evaluating for a company.

I'm trying this at home and pulling my hair out over it. 1 day more of this and i'll recommend my company goes to Oracle!!

Answer 19

 

The explanation is not so clear.

 

It is great if you can provide real example for all fields (I'm working from user name "chess" no password and win xp sp2)

What could be the following fields (UserName/Password) in intallation screen "Server Configuration":

SQL Server Agent:

Sql Server[MSSQLSERVER]:

SQL Server Browser:

SQL Server Analysis Services:

Sql Server Reporting Services:

SQL Server Integration Services 10.0...:

 

Thank you in advance,

semsl

 

 

Answer 20

Never OutGunned wrote:

This is absolutley appalling. I've tried everything on here and none theexamples have worked. Doesn't make good reading when your evaluating for a company. I'm trying this at home and pulling my hair out over it. 1 day more of this and i'll recommend my company goes to Oracle!!

You are making evaluations from beta software? Please keep in mind that CTP5 is first CTP of SQL 2008 which uses the new Setup. It's not surprising if it's not perfect.

Then again, it's not that difficult at all. You specify a Windows login and a password for the service account. If you
don't have one handy, you add one. Or, if you are in a corporate environment, you ask your Windows admin to do it.

Answer 21

it works for me too!!

 

cool!

Answer 22

The same problem, but I can't solve it...

I've even create a new account with password...

But SQL have only one answer:

"Invalid or missing username or password. To continue, provide valid credentials for the SQL Server agent service"

"Invalid or missing username or password. To continue, provide valid credentials for the Database engine service"

"Invalid user credentials for the reporting services service account"

Before, I've always use MySQL server, and everything works excellent.

In hollywar between Linux and Windows, I always defend the Microsoft System...

But after installing IIS 7.0 and this problem I have a perfect right to change my mind.

Answer 23

It may seem like a dumb question: but did you check that you typed the password correctly?

The dialog is not really difficult at all. If you don't have a good Windows user in store, create one. Then enter
the username and password for that user for all services.

Answer 24

Hey! I am so frustrated. I still cant get the username and password valid.

Here is an example

Username: al3x\administrator
Password: ESKimo666
Startup Type: Automatic

I still cant get it! What's wrong?

Could it be on the step 3 that i have SQLEXPRESS as the "Named Instance" and on "Instance Id"?

Thanks!!

Answer 25

I'm encountering the same problem on a Windows 2008 domain server.  I used the NT AUTHORITY\LOCAL SERVICE account for all services, as opposed to accounts that I created, in order to temporarily work through the problem. 

Answer 26

Boy, this page was nearly killing me ... "Just enter a username, no password needed."

Not.

And all the time, just that stupid error bar at the top!

 

The real trap is, that keys for NT Autorithy accounts are localized! Thus, the second preset line reads:

 

SQL Server Browser

NT AUTHORITY\LOCAL SERVICE

 

but first line must be entered by starting typing N and then pick one of three options, say (for Danish):

 

Sql Server(SQLEXPRESS)

NT AUTHORITY\LOKAL TJENESTE

 

As noted by many, don't click "Apply to all".

 

The UI of this page really needs to be improved.

 

/gustav

 

Answer 27

Thanks, all.

 

Between all the answers here, the installation is moving on.

 

To add my $.02, I added a password to my login account (home pc) and the ID and Password worked ok.

 

Myst

Answer 28

hi,man.the same problem occured to me.then i tried my account of my windows 2003 and it worked.i've no idea whether your situation is the same as mine.but i hope it would be  helpful to you.

Answer 29

Danish schools do not need no child left behind.

Now if only more Microsoft SQL config coders were Danish...

 

Yeahh, that's the trick; just get into the text entry box and type any case "n", and follow the drop down.

Sorta dungeons and dragons.

 

Thanks gustav.

 

art "honu" scott

 

 

Answer 30

sm1908 wrote:

1081 I used my current windows user id/password and it worked for me.

 

This solution worked fine for me.

the only condition is that the current user must be set to admin's privilege. 

Answer 31

Paul P.S. wrote:

sm1908 wrote: 1081 I used my current windows user id/password and it worked for me.   This solution worked fine for me. the only condition is that the current user must be set to admin's privilege.

I don't know exactly what you mean here, but for the service account you should use a freshly created
account without any extra privs. The SQL Server setup will add the priviledges needed.

But of course you need to be logged in as admin to install SQL Server at all.

Answer 32

 

hi you need to specify the curent windows username in first textbox and in password field you need to specify the currrent windows password for the current user. if you dont have any password than leave it blank. nad click continue

 

it worked for me may be for u it will also work

 

any way you can also contact on my email address at [e-mail], [e-mail]

Answer 33

April-14-2008

I got this problem when I installed the SQL Server 2008. I tried my administrator ID and password, no matter I use "apply for all" or I typed in every box individually, I just got the invalid message. I am installing the SQL server under the windows user administrator, using XP sp2.

Answer 34

I just used NT AUTHORITY\LOCAL SERVICE

no password for both and it let me continue easy fix no problems so far

Answer 35

ok had some problems using the local service settings if ur haveing problems with useing ur username/password w/out a password then just create one and it should work u might have to restart the installer after adding a password

Answer 36

Yamicannon wrote:

ok had some problems using the local service settings if ur haveing problems with useing ur username/password w/out a password then just create one and it should work u might have to restart the installer after adding a password

Thank you a lot! I made it! The next question is where I can find a SQL Server Management Studio for 2008?

Answer 37

I installed Visual Studio 2008 with SQL Server 2005 Express checked in order to get the SQL Server Management Studio. Then I installed SQL Server 2008. The service of SQLExpress and MSSQLServer are all started. But when I restarted the computer, I found the MSSQLServer service is stopped and cannot start any more. I reinstall VS and SQL again, still get the same problem. Anyone has idea?

Answer 38

Just press ctrl+alt+del and click change password. The information you find in the first field below your picture is the same you'll enter in the SQL setup followed by your password. If you wish, apply the same to all and click Next.

                                                                                           Be happy. 

Answer 39

I had the same issue during the installation. This post worked for me. THANKS!!!

Answer 40

I had the same problem in the final release of SQL Server 2008. You can't add the user or groups by browsing your AD. Just add the user or groups manually "by hand". Type in e.g. Domain\GG-SQL-Group.

 

Greets Tom

 

Answer 41

I had a same and similar issue.

I finish the installation by providing SQL Agnt and SQL Service by NT AUTHORITY\NETWORK SERVICE and blank password. Once complete the installation I changed the Service Account by services.msc to SQL SA account.
Reason: Service account is not granted for Log on as Service.
Solution: Grant the SA to Log on as Service.

---

Abu

Answer 42

When you get to these options in Server Configuration when setting up SQL Server follow these instructions, changing the details to your own.

My Windows Server 2008 Domain is called COD4.com
My user account is called Administrator
and the password is STAPLESfarm11

So to get these to work when setting up MS SQL Server i used the Apply to all option with these details:

Account:      COD4\Administrator

Password:    STAPLESfarm11

If you follow this format it should fix your issue and also make sure that your password is upper and lower case with numbers.
If your Domain or Windows User name hasnt been set to the above type of format, set this first and retry setting up the SQL Server.