on 02-01-2016 8:39 AM
Hi
I am doing a system copy of content server from a Win2003 system to a Win2012 system.
These are the steps
Installed cs 6.40 on win2012
backup database on old cs
recovery of database with backup of old system
All runs fine and documents can be accessed from SAP
Now I want to setup dbacockpit.
using user control for dbm connection
usin user sapr3 for sql
The dbm connection is fine, but the sql connection cant be made.
Looked like a user/pw issue, but I am able to logon to database with SAPR3/SAP so the password seems ok.
I tried to connect a system which I just installed and did not do the db recovery on, used CONTROL and SAPR3 and that one got setup OK.
Can I just reset the SAPR3 password to SAP in the maxdb? Do I have to update the password in SAP ERP too somewhere?
Or isnt the user/password not the issue?
Thanks
Sander
Hi Gemert,
what is the error? Can you show me with the screenshot?
Generally you can maintain the right password in dbco, or dbacockpit database connections.
If the password you used can log on database manually, then I do not think reset password helps, it should be the password was wrongly maintained in somewhere.
Best regards,
James
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi James,
thank you for your quick reply.
I did some further investigation.
Seems the SAPR3 schema is not there.
This is what happened:
Installed Content Server D71 with MAXdb 7.9.08.23
Restored backup of old Content Server D70 on this database
Exchanged certificates
Repositories can be used in ERP.
I now installed P71 Content Server. This one still has the default installationi databsae, so no restore has been done.
In Database Studio, If I logon to D71 with SAPR3, I dont see roles, schemas etc. below SAPR3
But for P71 (still with the default database) I do see roles, schemas etc
Did some authorizations got removed from user SAPR3?
Thanks
Sander
Hi James,
Note 1657257 - MaxDB-specific system copy: wrong SYSDBA solved the issue
because of the db copy something went wrong.
I did the following
Set the password of the superdba user to the password specified in the system copy:
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.