Solved

SQL Server installation problems

Posted on 2003-11-19
4
2,028 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
Comment Utility
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
Comment Utility
Hi nightman,

how would i do that?
0
 
LVL 29

Assisted Solution

by:Nightman
Nightman earned 250 total points
Comment Utility
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
Comment Utility
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

Suggested Solutions

Introduced in Microsoft SQL Server 2005, the Copy Database Wizard (http://msdn.microsoft.com/en-us/library/ms188664.aspx) is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

772 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now