Re: 'Domain\LocalServer$' is not a valid user

Hi Wei Lu,

I apologize for delay in answering you. Here the result:

I do NOT have the problem if both SQL servers started with the
TEST_DOMAIN\NICK account,
but I had to grant the local administrator privileges to him otherwise I got
access denied error when starting the SQL service.

I have also tried to restart again the SQL server as LOCAL system and to
leave
TEST_DOMAIN\NICK as machines local administrator and sysadmin on both SQL
servers and I get again the error.

Thanks again, Beppe


"Wei Lu" <t-weilu@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:PrP8YXJMGHA.608@xxxxxxxxxxxxxxxxxxxxxxxx
Hi Beppe,

Just checking in to see if the suggestions were helpful. Please let us
know if you would like further assistance.

Have a great day!

Sincerely yours,

Wei Lu
Microsoft Online Partner Support
======================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no
rights.



.

Relevant Pages

  • Re: Security
    ... Step Error Help Context ID:0 ... > SA on both SQl servers, by running a job and my domain account which is also ... > SA on both SQL servers by using exec xp_cmdshell 'dtsrun'. ... > in the dts package connection is a SQL Login that is SA on the server it is ...
    (microsoft.public.sqlserver.server)
  • Re: NT Administrators group
    ... > How common is it that people administrating SQL Servers ... > remove the BUILTIN/Adminstrators account? ... > I am making an installer that queries a SQL Server several ...
    (microsoft.public.sqlserver.security)
  • Copy Database Wizard?
    ... We have two SQL Servers, ... uses a database on DB02 and now I need to copy it to DB01. ... one of our network administrators, that to run the Copy Database Wizard, ... started with the same user account. ...
    (microsoft.public.sqlserver.tools)
  • Re: Webservice SQL logon fails on production IIS server
    ... I can open any of the SQL Servers w/ Win integrated authentication in ... > production code currently accessed (w/Win authentication) from an Access ... the web service is running under account that has no rights to call the SQL ... Martin Kulov ...
    (microsoft.public.dotnet.framework.webservices)
  • Windows authentication on a Novell netware Network
    ... I wish to use replication between two sql servers that are on a Novell ... Netware Network. ... change this to a different account and BOL says it needs to be a DOMAIN ...
    (microsoft.public.sqlserver.server)