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 |
|
wussupbuddy
Starting Member
16 Posts |
 Posted - 2008-12-02 : 06:08:39
|
| I'm connected to the SQL server using the management studio. I created a new db from the object explorer but can't figure out where to give the password for this db so that noone else can access this db. |
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2008-12-02 : 06:26:08
|
| You should create a login user id. You can then map this user id to whichever db you want to and assign it a passsword. |
 |
|
|
jholovacs
Posting Yak Master
163 Posts |
Posted - 2008-12-02 : 16:13:47
|
| The db itself does not have a password. You have to create users and grant them access. Keep in mind that by default the local administrators group on the server machine has sysadmin privileges (which basically means they have access to everything) so if you're trying to limit access to a specific database and you can't figure out why everyone can still connect, that's probably it.___________________________Geek At Large |
|
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2008-12-02 : 21:09:52
|
| http://msdn.microsoft.com/en-us/library/ms189121.aspx |
|
|
|
wussupbuddy
Starting Member
16 Posts |
Posted - 2008-12-04 : 09:23:33
|
| got it..thnx guys |
|
|
|
|
|
|
Setting the DB Password