Note: SRM has technical requirement to use database schema having the same name as DB user.
Here is the script to prepare MS-SQL database (SITE-A-SRM), schema (SRMlogin) and DB user (SRMlogin) with password (SRMpassword) for SRM:
CREATE DATABASE [SITE-A-SRM];I hope it is obvious to everybody that the same procedure (probably with little bit different colored items) must be done in database on SITE-B for second SRM instance.
CREATE LOGIN [SRMlogin] WITH PASSWORD=N'SRMpassword', DEFAULT_DATABASE=[SITE-A-SRM], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
EXEC sp_changedbowner 'SRMlogin'
EXEC sp_executesql N'CREATE SCHEMA SRMlogin'
I generally believe that scripts are better, faster, more consistent and less error-prone then manually creating something via GUI.
Credits: SQL script has been created by customer's database admin (Ladislav Hajek) contributing with me on SRM project.