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 |
|
khushbu11488
Starting Member
9 Posts |
 Posted - 2012-04-27 : 02:37:38
|
| Hello Friends,,i am using sql server 2005 database ...i want to lock my database int he way that no one can enter in database without perticular Id and Password ..How can i do this??or is there any other way to lock database ....Plz halp me out ...... |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2012-04-27 : 02:41:44
|
| Read about Security, Logins, Users, Server Roles in Books On Line..Senthil Kumar C------------------------------------------------------MCITP - Database Administration SQL SERVER 2008MCTS - Database Development SQL SERVER 2008 |
 |
|
|
vinu.vijayan
Posting Yak Master
227 Posts |
Posted - 2012-04-27 : 03:05:38
|
| This must be what you are looking for:[url]http://technet.microsoft.com/en-us/library/ms171741(v=sql.100).aspx[/url]N 28° 33' 11.93148"E 77° 14' 33.66384" |
|
|
|
khushbu11488
Starting Member
9 Posts |
Posted - 2012-04-27 : 10:25:22
|
quote:
Originally posted by vinu.vijayan
This must be what you are looking for:[url]http://technet.microsoft.com/en-us/library/ms171741(v=sql.100).aspx[/url]N 28° 33' 11.93148"E 77° 14' 33.66384"
hiiiiiiiiiiiiiithanks for reply ..but the syntax shown in the link is not working with sql server 2005  For that what can i do ..plz help me... |
|
|
|
khushbu11488
Starting Member
9 Posts |
Posted - 2012-04-27 : 10:26:25
|
quote:
Originally posted by senthil_nagore
Read about Security, Logins, Users, Server Roles in Books On Line..Senthil Kumar C------------------------------------------------------MCITP - Database Administration SQL SERVER 2008MCTS - Database Development SQL SERVER 2008
thanks...but i am at deadline so want some instant solution ...plz help me |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-04-27 : 10:28:33
|
quote:
Originally posted by khushbu11488
quote:
Originally posted by senthil_nagore
Read about Security, Logins, Users, Server Roles in Books On Line..Senthil Kumar C------------------------------------------------------MCITP - Database Administration SQL SERVER 2008MCTS - Database Development SQL SERVER 2008
thanks...but i am at deadline so want some instant solution ...plz help me
So start reading right now, or hire a consultant to fix it for you. This is basic SQL Server security and not hard to learn.See if this link works: http://technet.microsoft.com/en-us/library/ms171741.aspxP.S. That link is for SQL Server Compact Edition, and won't apply if you're using another edition. The following link is more likely to apply:http://technet.microsoft.com/en-us/library/ms162144.aspxYou can change the version to 2005 using the Other Versions option at the top. |
|
|
|
|
|
|
|
|
Sql Server 2005 Database level Security Lock