Devolutions inc. > Forum

2/3/2012 3:44:24 AM massimiliano.rizzi Posts: 3	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
	0 • permalink
2/3/2012 5:07:59 AM David Hervieux Administrator Posts: 4241	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 Devolutions inc.
	0 • permalink
2/3/2012 6:55:36 AM massimiliano.rizzi Posts: 3	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,
	0 • permalink
2/3/2012 2:18:32 PM David Hervieux Administrator Posts: 4241	Hi, I think it's enough. -- David Hervieux Devolutions inc.
	0 • permalink

---