New Install - Unable to Create Users In RDM or Connect To local SQL

New Install - Unable to Create Users In RDM or Connect To local SQL

avatar

I have installed RDM and upgraded to 10.6.3.0. I then create a new DB through RDM (as SA or a Windows User) and then try to create a user inside RDM. I select Integrated Security, define my user and click OK. I then get the error Invalid object name 'dbo.syslogins', and cannot save the user.

Server is Windows 2008 R2 SP1 with SQL 2008 R2 SP2.

edited by rtayler@epicor.com on 6/15/2015

All Comments (3)

avatar

Hello,

I cannot reproduce the issue locally. What edition/version of SQL are you running?

Do you have anything relevant is Help - View Application Log? A call stack would help us.

Best regards,

Maurice

avatar

I am running SQL 2008 R2 SP2 Enterprise.

I attached the application log. I removed the domain and user info. I have been working on this for days, so if you want a cleaner log with specific tests, let me know.

avatar

We are working on a fix, in the meantime a workaround would be to manually create the login in SQL server. Here are the steps:

Make sure you are connected on master, not the RDM database

create login user_3 with password='mypassword';Now in RDM, click new user, enter the information and hit "OK".

You will get a warning "The password can't be set because the login already exists, but the user was created successfully!" You can ignore it and click OK.

You can now use that user. It's not perfect but it works.

Stéfane Lavergne