Solved

Installing SQLServer2008 - Services Credentials

Posted on 2008-10-31
4
205 Views
Last Modified: 2010-03-20
I am in the middle of installing SQL Server 2008 web edition on a Vista box.

I have an administrator account and one other admin account I created.

During install, it is asking me to setup the Service Accounts. It says they will be configured automatically where possible to use a low privilege account.

It errors saying the credentials are invalid.

When it allows me to specify an account, it only provides two options:
NT AUTHORITY/NETWORK SERVICE
or
NT AUTHORITY/SYSTEM

Neither of which are on my system. How do I get those accounts. Do I create them via the Computer Manager, Add User? Shouldn't they have been automatically created?

Where do I find these built-in system accounts?
0
Comment
Question by:Starr Duskk
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 22853082
Those are accounts in the system that don't exist as user accounts.  They are "special" computer accounts.

If you want SQL server to be running as a user, so that it can be given access to network resources then you need to create the account first.  

You can proceed through the setup using nt auth\system and change it later to an account you create by modifying the login properties in the Services control panel applet.

Start > (Run >) Services.msc <ENTER>
Find SQL Server (May have an instance name such as SQL Server (SQLExpress)).
Right Click > Properties > logon.

change to the account that you created for it.

But for a local dev environment, nt auth\system is fine.
0
 
LVL 2

Author Comment

by:Starr Duskk
ID: 22853222
This isn't a local dev environment.
Nonetheless, you said I can use those by default, but as I pointed out, using the defaults errors saying that the credentials are invalid.
It doesn't find those accounts and I can't custom add accounts becuase it only provides those two options in the dropdown list, and I must enter a password, and since I didn't set those up, I have no clue what the password could be or where to set it up.
So how can I get past this screen?
 
0
 
LVL 39

Accepted Solution

by:
BrandonGalderisi earned 500 total points
ID: 22853876
If it's not a local dev environment then you're saying that SQL 2008 Web Edition on Vista Ultimate is being built as a production environment?

Is the Vista machine a domain member?  If it is, the account should be a domain account.  Then just type domainname\username (for an account created on the domain) that you want to use.

Did you run the install as an administrator?  You MAY need to.  This may be why it won't allow you to use the build in system\network accounts.

0
 
LVL 2

Author Comment

by:Starr Duskk
ID: 22861995
yes, I've been installing as admin.
I did change the top 3 things on the services to my admin account and the lower 2 I had to manually create a low level user account and type that name in and it finally let me do the installation.
Don't know if that is right, but time will tell I guess.
thanks!
 
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question