up vote 0 down vote favorite
share [g+] share [fb]

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

link|improve this 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? – 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
feedback

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

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

2 Answers

up vote 3 down vote

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.

link|improve this answer
feedback
up vote 0 down vote

Read about "ALTER Login" in help file

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard