How do you set a db wide username/password in SQL 2000?

[jruiseco]

How do you set up a general Username / Password in SQL 2000? FYI, I am using the Enterprise Manager and have the database already set up.

 

[tlbroadbent]

1- You set up a SQL Server login and password.
2- Grant access to the database(s) to the login, thus creating a database user.
3- Grant desired onject permissions to the user in the database.

You can accomplish these tasks with enterprise Manager or Query Analyzer. See SQL BOL for details about implementing security. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.

 

[jruiseco]

Where do I setup a SQL server login and password within the Enterprise Manager?

 

[BeckahC]

Under Security there is Logins, right-click on Logins and select "new login" BeckahC