|
Home > Archive > BizTalk Server General > February 2004 > connect remotely
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]
|
|
|
| I want to connect to our BizTalk server remotely, from my desktop without
terminal servicing to the server. I have BizTalk admin installed on my
machine, but when I try to add a server to the Biztalk group it won't allow
me. I get error message about the central messaging db. Do I have to point
my machine to the central messaging SQL db to have BizTalk work remotely?
| |
| Jack Blalock 2004-02-08, 8:37 am |
| You do need to be a member of the Biztalk Server Administrators group as
well as dbo on the InterchangeBTM, InterchangeSQ, and InterchangeDTA
databases. Make sure these steps are done.
Jack Blalock [MSFT]
This posting is provided "AS IS", with no warranties, and confers no rights.
| |
|
| I'm admin to both, BizTalk server and the SQL db.
If I terminal service to the server and log in that way I can access
everything.
I would rather not terminal service to the server and just use the BizTalk
admin tool from my own machine and be able to view the queues, functions,
etc.
"Jack Blalock" <jackbl@online.microsoft.com> wrote in message
news:flk1XbG1DHA.3088@cpmsftngxa07.phx.gbl...
> You do need to be a member of the Biztalk Server Administrators group as
> well as dbo on the InterchangeBTM, InterchangeSQ, and InterchangeDTA
> databases. Make sure these steps are done.
>
> Jack Blalock [MSFT]
> This posting is provided "AS IS", with no warranties, and confers no
rights.
>
| |
| Nick Malik 2004-02-08, 8:37 am |
| I assume that SQL Server is not installed on the same machine as Biztalk
server. If this is the case, you cannot do what you want with BTS2002.
The problem is that your client machine sends credentials to the IIS server
where Biztalk is running, which cannot forward those credentials to SQL
Server.
There is an article in MSDN on this.
Sorry,
--- Nick
"Mike" <csharpcoder@sbcglobal.net> wrote in message
news:eVNuTtG1DHA.2336@TK2MSFTNGP09.phx.gbl...
> I'm admin to both, BizTalk server and the SQL db.
> If I terminal service to the server and log in that way I can access
> everything.
> I would rather not terminal service to the server and just use the BizTalk
> admin tool from my own machine and be able to view the queues, functions,
> etc.
>
> "Jack Blalock" <jackbl@online.microsoft.com> wrote in message
> news:flk1XbG1DHA.3088@cpmsftngxa07.phx.gbl...
> rights.
>
>
| |
| richard 2004-02-08, 8:37 am |
| Hi Mike,
You do have to configure each of the biztalk tools to point to your biztalk
/ database server in your scenario.
For BizTalk Server Administration, open BizTalk Server Administrator from
the start menu (Start > Programs > Microsoft BizTalk Server 2002 > BizTalk
Server Administration)
In the left-pane treeview expand "console root", right click "Microsoft
BizTalk Server 2002", select properties and update the details to point to
the sql server hosting your biztalk databases.
If you're administering an existing BizTalk Group you should not need to add
a server to the group - all the information about the existing group is in
the InterchangeBTM database.
Hope this helps
richard
"Mike" <csharpcoder@sbcglobal.net> wrote in message
news:eVNuTtG1DHA.2336@TK2MSFTNGP09.phx.gbl...
> I'm admin to both, BizTalk server and the SQL db.
> If I terminal service to the server and log in that way I can access
> everything.
> I would rather not terminal service to the server and just use the BizTalk
> admin tool from my own machine and be able to view the queues, functions,
> etc.
>
> "Jack Blalock" <jackbl@online.microsoft.com> wrote in message
> news:flk1XbG1DHA.3088@cpmsftngxa07.phx.gbl...
> rights.
>
>
| |
| richard 2004-02-08, 8:37 am |
| Hi Nick,
I think your comment only applies to the messaging manager as I believe the
biztalk server admin tool does not use IIS.
The following KB article suggests that it is possible to get the messaging
manager working remotely too (see step 6 of the resolution section)
http://support.microsoft.com/?kbid=317990
It also highlights an important point in that the biztalk 2002 messaging
manager requires SSL to connect to a remote biztalk box.
hope this helps
richard
p.s.
In addition to the resolution suggested in the KB article it should be
possible to get IIS to forward the client credentials to the sql box if you
can get delegation working (see
http://groups.google.com/groups?dq=...x.gbl&frame=off
for more info)
"Nick Malik" <nickmalik@hotmail.nospam.com> wrote in message
news:xmBKb.143100$VB2.544364@attbi_s51...
> I assume that SQL Server is not installed on the same machine as Biztalk
> server. If this is the case, you cannot do what you want with BTS2002.
> The problem is that your client machine sends credentials to the IIS
server
> where Biztalk is running, which cannot forward those credentials to SQL
> Server.
> There is an article in MSDN on this.
>
> Sorry,
> --- Nick
>
> "Mike" <csharpcoder@sbcglobal.net> wrote in message
> news:eVNuTtG1DHA.2336@TK2MSFTNGP09.phx.gbl...
BizTalk[color=blue]
functions,[color=blue]
as[color=blue]
>
>
| |
| Nick Malik 2004-02-08, 8:37 am |
| Thank you Richard,
Yes, I was thinking of the messaging manager. Also, I was not aware of the
"High Isolation" trick. I stand corrected.
Of course, this doesn't help the original questioner, does it? :-(
Mike, if you are still having your problem, could you post the text of the
error message you are getting?
--- Nick
"richard" <reply@tonewsgroup.com> wrote in message
news:unUxqOU1DHA.3224@tk2msftngp13.phx.gbl...
> Hi Nick,
>
> I think your comment only applies to the messaging manager as I believe
the
> biztalk server admin tool does not use IIS.
>
> The following KB article suggests that it is possible to get the messaging
> manager working remotely too (see step 6 of the resolution section)
> http://support.microsoft.com/?kbid=317990
>
> It also highlights an important point in that the biztalk 2002 messaging
> manager requires SSL to connect to a remote biztalk box.
>
> hope this helps
> richard
>
> p.s.
>
> In addition to the resolution suggested in the KB article it should be
> possible to get IIS to forward the client credentials to the sql box if
you
> can get delegation working (see
>
http://groups.google.com/groups?dq=...x.gbl&frame=off
> for more info)
>
>
> "Nick Malik" <nickmalik@hotmail.nospam.com> wrote in message
> news:xmBKb.143100$VB2.544364@attbi_s51...
> server
> BizTalk
> functions,
group[color=blue]
> as
>
>
|
|
|
|
|