RE: Setting Specific Login/Password for Connection to BRE database.

"BigMike" wrote:

Awesome help!
Thanks!

The goal was to connect to the BRE database with a
Web Service call using a specific login/password.

To recap my steps, and possibly help someone else.

1) Create a domain login, domain\breweb for example.

on the Web Server
1) Using Computer Management, add the new domain account
to the two local groups
--> webserver\Administrators
--> webserver\IIS_WPG
2) Using IIS Manager, create the new Application Pool
I selected, copy existing .Net 2.0 Pool, and hit OK
3) Right Click on the new pool, and select Properties
4) On the last tab "Identity" select Configurable, radio button,
and enter the new domain account, hit ok
3) Right Click on the new pool, and select Start
4) Verify in the System Logs, Event Viewer, that there
were no errors. I had one because the domain
account was not in the local IIS_WPG group.
5) Now go to the properties of the Web Service itself,
select the new Application Pool, and hit OK

on the SQL server where the BRE database is hosted
1) Using Computer Management, add the new domain account
to the two local groups
--> sqlserver\BizTalk Application Users
--> sqlserver\BizTalk Isolated Host Users

Thanks again for your help.
Mike

Hello,

We have a web server which exposes the BRE. When running on the development
server in the debugger, it connects, using windows Authentication, and works.

However, when published to a web server, the error

Server was unable to process request. ---> Cannot open database
"BizTalkRuleEngineDb" on server "DEVSQL06". Login failed for user
'DOMAIN\DEVWEB1$'. ---> Login failed for user 'DOMAIN\DEVWEB1$'.

DEVWEB1 happens to be the machine name, not any user.

Our web server does someing thing like this (copied from another post)
TypedXmlDocument typedXmlDocument = new TypedXmlDocument( documentType,
xmlDocument );
Policy policy = new Policy( policyName )
policy.Execute( typedXmlDocument );

OK, the question!
How do I configure the WebService/BRE to use a specific
login/password when connection to the BizTalkRuleEngineDb database.

Mike
.