Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question

migrated from stackoverflow.com Nov 13 '10 at 17:13

This question came from our site for professional and enthusiast programmers.

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? –  IanC 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

2 Answers 2

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|improve this answer

Read about "ALTER Login" in help file

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.