Hi all,
When I am installing Commerce Server on my SQL Server 2005 machine I get
an error reported in the logs that that says "Login failed for user 'CSNET\t
aziegma'.
[CLIENT: 192.168.25.12] Error: 18456, Severity: 14, State: 16. I have lo
oked
on google for information. I have also posted in the Commerce Server groups.
I can run queries against the databases the remote system is trying to acces
s
no problem. But when Commerce Server tries to access it it errors out. Also,
when I view the Activity Monitor next to the processes kicked off by the
remote machine it says .net sqlserver client provider. Is there something
I need to set up for .net? I am stumped.
thanks,
tziegmannDoes Commerce Server never work or is it just an issue for this user?
depending on the configuration, this might be a "double hop" issue. If you
are not logged in directly to the to the commerce server machine but logged
in to another machine accessing Commerce Server, the Commerce Server would
require delegation permission to log into SQL Server with the client's
credentials. This only works if your networks supports Kerberos
authentication and delegation is allowed. Many networks don't allow this.
Note that this answer is based on a lot of assumptions about your
configuration and is basically a guess based on your mention of Commerce
Server.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"tziegmann" <tziegmann@.msn.com> wrote in message
news:428ac052327f8c80d356188011c@.news.microsoft.com...
> Hi all,
> When I am installing Commerce Server on my SQL Server 2005 machine I get
> an error reported in the logs that that says "Login failed for user
> 'CSNET\taziegma'. [CLIENT: 192.168.25.12] Error: 18456, Severity: 14,
> State: 16. I have looked on google for information. I have also posted in
> the Commerce Server groups. I can run queries against the databases the
> remote system is trying to access no problem. But when Commerce Server
> tries to access it it errors out. Also, when I view the Activity Monitor
> next to the processes kicked off by the remote machine it says .net
> sqlserver client provider. Is there something I need to set up for .net? I
> am stumped.
> thanks,
> tziegmann
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment