Very Computer

thanks in advance
Daniel

Try ".\Administrator" (without the quotes).

--Jonathan

Quote:>-----Original Message-----
>Hi
>I have upgraded my SQL 2000 machine from windows 2000 to
XP
>Professional running not in an domain. I must run the
SQL200 under the
>local administrator account. Changing the server-account
from
>LocalSystem to Administrator gives me the error no.
15407 'not a valid
>name'. Does anybody have any ideas how to write the
correct local
>administrator account.

>thanks in advance
>Daniel

The proper name would be
yourservername\Administrator

--
Wayne Snyder MCDBA, SQL Server MVP
Computer  Education Services Corp (CESC), C*te, NC
(Please respond only to the newsgroups.)

PASS - the definitive, global community
for SQL Server professionals - http://www.veryComputer.com/

Quote:> Hi
> I have upgraded my SQL 2000 machine from windows 2000 to XP
> Professional running not in an domain. I must run the SQL200 under the
> local administrator account. Changing the server-account from
> LocalSystem to Administrator gives me the error no. 15407 'not a valid
> name'. Does anybody have any ideas how to write the correct local
> administrator account.

> thanks in advance
> Daniel

To establish an account to start up SQL Server on Windows XP, that will NOT
show up on the local LOGON screen:

Start | Settings | Control Panel:

using Category View: Performance and Maintenance | Administrative Tools |
Local Security Policy | User Rights Assignment | Logon as a service, and |
Deny logon locally

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

Quote:> Hi
> I have upgraded my SQL 2000 machine from windows 2000 to XP
> Professional running not in an domain. I must run the SQL200 under the
> local administrator account. Changing the server-account from
> LocalSystem to Administrator gives me the error no. 15407 'not a valid
> name'. Does anybody have any ideas how to write the correct local
> administrator account.

> thanks in advance
> Daniel