SQL Source
Hello,
I changed my RDM to the SQL2012 source on your server. DB was created successfully, tested connection and DB okay.
However, I cannot make ANY changes in the UI. Under Administrators everything is grayed out, cannot create groups or anything.
The user (me) has a datareader and datawriter access to that DB (in SQL management studio).
What am I missing?
All Comments (7)
Hello,
What version of RDM are you using?
Best regards,
Mark Beausejour
Hi,
Are you DBOwner of the database? You can verify in the RDM about if you are?
Regards
David Hervieux
Hello,
Could you post a print screen of your File -> My Data Source Information report please.
Best regards,
Jeff Dagenais
Here it is.
rdmsql.JPG
Hmm, maybe figured it out. It might be important to mention, I created the database on the server, using the RDM and logged in as an Administrator. As my user, I have no rights to create a DB.
I think I might have to add permissions on the server, using Admin-Account (or from my WS, doesn't matter), and give full permissions to me.
Hello,
Your print screen illustrate the information of a SQLite data source, not a SQL Server data source.
It really looks like your user is missing some permissions.
I don't know if you have access to the credentials of the SA account on your SQL Server, but if yes, you can create/connect to the database with this account in RDM and create your admin user via the Administration -> Users menu. This should provide you the proper rights.
Best regards,
Jeff Dagenais
Could have SA, but not desired.
However, what I wrote above is what it really was: the DB had only one Admin, that was the "Administrator", the user that created the DB. I didn't think that I'll have to give my user, who is Admin too, Admin-Rights... lots of Admin-Words here :)
Many thanks.