BizTalk RFID Setup: Troubleshooting
We have recently heard one of our customers run into the following issue during BizTalk RFID installation:
-------
Error 1957. Failed to set permissions for user domain\account on the RFIDSTORE database on SQL Server FOO. One reason for this could be that we couldn't establish a connection to the SQL database. Please make sure you are using a domain account for the RFID Service account if you specified a remote SQL Server. See logs for more details.
-------
In this particular scenario, what was happening was that the account with which Setup was running was the same as the one specified for the RFID Service account credentials. While this may not be a very common scenario (as typically Setup is done by an account in the local administrators group and the default for the RFID Service account is .\RfidSvcAcc), I do see the possibility of somebody requiring this kind of a configuration. However, BizTalk RFID Setup doesn't currently support such a configuration, so I would strongly recommend ensuring during Setup that these two accounts are different.
