SQL Server permissions

Published 14 years ago

Hello experts,
I am switching from a local Access database to a SQL Server database using SQL Server 2008 R2 Enterprise configured with Intergrated authentication only.
Which permissions are required for Active Directory users connecting to the RDM SQL Server database from within SQL Server management studio ?
Thank you and have a great day.
Massimiliano

All Comments (3)

David Hervieux

Published 14 years ago

Hi,
They need to have access to the database in read / write. You also need to create them from RDM because the application has to add the user entry in his database.

David Hervieux

massimiliano.rizzi

Published 14 years ago

Hi there,
thank you for your quick reply.
As per your reply are db_datareader and db_datawriter permissions enough within SQLServer ?
Since the creation of the empty database is not supported from within RDM when using Windows Authentication, I guess the only way to get started is manually creating the database from within SQL Server Management Studio.
Thanks & Regards,

David Hervieux

Published 14 years ago

Hi,
I think it's enough.

David Hervieux