Saturday, February 25, 2012

Registration error

Hi,
I am able to register other SQL server instances but when
I try to register one in particular I am getting this
error on the main server to which I need to register all
of the satelite servers. Can anyone help with this
problem? I don't understand why it is using a null
account instead of the guest account to try to log into
this particular instance.
Login failed for user '(null)'. Reason: Not associated
with a Trusted SQl Server connectionthat server is setup for Windows Authentication and you are logging in using
SQL login?
"Narine" <narinep@.siu.edu> wrote in message
news:2379e01c38c41$872a6010$a601280a@.phx.gbl...
> Hi,
> I am able to register other SQL server instances but when
> I try to register one in particular I am getting this
> error on the main server to which I need to register all
> of the satelite servers. Can anyone help with this
> problem? I don't understand why it is using a null
> account instead of the guest account to try to log into
> this particular instance.
>
> Login failed for user '(null)'. Reason: Not associated
> with a Trusted SQl Server connection|||I am just using windows authentication only because I am
using the datbase with MS VB.NET 2002 and I am doing
merge replication with subscribers.
>--Original Message--
>that server is setup for Windows Authentication and you
are logging in using
>SQL login?
>"Narine" <narinep@.siu.edu> wrote in message
>news:2379e01c38c41$872a6010$a601280a@.phx.gbl...
>> Hi,
>> I am able to register other SQL server instances but
when
>> I try to register one in particular I am getting this
>> error on the main server to which I need to register
all
>> of the satelite servers. Can anyone help with this
>> problem? I don't understand why it is using a null
>> account instead of the guest account to try to log into
>> this particular instance.
>>
>> Login failed for user '(null)'. Reason: Not associated
>> with a Trusted SQl Server connection
>
>.
>|||Check if the server you are trying to connect to is set to
Windows Authentication Only and change the security
settings to SQL Server and Windows. It seems that you are
using SQL authentication yourself and the other machine is
set to Windows Authentication only.
Edgardo Valdez
MCSD, MCDBA, MCSE, MCP+I
http://www.edgardovaldez.us/
>--Original Message--
>Hi,
>I am able to register other SQL server instances but when
>I try to register one in particular I am getting this
>error on the main server to which I need to register all
>of the satelite servers. Can anyone help with this
>problem? I don't understand why it is using a null
>account instead of the guest account to try to log into
>this particular instance.
>
>Login failed for user '(null)'. Reason: Not associated
>with a Trusted SQl Server connection
>.
>|||All of the servers are set to use Windows authentication
only originally when I installed them and this is stil so
when i just checked them. Could there be another reason
the main server is using the null account instead of the
guest account to register with the satelite server? How
can I set this parameter?
>--Original Message--
>Check if the server you are trying to connect to is set
to
>Windows Authentication Only and change the security
>settings to SQL Server and Windows. It seems that you
are
>using SQL authentication yourself and the other machine
is
>set to Windows Authentication only.
>
>Edgardo Valdez
>MCSD, MCDBA, MCSE, MCP+I
>http://www.edgardovaldez.us/
>>--Original Message--
>>Hi,
>>I am able to register other SQL server instances but
when
>>I try to register one in particular I am getting this
>>error on the main server to which I need to register
all
>>of the satelite servers. Can anyone help with this
>>problem? I don't understand why it is using a null
>>account instead of the guest account to try to log into
>>this particular instance.
>>
>>Login failed for user '(null)'. Reason: Not associated
>>with a Trusted SQl Server connection
>>.
>.
>|||Check this article and see if it applies to you:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;Q279526
Edgardo Valdez
MCSD, MCDBA, MCSE, MCP+I
http://www.edgardovaldez.us/
>--Original Message--
>All of the servers are set to use Windows authentication
>only originally when I installed them and this is stil so
>when i just checked them. Could there be another reason
>the main server is using the null account instead of the
>guest account to register with the satelite server? How
>can I set this parameter?
>
>>--Original Message--
>>Check if the server you are trying to connect to is set
>to
>>Windows Authentication Only and change the security
>>settings to SQL Server and Windows. It seems that you
>are
>>using SQL authentication yourself and the other machine
>is
>>set to Windows Authentication only.
>>
>>Edgardo Valdez
>>MCSD, MCDBA, MCSE, MCP+I
>>http://www.edgardovaldez.us/
>>--Original Message--
>>Hi,
>>I am able to register other SQL server instances but
>when
>>I try to register one in particular I am getting this
>>error on the main server to which I need to register
>all
>>of the satelite servers. Can anyone help with this
>>problem? I don't understand why it is using a null
>>account instead of the guest account to try to log into
>>this particular instance.
>>
>>Login failed for user '(null)'. Reason: Not associated
>>with a Trusted SQl Server connection
>>.
>>.
>.
>|||I have installed SP3 for MSSQL server for the desktop and
server version of mssql server 2000 and these included
the latest MDAC components. Should I go ahead and install
MDAC 8? could this be an SP3 problem? should I install
SP3a?
>--Original Message--
>Check this article and see if it applies to you:
>http://support.microsoft.com/default.aspx?scid=kb;en-
>us;Q279526
>
>Edgardo Valdez
>MCSD, MCDBA, MCSE, MCP+I
>http://www.edgardovaldez.us/
>>--Original Message--
>>All of the servers are set to use Windows
authentication
>>only originally when I installed them and this is stil
so
>>when i just checked them. Could there be another reason
>>the main server is using the null account instead of
the
>>guest account to register with the satelite server? How
>>can I set this parameter?
>>
>>--Original Message--
>>Check if the server you are trying to connect to is
set
>>to
>>Windows Authentication Only and change the security
>>settings to SQL Server and Windows. It seems that you
>>are
>>using SQL authentication yourself and the other
machine
>>is
>>set to Windows Authentication only.
>>
>>Edgardo Valdez
>>MCSD, MCDBA, MCSE, MCP+I
>>http://www.edgardovaldez.us/
>>--Original Message--
>>Hi,
>>I am able to register other SQL server instances but
>>when
>>I try to register one in particular I am getting this
>>error on the main server to which I need to register
>>all
>>of the satelite servers. Can anyone help with this
>>problem? I don't understand why it is using a null
>>account instead of the guest account to try to log
into
>>this particular instance.
>>
>>Login failed for user '(null)'. Reason: Not
associated
>>with a Trusted SQl Server connection
>>.
>>.
>>.
>.
>

No comments:

Post a Comment