I'm in the process of using ECT and the data is in a sql sever. Before i get started is this possible with no kerberos existing in this current environment. So the service where SP resides is different from the Sql Server service. Can i use a slq server login with ECT. Thanks in Advance
You can use Secure Store Service if you don't want to use kerberos.
Check this out : http://msdn.microsoft.com/en-us/library/ie/ee556780.aspx
Yes, it can be done. Follow the steps in this blog post for more information.