Hello everyone,
I got a strange problem when installing sql express on an empty windows xp sp2 machine.
When I try to create a new database within a directory, which existed before installing the server (e.g. c:\programme), i get an error message something like "1802 access denied, cannot create database".
But when I try to create a new directory on the harddisk (e.g. c:\oliver) and create the database into this directory, then it works!
I am logged in as admin, with full access rights. And everything is on the local machine. Anyone got a clue
Thanks a lot in advance,
Oliver
1802 access denied
lest
The built-in accounts are localized for some languages. If you use localized OS then you have to specify the localized account name:
Name for Local Service
Name for Network Service
Name for Local System
Name for Admin Group
DE
NT-AUTORITAT\LOKALER DIENST
NT-AUTORITAT\NETZWERKDIENST
NT-AUTORITAT\SYSTEM
VORDEFINIERT\Administratoren
IT
NT AUTHORITY\SERVIZIO LOCALE
NT AUTHORITY\SERVIZIO DI RETE
NT AUTHORITY\SYSTEM
BUILTIN\Administrators
ES
NT AUTHORITY\SERVICIO LOC
NT AUTHORITY\Servicio de red
NT AUTHORITY\SYSTEM
BUILTIN\Administradores
irf
Is there any official word from MSFT regarding setting the service account during the SQL Express setup
I got the same problem in order to make the service run under "Local System Account", instead of the default "Network Account". But I saw somebody mentioned that SQLACCOUNT="NT AUTHORITY\SYSTEM" may have problem on non-English language OS.
Thanks,
Ding
jxxxs
Hi Jeffrey,
the call to the sql-express-setup looks like this:
setup SQLACCOUNT="NT AUTHORITY\SYSTEM"
But it is still installed as a network-account. And when I step through the pages of the install gui, network-account is still marked (instead of "local account")... I thought i could override that with the startup-parameter... or maybe it is different in the german-install routine
Still searching a clue...
Thanks, Oliver
danparker276
-Jens.
Kevin Welty
You can try to use Local System, that might work better for you, although it is a higher privilege account than Network Service.
; SQLACCOUNT="NT AUTHORITY\SYSTEM"
Alex Barnett - MSFT
Hello Jens,
thanks for the reply, I changed the service from "network account" to "local account", then it works, but how do I tell the setup-routine, to install the server not on a "network account" (on a standalone installation) I tried to pass the parameter SQLACCOUNT="NT AUTHORITY\LOCAL SERVICE" to the setup, but this does not work.
Or is there another trick to do that
Thanks in advance,
Oliver