Import users from excel

[kingsgambit]

I have 200 users to import into sql 2000

I need to import there database username,password and which database they can access

Can I run a script that will read the excel spreadsheet and import the user details

 

[jbenson001]

I would use a DTS package to do this. It is very simple

 

[dhulbert]

You can use DTS to upload your list of user names, passwords and default databases,

You are then going to have to script the creation of your logins

 CREATE LOGIN [TESTUSER] WITH PASSWORD = 'TESTPASSWORD', DEFAULT DATABASE=[MASTER]

Then for each Database you need to create the appropriate users.

 USE [TestDB]
GO
CREATE USER [TestUser] FOR LOGIN [TESTUSER] WITH DEFAULT_SCHEMA=[dbo]
GO

I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)

 

[kingsgambit]

Can you explain more please I am new to sql

How do I upload using DTS what format do I use.

Do I upload into the database I want to users to access?

Why do I have to run the script afterwards if I have uploaded the username, password and database?

 

[markros]

If this is one time deal, you can use Import/Export Wizard. I know how to invoke it from SSMS, but I haven't worked with SQL 2000 for a long time to remember.

PluralSight Learning Library