|
Home > Archive > BizTalk Server Setup > October 2004 > BTS 2002 install on Windows Server 2003 - SQL Login failed for user NT AUTHORITY
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
BTS 2002 install on Windows Server 2003 - SQL Login failed for user NT AUTHORITY
|
|
| is0butane 2004-09-23, 5:51 pm |
| I have seen many posts on this problem, but no answers.
I am installing BTS 2002 on a Windows 2003 Server and when
It gets to the Database setup (SQL 2000 running on a
separate Windows 2000 Server machine) it give the following
error:
Hresult: 0x800040e4d
Description: Login failed for user 'NT AUTOHRITY\ANONYMOUS
LOGIN',
SQL Error 18456: 42000
Source: Microsoft OLE DB Provider for SQL Server.
Whats going on!? Why is it trying to login as anonymous? I
have set the Biztalk Service to run under a domain account,
and for some reason, Win2003 is preventing this
communication. I have seen a lot of post with this same
error, but in different situations.. Someone Help Please!
is0butane
is0butane@yahoo.com
| |
| Joe Eldridge \(MSFT\) 2004-10-05, 5:54 pm |
| Hi, Well I will see if I can help, Install MDAC 2.8 on both servers and see
what happens. It will probably fix it.
If that does not fix it, Please run setup again and at the same time run a
trace in SQL profiler. Paste the output of the trace here.
--
Joe Eldridge [MSFT]
This posting is provided "AS IS", with no warranties, and confers no rights.
"is0butane" <is0butane@yahoo.com> wrote in message
news:2a6701c4a1bd$871f1ab0$a601280a@phx.gbl...
>I have seen many posts on this problem, but no answers.
> I am installing BTS 2002 on a Windows 2003 Server and when
> It gets to the Database setup (SQL 2000 running on a
> separate Windows 2000 Server machine) it give the following
> error:
>
> Hresult: 0x800040e4d
> Description: Login failed for user 'NT AUTOHRITY\ANONYMOUS
> LOGIN',
> SQL Error 18456: 42000
>
> Source: Microsoft OLE DB Provider for SQL Server.
>
> Whats going on!? Why is it trying to login as anonymous? I
> have set the Biztalk Service to run under a domain account,
> and for some reason, Win2003 is preventing this
> communication. I have seen a lot of post with this same
> error, but in different situations.. Someone Help Please!
>
>
> is0butane
> is0butane@yahoo.com
| |
| Joe Eldridge \(MSFT\) 2004-10-05, 5:54 pm |
| Also you will need to install Network DTC on the 2003 machine.
http://support.microsoft.com/defaul...kb;en-us;817064
--
Joe Eldridge [MSFT]
This posting is provided "AS IS", with no warranties, and confers no rights.
"Joe Eldridge (MSFT)" <joeel@online.Microsoft.com.> wrote in message
news:uD7XCMyqEHA.3988@tk2msftngp13.phx.gbl...
> Hi, Well I will see if I can help, Install MDAC 2.8 on both servers and
> see what happens. It will probably fix it.
> If that does not fix it, Please run setup again and at the same time run a
> trace in SQL profiler. Paste the output of the trace here.
>
>
> --
> Joe Eldridge [MSFT]
> This posting is provided "AS IS", with no warranties, and confers no
> rights.
> "is0butane" <is0butane@yahoo.com> wrote in message
> news:2a6701c4a1bd$871f1ab0$a601280a@phx.gbl...
>
>
|
|
|
|
|