Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
anupalavila
Yak Posting Veteran
56 Posts |
 Posted - 2008-10-15 : 00:54:46
|
| Hai, In my sqlserver2000 I have SQL server authentication with username sa and password admin,this username and password is known to all users who are accessing the my sqlserver200, working on different databases in it. I have created a new database and I want to protect the newly created database with a username and password.Thanks and Regards Anu Palavila |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-15 : 10:46:57
|
| Why are you giving sa username and password here? If they know sa username and password, then there is no way you can protect them as they are sysadmin. |
 |
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2008-10-15 : 17:43:48
|
| SA is much more than a username for accessing a database.Create several users in Security\Logins, assign those users to databases with permissions relavent to what they need to do, read write etc.Give these new users accounts to those whom need to check them. Have them update thier connection strings and registrations, test the connection.Then change the SA password.Remember when you change the SA password, everyone will be disconnected. |
|
|
|
|
|
|
How to protect the newly created database