We just upgraded from 3.5(4) to 4.0(4)Build 140 on a single CRS server (not co-resident). We now want to upgrade a custom report (stored procedure) from 3.5(4) to 4.0(4). We used to connect to the database using the SA user with a password we spec'd. It appears now that CRSAdministrator is the user defined with access rights to this database. What is the password?
I have this problem too.