We’ve installed BODS 4.0 SP3.
We’ve upgrade our existing repository to new one, created connection to Datastore and it works.
We’ve created JobServer and in CMC we registrated repository (test connection is successfully)
But the problem is in ManagementConsole - after logged in we got information:
.
When I push: Management → Datastore I got information that our user BO1002 has login failed, but we don’t use this user.
When we give rights for this user we get information:
How can I change this user?
I think this our problem and when we change user we can connect to repository database.
the DB User is what is registered in CMC for the repo, Management Console reads the information from CMS
what is the login that you are using to connect to DS MC Administrator or any other useer
can you also check the following
login to Designer as Administrator, and try to connect to a repo
exit designer and logon as any other user and try to connect to same repo, if you get connection error, then I think following SAP Note may help
1758078 - Logon to Data Services Designer fails with Database Error for user login other than Administrator after upgrading to SP3, Data Services 4.0
I will check this user in CMC (CMC → DataServices? Can I change this user in CMS?) My ‘user’: BO1002
it’s the name of server and it’s created by default so I would like to change it to our system user which have all right.
This user starts Data Services service (Administrative tool → Services).
In both situation: in CMC and DS MC I’m using user Administrator.
I can log into Designer as Adminitrator and any other ActiveDirectory user.
Also in CMC in DataServices I can register repo and test is successfully but still I get information
ok, BO1002 is the user defined in CMS it’s not database login, in that case if the test connection is successful, and this CMS User (BO1002) has access (rights ) to DS Repository then it should work fine
I think when DS MC may be getting a incorrect or Database user or password, what is the DS Repository database type ? if it’s SQL Server are you using windows authentication ? if you are using windows authentication then make sure that the tomcat service is running under a windows user that has permission to access the DS Repo
can you post the error you see in the %LINK_DIR%\log\web_admin.log.0 file ? when you logon to DS MC and get this error
where can I check which one user is defined in CMS?
CMC → Servers → CMS? Can I change this user to my default user: UserBO?
I checked and Tomcat is running as LocalSystem so I think it could be the problem. If I change this user into UserBO will I connect to repository Databsae as UserBO?
I’m using SQL Server 2008. Services BusimessObjectsDataServies is running as UserBO, only Tomcat is using other user.
if you are connection to SQL Server using windows authentication then you will have to change the logon under which the tomcat is running
in the CMC when you register the DS repo are you entering the DB Username and Password ? if yes, then you are not using windows authentication so no need to change the tomcat logon
open SQL Server Management Studio and use the same DB User that you use in CMC when registring the DS repo and expand the DI_LOCAL_REPO_TEST_4 database, and try to open any of the tables in that database is that working for you ? may be you don’t have access to the tables in the database
Hi,
It’s working! Thank you. I’ve changed user in Tomcat and now I can log into DataServices MC
But I have one more question - I’ve copied my old repository 3.1 to new one 4.0 and after that I’ve upgraded it to new one. And now after log into DataServices MC I see Status → Adapters - two adapters: one from old one and one new. How can I delete old one?
In Adaper Instances I see 2 adapters also (old and new), when I push new one I got info
(BOB member since 2011-03-03)
(BOB member since 2011-03-03)