You will only need two connection strings if your planning to run stored procedures from both databases.

Otherwise just use the one connection, as your stored procedure will be doing the join across the databases.

Make sure the username you use has access rights to both databases.