This is an old revision of the document!
When you receive the Connection to the database is lost: contact your system administrator, the solution is below.
First, log onto SAP System Landscape Directory. Find the database with the issue and note the exact database user starting with B1_. There could be many so be sure to note it exactly. It can be helpful to highlight and copy the username.
Open SQL Management Studio Open the database → Security and find that user. If it’s there, delete it.
Now go to the Principle Security section beneath all of the databases. Expand logins. Tip – it’s helpful to filter and then paste your user name from SLD.
Double click. Click User Mapping. Find the database in the list.
You need to add dbo as the default schema and click db_owner as on the DB role relationship
