Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am unable to set password to SQL server database. Please advise how to do it.

share

migration rejected from stackoverflow.com Mar 21 at 14:25

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as off-topic by Ward, mdpc, fuero, MadHatter, Jim B Mar 21 at 14:25

This question appears to be off-topic. The users who voted to close gave this specific reason:

If this question can be reworded to fit the rules in the help center, please edit the question.

2  
Your question belongs on ServerFault. You also might consider expanding your description to include things such as what you've tried, which error messages you are seeing, whether you have an unusual setup and so on. – spender Nov 12 '10 at 10:35
    
Do you mean to the server itself, or to a specific database? – IamIC Nov 12 '10 at 10:35
    
to a specific database so if copied, no one could open it – Anonymous Nov 12 '10 at 12:08
    
What SQL server? There are many. – John Gardeniers Nov 13 '10 at 21:13
    
The sql-server tag indicates Microsoft. The other platforms all have specific tags as well. – mrdenny Sep 23 '11 at 20:54

In SQL server, there is nothing like "password for database". What you need to do is that create a "login", set it's password and then assign this login the appropriate permissions. While getting the data request is authenticated only at server level. Once a user is logged in the server, he can access all databases, and can perform all tasks for that he is authorized without any credential check any more.

share

Read about "ALTER Login" in help file

share

Just click on "Logins" object beneath "Security" which is itself beneath the SQL Server object. then Right click on the "SA" account on the right window pane and change the password accordingly.

share