|
Home > Archive > BizTalk Server > February 2004 > Re: BizTalk Messaging Service - Startup Error
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 |
Re: BizTalk Messaging Service - Startup Error
|
|
| Jan Eliasen 2004-02-08, 8:39 am |
| On Mon, 15 Dec 2003 23:04:38 -0500, "Ahmed A."
<franknitty69@hotmail.com> wrote:
>Nick is right. if you have a bt server talking to a sql server, you need to
>have domain user. added this user in sql server, and change your bt server
>to use this new user.
Actually, it can be done, but the user running biztalk on one computer
must explicitly be granted the correct rights in the sqlserver to
update the correct databases
--
Jan Eliasen, representing himself and not the company he works for
| |
| Nick Malik 2004-02-08, 8:39 am |
| Hello Jan,
I'm sorry... I fail to see how. The original questioner was running Biztalk
under a local system account. You can't add a local system account from
"machine A" into SQL on "machine B". Is there a way, that you know of, to
have Biztalk connect to SQL using a SQL Login?
Good to see that you've returned. I hope you had a good holiday.
--- Nick
"Jan Eliasen" <spam@eliasen.dk> wrote in message
news:4qb0vvkjmkj1dh962u9k7t8m6h7hd3l5h4@
4ax.com...
> On Mon, 15 Dec 2003 23:04:38 -0500, "Ahmed A."
> <franknitty69@hotmail.com> wrote:
>
to[color=blue]
server[color=blue]
> Actually, it can be done, but the user running biztalk on one computer
> must explicitly be granted the correct rights in the sqlserver to
> update the correct databases
>
> --
> Jan Eliasen, representing himself and not the company he works for
| |
| Jan Eliasen 2004-02-08, 8:39 am |
| On Mon, 29 Dec 2003 21:48:12 GMT, "Nick Malik"
<nickmalik@hotmail.nospam.com> wrote:
>I'm sorry... I fail to see how. The original questioner was running Biztalk
>under a local system account. You can't add a local system account from
>"machine A" into SQL on "machine B". Is there a way, that you know of, to
>have Biztalk connect to SQL using a SQL Login?
Well... I have never tried it, but I remember having read it
somewhere. But probably, what I have read was that you can have a
local user on a machine running BizTalk that can connect to SQL-server
on another machine... If I find where I read it, I will get back on
this.
>Good to see that you've returned. I hope you had a good holiday.
Thanks... It's good to be back :-) Hope you have had a nice holiday
too.
--
Jan Eliasen, representing himself and not the company he works for
| |
| Per Kristoffer Meyer 2004-02-08, 8:39 am |
| The InterchangeBTM connection parameters is located in registry.
Look below this registry branch :
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Bi
zTalk Server\1.0\Administration
Here you'll find :
"MgmtDbLogon"="sql-user"
"MgmtDbName"="InterchangeBTM"
"MgmtDbPassword" =hex:2d,e0,6b,39,fc,2c,30,ef,98,df,6c,1b
,97,a4,3a,97,66,b1,5
3,\
de,ce,a5,aa,11,2d,a8,29,78,dc,b1,c7,36,2
0,e2,e7,32,df,0d,10,50,50,f0,68,30,\
e1,d6,db,86,c8,15,7a,4a,fc,e6,77,98,3c,0
2,9a,32,cc,eb,aa,6d,86,29,05,0f,c6,\
c4,ba,99,40,35,bc,25,95,6c,87,ef,c6,34,b
0,4b,46,03,97,ab,a8,a9,58,64,31,b1,\
44,f3,c9,ae,e5,79,5f,bf,31,e9,f2,1e,4a,3
5,71,94,fe,47,56,e5,4b,70,ab,99,f3,\
d8,49,9b,75,47,25,40,4b,bc
"MgmtDbServer"="SQL-Server"
How ever :
I don't know how to enter the password, wich is encrypted.
"Raghu" <Raghu@nospamzzzqcsi.com> wrote in message
news:uynxey2vDHA.1744@TK2MSFTNGP12.phx.gbl...
> When I start the biztalk messaging service, I get following error:
>
> ****
> Event Type: Error
> Event Source: BizTalk Server
> Event Category: Document Processing
> Event ID: 324
> Date: 12/10/2003
> Time: 2:52:47 PM
> User: N/A
> Computer: MacA
> Description:
> An error occurred in BizTalk Server.
>
> Details:
> ------------------------------
> [0x80040e4d] BizTalk Server failed to initialize a connection to
database:
> "InterchangeBTM" on server: "MacB". :'Login failed for user 'NT
> AUTHORITY\ANONYMOUS LOGON'.'
> 0x80040e4d
> [0x150a] The configuration cache data from the database could not be
> loaded.
>
> [0x1509] The administration cache cannot be created.
>
> [0x0111] The Queue Scheduler for the service could not be created.
> ****
>
> Here is my setup:
> 1) The biztalk messaging service is installed on 'MacA'. The service runs
> under LocalSystem.
> 2) The biztalk databases are installed on 'MacB'.
> 3) We made created 'DomainA\MacA$' sql login and gave dbo permissions to
> InterchangeBTM db.
>
> Any help is greatly appreciated.
>
> Thanks.
> Raghu/..
>
>
| |
| John Ratliff 2004-02-08, 8:39 am |
| I do agree that you should use a domain account to run
your BizTalk Service under, but there may be a way to
make this work. You may just need to add a Service
Principle Name (SPN) to your Active Directory entry for
your SQL Server. We have done this in the past to make
Application Center work with BizTalk Server 2002. The KB
article you can look at is 320827. The article doesn't
address your problem directly, but it does have the
syntax for setting the SPN. The one thing we did get
burned on was if your SQL Server service is running under
a domain account and NOT the local system you need to
create the SPN on the domain account. If the SQL Server
Service is running as the local system they create the
SPN on the machine account in the AD. Also make sure
your SQL Server is using the default port, if not you
need to specify that in the SPN also.
John Ratliff
Sr. Systems Eng.
The Schwan Food Company
>-----Original Message-----
>Nick is right. if you have a bt server talking to a sql
server, you need to
>have domain user. added this user in sql server, and
change your bt server
>to use this new user.
>
>"Raghu" <Raghu@nospamzzzqcsi.com> wrote in message
>news:uynxey2vDHA.1744@TK2MSFTNGP12.phx.gbl...
following error:[color=blue]
connection to[color=blue]
>database:
for user 'NT[color=blue]
database could not be[color=blue]
not be created.[color=blue]
on 'MacA'. The service runs[color=blue]
dbo permissions to[color=blue]
>
>
>.
>
|
|
|
|
|