Solved

SQL Server installation problems

Posted on 2003-11-19
4
2,037 Views
Last Modified: 2007-12-19
Hi,

Im having a nightmare trying to install SQL server Evaluation Version onto Windows XP Pro.

In the installation, at the service accounts section, it just wouldnt recognise any of the Windows Accounts that are on my machine, therefore i using a Local System Account so i could come back and change it afterwards.

Now when i go to Tools > SQL Server configuration Properties > Security and try and change the Startup Service Account from a Local System Account to a domain user account i get the following problems.

If i just use

Username : Administrator
Password : Password

i get the following error message

Error 15407 : 'Administrator' is not a valid Windows NT name. Give the complete name: <domain\username>.

So i try that using

Username : Computername\Administrator
Password : Password

and i get the following error message

Logon Failure : the user has not been granted the requested logon type at this computer.

This is really confusing as i am logged in as Administrator, so i have every permission there is. I seem to remember something like this once before and im sure it was to do with having service pack 1 installed, but, in this case ive got all the microsoft updates that there are.

Can anyone help as this is driving me mad?

Thanks in advance

Al
0
Comment
Question by:higgsy
  • 2
4 Comments
 
LVL 29

Expert Comment

by:Nightman
ID: 9779054
Logon Failure : the user has not been granted the requested logon type at this computer

Administrator needs to be granted the ability to login as a service. I believe that this is not enabled by default.

Cheers
Night
0
 

Author Comment

by:higgsy
ID: 9779216
Hi nightman,

how would i do that?
0
 
LVL 29

Assisted Solution

by:Nightman
Nightman earned 250 total points
ID: 9779366
Usually under User manager for domains - User Rights - show advanced rights, select allow account to login as service - OK.

HOWEVER, I think this requires a domain server, so if you're on a stand-alone machine and not on a network, it may not be available. Usually on a stand-alone machine, this is automatic.

Hope this helps
Cheers
Night
0
 
LVL 34

Accepted Solution

by:
arbert earned 250 total points
ID: 9779378
Go into your Services in Control Panel/Administrative Tools.  If you change the account on the actual service, Windows by default (if you're logged in as administrator) will give the account the ability to logon as service.

Brett
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Suggested Solutions

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

828 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