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
Karen SchaeferBI ANALYSTAsked:
Who is Participating?
 
SThayaConnect With a Mentor Technical MAnagerCommented:
do the below steps:

1. Start---All Programs---Microsoft SQL Server 2008 R2------then select SQL server configuration manager
2.Select the SQL services --- in the right side window all the list of services belongs to SQLserver
3. for Example for SSIS ...select the SQL Integration services--Properties --select Service tab---in the "Start mode" drop down you can select the options.
0
 
SThayaTechnical MAnagerCommented:
Hi ,

 you should select "NT Authority\System" from the Account Name section.
0
 
SThayaTechnical MAnagerCommented:
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Karen SchaeferBI ANALYSTAuthor Commented:
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
0
 
Karen SchaeferBI ANALYSTAuthor Commented:
I am unable to complete step 2 - see the attached.

Thanks for your assistance.

K
Config Screen
0
 
Karen SchaeferBI ANALYSTAuthor Commented:
thanks that did the trick
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.