Installing SQLServer2008 - Services Credentials
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?
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?
ASKER
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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!
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!
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.