1 Replies - 10415 Views - Last Post: 18 February 2008 - 10:42 AM Rate Topic: ***** 1 Votes

#1 lalit_84m  Icon User is offline

  • New D.I.C Head

Reputation: 2
  • View blog
  • Posts: 9
  • Joined: 07-January 08

set database password in sql server 2000

Post icon  Posted 18 February 2008 - 02:13 AM

please tell me that how can we set the password on sql server 2000 database
so other person can not open the my database

Is This A Good Question/Topic? 0
  • +

Replies To: set database password in sql server 2000

#2 PsychoCoder  Icon User is offline

  • Google.Sucks.Init(true);
  • member icon

Reputation: 1641
  • View blog
  • Posts: 19,853
  • Joined: 26-July 07

Re: set database password in sql server 2000

Posted 18 February 2008 - 10:42 AM

Since you're using SQL 2000, open up Enterprise Manager, once that is open select the server you wish to modify (click the little plus sign next to its name), then open the Security plus sign, then select Logins, and in the right pane will be all the logins for that server.

Right-click on the login you wish to change and select Properties, this will open a new dialog where you can modify that login. Look at the screenshot below to see how to get to the Logins section.
Hope this helps :)

Attached Image
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1