Guys,
I am in the process of installing Biztalk Server 2006 R2 on a Windows 2003 host.
I have got as far as enabling SSO, Groups, etc…, but when I try to configure the BizTalk Runtime I keep recieving an error with regards SQL priviliges…
‘Failed to create SQL login and grant SQL privilege configurations on Tracking database server “Server_A” / database name “BizTalkDTADb” while creating BizTalk Host “BizTalkServerApplication”. Syntax error or access violation’.
The SQL Server is version 2005 SP2 and is located on a seperate machine, the user that has been assigned for use by BizTalk has Admin rights for the server, is in the various groups for BizTalk and SSO and is the owner of the DB’s used by BizTalk.
I have seen a few posts with regards similar issues on the net, but no resolution.
Has anyone resolved this issue or have any pointers to help?
Many thanks
Luke Stedman