[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 869
  • Last Modified:

Trouble installing SQL Server 2008 R2?

I attempted to install SQL Server 2008 R2 by selecting all features, but then need to enter passwords for for features.

Under Account Name, what should I select from the drop down?

Do I need to create distinct logins for each?

How shall I proceed?

Thanks.
0
newbieweb
Asked:
newbieweb
  • 8
  • 4
  • 2
  • +2
8 Solutions
 
Rick HobbsRETIREDCommented:
You do not need unique account names.  Just create one account for the install and use it for install and admin.  Create a strong password for the account.
0
 
newbiewebAuthor Commented:
Dos this mean accounts as in Windows Login accounts?

Please exaplin this: Just create one account for the install and use it for install and admin.
0
 
Rick HobbsRETIREDCommented:
yes.  Create an account in AD called SQLadmin or SQLboss or Hotdog or whatever.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
newbiewebAuthor Commented:
what is AD?
0
 
ZberteocCommented:
Active Directory. Your network admin can help you with that. You could also use yours, the one you use to login in your company's domain, if you are the database administrator.
0
 
newbiewebAuthor Commented:
I work alone and have no network admin.

> Log into my company's domain?

Is that what I use to log into Windows?
0
 
newbiewebAuthor Commented:
I see in the drop down are choices:

NT AUTHORITY\NETWORK
NT AUTHORITY\SYSTEM

NT AUTHORITY\LOCAL SERVICE

I do not have a password for any of these, however.
0
 
ZberteocCommented:
0
 
newbiewebAuthor Commented:
I think I will just create a new Windows user (SQLAdmin) without Windows administrator permissions and give that user a strong password.

The link you sent says "If the computer is not part of a domain, use a local user account without Windows administrator permissions. You can create this account using Control Panel -> User Accounts."

Define specs for a strong password?
0
 
ZberteocCommented:
A strog password has letters, both uppercase and lowecase, digits and special characters. Here is a website that will generate one for you:

http://strongpasswordgenerator.com/

However, make sure you save that password into a safe place otherwise you will never remember. That is why is strong. :o)

Cheers.
0
 
ZberteocCommented:
Here is another website for geneating passwords:

http://www.thebitmill.com/tools/password.html

I personally prefer this one.
0
 
smoutkastCommented:
@newbieweb...you don't necessarily have to create a new user account. you can use the account that you are currently using to log into windows from. However it is not recommended for "live" servers.

Select "User the same account for all SQL Server services"Click on BrowseSelect "Advanced"Click on "Find Now" and you will see a list of users/accounts. Select the account that you want to use for SQL. I generally select my local user (the account that you use to log onto windows) Click "OK"Enter the password for that user/account. (Make sure your user/account does have a password associated with it)
0
 
newbiewebAuthor Commented:
Thanks for the help.  But it's not working.

I created a user SQLServerAdmin and gave it a strong passord (although this machine is stricly for dev and wold never be hosting a public instance).

I clicked the Advanced button to open the "Select User or Group" dialog, and added in the new user with the password for each of the items (see attached).  But I got an error for each of the four.

I think my trouble is I delected too many items in the other dialog.  I just want to hurry up and get SQL Server 2008 R2 installed, and need to know the minimum number of choices in the second attached dialog.

So please tell me the minimum number of checkboxes.  I need SQL Server installed and the MS SQL Management Studio.  I think that's it.
PasswordInvalid.png
INstanceFeatures.png
0
 
Anthony PerkinsCommented:
I work alone and have no network admin.
Just use Network Service or Local System Account (no password needed) and move on.
0
 
newbiewebAuthor Commented:
I selected my post by mistake.
0
 
newbiewebAuthor Commented:
This time I got it right.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 8
  • 4
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now