Avatar of Karen Schaefer
Karen SchaeferFlag for United States of America asked on

The credentials you provided for the SQL Server Agent service are invalid. To continue, provide a valid account and password for the SQL Server A

I am attempting to install SQL Server 2008 R2 on my own pc (Windows 8) - without the use of NT or a server  I want to be able to use my pc as the local server - I want to setup Sql so I can use it for training/learning the software.

I am getting the following issues when I am attempting to load the tools:

TITLE: Message Details
------------------------------

The credentials you provided for the SQL Server Agent service are invalid. To continue, provide a valid account and password for the SQL Server Agent service.

Server Config
Microsoft ApplicationsMicrosoft SQL ServerMicrosoft SQL Server 2008

Avatar of undefined
Last Comment
Saurabh Sinha

8/22/2022 - Mon
SThaya

Hi ,

 you should select "NT Authority\System" from the Account Name section.
SThaya

ASKER
Karen Schaefer

NT\Authority... is for my local connection, since there will not be an actual connection to any external servers, just my local machine.  Can I use the full version of Sql Server 2008 R2 Developer on my local machine?

Thanks for the link, it was the one I was using for the installation, I am still unable to connect.

How do I change this since I have already completed the setup/install by changing the Automatic to Manual?

K
Your help has saved me hundreds of hours of internet surfing.
fblack61
ASKER CERTIFIED SOLUTION
SThaya

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Karen Schaefer

I am unable to complete step 2 - see the attached.

Thanks for your assistance.

K
Config Screen
ASKER
Karen Schaefer

thanks that did the trick
Saurabh Sinha

Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.