BTS 2002 install on Windows Server 2003 - SQL Login failed for user NT AUTHORITY
Web Server forum
Back To The Forum Home!Search!Private Messaging System

Web Server Talk Web Server Talk > Web Servers reviews > BizTalk Server > BizTalk Server Setup > BTS 2002 install on Windows Server 2003 - SQL Login failed for user NT AUTHORITY




  Last Thread   Next Thread Next
  Show Printable Version Email this Page Subscribe to this Thread      Post New Thread    Post A Reply      

    BTS 2002 install on Windows Server 2003 - SQL Login failed for user NT AUTHORITY  
is0butane


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
09-23-04 10: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





[ Post a follow-up to this message ]



    Re: BTS 2002 install on Windows Server 2003 - SQL Login failed for user NT AUTHORITY  
Joe Eldridge \(MSFT\)


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
10-05-04 10: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







[ Post a follow-up to this message ]



    Re: BTS 2002 install on Windows Server 2003 - SQL Login failed for user NT AUTHORITY  
Joe Eldridge \(MSFT\)


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
10-05-04 10: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... 
>
>







[ Post a follow-up to this message ]



    Sponsored Links  




 





   All times are GMT. The time now is 11:52 AM.      Post New Thread    Post A Reply      
  Last Thread   Next Thread Next


Most Popular forums 

Forum Jump:
Rate This Thread:

Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is OFF
vB code is ON
Smilies are ON
[IMG] code is OFF
 
Medical and Health forum | Computer Games Reviews | Graphics design forum

Back To The Top
Home | Usercp | Faq | Register