BizTalk SSO and groups and security

In BizTalk 2009. I went to at a file receive port and I get a security warning.

To fix this I had to add my name to the BizTAlk Server Administrators group in active directories. This is not the SSO groups on the local machine.

These errors were SSO errors in the event log even though I was in the SSO administrator group on the local machine, I still got the error.

The message in the event log told me to add my self to the SSO administrtor group.

BizTalk Administration Console 2009

Yes people I started working on BizTalk 2009. I could not get into the Server administration console.

I added myself as an sysadmin on the local database. TO do this I had to find someone who had access already.

1. Use Micorsoft SQL server manager.

2. Connect to the server in question, this is where BizTalkMgmtDB resides.

3. Open the "logins" node on the tree on the left.

4. Right click on your logon icon, if one does not exist you must create one.

5. Select the properties box.

6. On the tree on the left select server roles

7. Check the box with SYSADMIN.

Do you need this much capability? I have no idea but it worked for me.

New Flat File Wizard problems

I was assigned to build some flat file maps for some drug data. This was a positional file with carriage return and line feed at the end of each record.

I opened the flat file wizard and generated my positional file that looked like this:

Header1 Required

Header2 Required

Detail1 Optional

Detail2 Optional

Detail3 Optional

Trailer Required

After entering the format I had 3 problems

1. It should look like this:

Header1

Header2

Body

Detail1

Detail2

Detail3

Trailer

The body data is repeating.

2. On the schema node there is a property:

Parser Optimization

This needs to be changed from "speed" to "complex". It will not work with out this be set to "complex".

3. The min and max for each record needs to be as follows

MAX MIN

Header1 1 1

Header2 1 1

Body Unbounded 0

Detail1 Unbounded 1

Detail2 Unbounded 0

Detail3 Unbounded 0

Trailer 1 1

Do not let the min and max default!!! Blank does not mean zero. Put the zero in the minimum or you will have troubles. The record will still be required. Blank means 1.(I think)

Good luck, Let me know if you find other issues?