|
Home > Archive > BizTalk Server > May 2007 > No of users in SQL Server
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 |
No of users in SQL Server
|
|
| HemantHB 2007-05-15, 7:16 am |
| Does anyone know how many users are needed in SQL Server to run BizTalk 2006
plz?
Thanks in advance
Hemant
| |
| Saravana Kumar 2007-05-15, 7:16 am |
| 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 2006
> plz?
> Thanks in advance
> Hemant
| |
| HemantHB 2007-05-15, 7:15 pm |
| Thanks for the precious help, Saravana. This applies to BizTalk 2006 too, I
guess?
Many thanks once again.
Hemant
|
|
|
|
|