Create SSO Application for Sql Server in Biztalk

1:Open SSO Administration

2: Create Affiliate Application:

3: Write Application Information , say DBAccess .

4 : Specify Application User . 

5: Open SSO Utility 

6: set Credentials (if using sso for SqlServer, then write sqlserver userid and passwork).

Note : if application will issue sso ticket then check this setting also(SSo Adminstration->System->SystemProperties->Option Tab->Allow Tickets)

How to Assign Ticket to Message

ISSOTicket sso = new ISSOTicket();

Message(BTS.SSOTicket) = sso.IssueTicket(0);