SmartConnect 2010 uses Active Directory-based security instead of SQL security. This has caused some confusion among partners who are used to the ‘sa’ user being able to access everything.
Read more: SmartConnect and Active Directory