Logins

Question

Logins

Niyala

SSCrazy

Points: 2778
More actions
December 4, 2008 at 3:03 am

#128987

Hi all,
I recently installed MS SQL 2008 on a development machine. I would like to create a login account whereby multiple users are allowed to be grouped into a single login account. Is there a mechanism to create such a grouped login account?
A further question I have is whether it is possible to export logins accounts from MS SQL 2005 and import them into MS SQL 2008?
Thanks indeed
Niyala

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 1

You can use SSIS and the Transfer Logins Task to move logins between Servers. You should probably use a Active Directory Group to control grouping of logins.

Jack Corbett SSC Guru Points: 184394 More actions · Answer 2

There is no mechanism in SQL Server to create a Login Group. As Jonathan said, if you want to allow a group of users access to your SQL Server without creating individual logins you would use an AD group. So if you have a 5 person accounting department you would create, if you did not already have, an Accounting AD group, add the 5 users to the group and then allow the Accounting AD group login rights tot he SQL Server.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question