The "All water" license is good for both fresh and salt water. You can use the CT license on Long Island Sound in NY waters as part of the reciprocal agreement with NY. RI is not going with their own license, they are going to default to the Federal Registry. Based on what I have read, you will be able to fish in RI waters with a CT salt or all waters license.

(From the DEP FAQ website)

What is a reciprocal license privilege? (Is there reciprocity with any other states?)
Connecticut law allows non-resident anglers who hold a marine waters fishing license in New York, Rhode Island, Massachusetts, New Hampshire or Maine to fish in the marine district and land marine fish in this state without a Connecticut license provided the state issuing the marine license affords the same privilege to resident Connecticut marine license holders.


Can I fish in federal waters or in another state’s waters with a Connecticut Marine Waters license?

Federal waters: Federal registration is not required until January 1, 2010. Thereafter, CT Marine Waters fishing license holders will be exempt from the federal registry requirement. The CT Marine Waters Fishing License law was crafted to meet the federal criteria necessary to exempt our license holders from the federal registry.
New York: A saltwater license is not required for New York waters until October 1, 2009. Thereafter, New York will permit CT Marine Waters license holders to fish in the waters of Long Island Sound lying between NY and CT. Reciprocal privileges in other New York waters (ex. Block Island Sound) still need to be determined by New York officials.
NH: A saltwater license is not required for New Hampshire waters until January 1, 2011. There is no reciprocity with CT.
RI, MA, ME do not have marine license laws yet, so it is not possible to provide an answer for these waters. We will update this page as information becomes available for each state. (RI is going with the Federal Registry)