Does anyone know how many users are needed in SQL Server to run BizTalk 2006
plz?
Thanks in advance
Hemant

[ Post a follow-up to this message ]

Hi Hemant,

You question is not 100% clear, but I'll try to explain something down the
line which I'm guess, that's what you are expecting.


BizTalk normally doesn't work with any individual accounts when it comes to
SQL. It basically operates on the following 4 Windows NT groups.


BizTalk Application Users
BizTalk Isolated Host Users
BizTalk Server Administrators
BizTalk Server Operators

Internally it creates SQL roles to manage permissions. So make sure the
above Windows NT groups are there, again if your experiencing any
difficulties its not advisable to add/remove users manually in SQL databases
directly. Instead you should use Configuration wizard to fix it, then you
add/remove appropriate users to the Windows NT group.

You might see additional groups like "EDI Substem users" based on the stuff
you have installed.

--
Regards,
Saravana Kumar
http://www.biztalk247.com/v1/
http://www.digitaldeposit.net/blog
[Please mark the response as "Answer" if it solves your problem.]


"HemantHB" wrote:

> Does anyone know how many users are needed in SQL Server to run BizTalk 20
06
> plz?
> Thanks in advance
> Hemant

[ Post a follow-up to this message ]

Thanks for the precious help, Saravana. This applies to BizTalk 2006 too, I
guess?
Many thanks once again.
Hemant

[ Post a follow-up to this message ]