Stainless steel welding has been widely used in industrial manufacturing, and friction stir welding has been recognized to reduce production costs significantly. To fully utilize the different properties of 2507 super duplex stainless steel (SDSS) and 317L austenitic stainless steel (ASS), the mechanical and surface properties of 2507 SDSS and 317L ASS dissimilar stainless steel joints were improved using the friction stir welding (FSW) method. The influence of rotation speed on the microstructural characteristics, mechanical properties, and corrosion behavior of the weld joints was investigated by welding at a constant speed of 20 mm/min within the range of 300–600 rpm. Specifically, at 400 rpm, a welded joint with optimal performance was obtained. When the rotation speed is 400 rpm, the yield strength (YS) and ultimate tensile strength (UTS) of the welding joint are 493 and 692 MPa, respectively, and the elongation (EL) is 32 %. The tensile strength is higher than 317L ASS but lower than 2507 SDSS, the EL is lower than those of 317L ASS and 2507 SDSS, and the friction coefficient of the welded joint is 0.93, which is between 317L ASS and 2507 SDSS. Notably, the refinement of grains in the stirred zone significantly improved the corrosion resistance of the welded joint, considerably exceeding that of the 317L ASS but still lower than the 2507 SDSS. This work can provide a process reference for studying the mechanical and corrosion properties of dissimilar stainless steel FSW.