Home > IT Answers > SQL Server > How to create a user login and password in En...
Help

Question

  Asked: Oct 10 2007   8:45 PM GMT
  Asked by: Tian8168

How to create a user login and password in Enterprised Manager in SQL server 2000


SQL Server 2000, Enterprise Manager, Password

Hello,

I am new SQL server DBA. I can create a new user. The request came in also ask for the password. Is there anyone can help me on how to set password to a user in in Enterprised Manager in SQL server 2000?

Thanks,

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Nov 2 2007  5:01 AM GMT  by Mrdenny




Under the server, open security, then logins. If it's a SQL Login you can set the password here. If it's a Windows login the password would be the domain password and has to be set by the user or the domain administrator.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on SQL Server, Database and Security.

Looking for relevant SQL Server Whitepapers? Visit the SearchSQLServer.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

BrentSheets  |   Oct 11 2007  1:32AM GMT

Tian8168, you used a tag of “Tina” which has nothing to do with your question. When ITKE members want to answer SQL Server questions, they generally look under SQL Server, not Tina :-) So to get an answer, you should use tags that best categorize your question. I’ll fix this for you on this question. Thanks.