I have just setup the RDM server following the tutorial information,
the rdms connects to the management console on the same server and i can create users (AD) but i cannot connect to the data base (it tests ok) but on connection i get a baseservice.samx error and a comment about invalid session provider.
unfortunately the message doesnt fit in the RDM error window so is hard to read.
i also cannot to the server via http on a remote workstation:
Cannot open database "RDMSDB" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
any pointers greatly appreciated
Maurice will come back to you with more details but the error is caused by the Integrated Security. You need to give access to the database for NETWORK SERVICE or change the RDMS configuration to use a built-in user.
Here you go