- This topic has 2 replies, 1 voice, and was last updated 9 years, 5 months ago by
.
-
Posts
-
-
Hi,
I have installed biztalk server 2004 on windows 2000 professional
machine which is having local sql server 2000 client.
The sql server 2000 database resides on another wondows 2003 server machine.When i am configuring biztalk server on my local machine(through configframework), it gives me following error
Failed to create SQL login for biztalk administrators group on database server \”RemoteWindows2003ServerName\”.
Windows Nt user or group ‘RemoteWindows2003ServerName\\Biztalk server administrators’ not found.Check the name again.I have already created this group on my local machine and assigned administrator user to it(Do i need to create these users manuallly).
Do i need to create this and other groups on Windows 2003 server(Where the sql server database resides) as well ?
IS this a group or a user is not clear to me. i created it as a group because biztalk configuration allows only groups name to be edited.
If yes, please let me know the procedure.
Note: I also added tried domain name to the user/group but it is alos of no use.Early help on this is highly solicited.
regards
rajiv -
Rajiv,
You can install BTS2004 on Windows 2000 Prof…i did many times.
I never got this type error, i remember i got some database errors which i resolved changing some information in the registry…
hope this article helps you..
http://geekswithblogs.net/mhamilton/archive/2005/05/01/38784.aspx
Nar-
[
quote=\”Rajiv \”]Hi,
I have installed biztalk server 2004 on windows 2000 professional
machine which is having local sql server 2000 client.
The sql server 2000 database resides on another wondows 2003 server machine.When i am configuring biztalk server on my local machine(through configframework), it gives me following error
Failed to create SQL login for biztalk administrators group on database server \”RemoteWindows2003ServerName\”.
Windows Nt user or group ‘RemoteWindows2003ServerName\\Biztalk server administrators’ not found.Check the name again.I have already created this group on my local machine and assigned administrator user to it(Do i need to create these users manuallly).
Do i need to create this and other groups on Windows 2003 server(Where the sql server database resides) as well ?
IS this a group or a user is not clear to me. i created it as a group because biztalk configuration allows only groups name to be edited.
If yes, please let me know the procedure.
Note: I also added tried domain name to the user/group but it is alos of no use.Early help on this is highly solicited.
regards
rajiv[/quote]-
Biztalk access the SQL database using Windows Authentication. When you install both SQL and Biztalk on one machine this is not a problem as you can use local users and groups. In fact Biztalk will create the required users and groups for.
When installing SQL on a remote machine you need to have users and groups that can be used on both machines. Local users are only valid on the local machine.
The standard in this circumstance is to add the required users and groups to a domain and use the domain account when configuring Biztalk.If you do not have a domain, then there is a workaround but it is messy.
You need to add exactly the same users and groups to both machine, i.e. both the user name and password must be the same. If a password is changed on one machine it must be changed on the other.
-
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.