Help with Login Script

Question

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

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

dbafromthecold@gmail.com SSChampion Points: 10160 More actions · Answer 1

What about this:-

CREATE TABLE dbo.UserNames

(UserID INT IDENTITY(1,1) PRIMARY KEY,

UserName SYSNAME);

INSERT INTO dbo.UserNames

SELECT 'User1'

UNION

SELECT 'User2'

--etc

SELECT 'CREATE LOGIN ' + UserName + ' FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[English]'

FROM dbo.UserNames

It's a bit of effort to get setup but should allow you to generate the statement all at once quickly.

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

Before I provide a script, I have a question:

Are all these Logins going to have the same access to the server and database?

If they are you should create an active directory group for them and just create one login on the SQL Server for the group.

Here's a fairly simple script that generates the CREATE LOGIN:

DECLARE @counter TINYINT = 1

DECLARE @sql NVARCHAR(500) = N'CREATE LOGIN user<N> FROM WINDOWS'

WHILE @counter <=20

BEGIN;

DECLARE @newSQL NVARCHAR(500) = REPLACE(@sql, '<N>', CONVERT(NVARCHAR(2), @counter));

PRINT @newSQL;

--EXEC (@newSQL);

SET @counter += 1;

END;

Notice the EXEC is commented out because I don't have those users in my domain.

thartson SSC Enthusiast Points: 110 More actions · Answer 3

Wow!

Thank you Jack.

This is great -

No AD in this case (one of those rare situations).

These are logins unique to each server - same login names across the board, but

different servers.

But this will work nicely.

thanks again.

have a great day!