CODEWITHSUNDEEP
sqlsecuritysql-server-2000
Shiva
Shiva

Reputation: 1

How do I create a user account in SQL Server 2000?

My project needs a SQL Server 2000 User Id and password created for an ASP.NET website. How do I create a user account in SQL Server 2000?

Upvotes: 0

Views: 3595

Answers (2)

gbn
gbn

Reputation: 432471

Basically, you'll have to run the system stored proc sp_addlogin.

See Example "A" in the link.

Upvotes: 1

monksy
monksy

Reputation: 14234

I've always used the SQL-Enterprise manager to create the user accounts and set the permissions for the databases and the access. See this intro tutorial.

Upvotes: 0

Related Questions