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 |
|
kirknew2SQL
Posting Yak Master
194 Posts |
 Posted - 2008-01-31 : 20:11:33
|
| I need to add a user to the server. I have heard that there is a wizard. But I can't find how tolaunch it. How do I add/remove users? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-31 : 23:22:02
|
| Right click on login under security in ssms then choose new login. |
 |
|
|
kirknew2SQL
Posting Yak Master
194 Posts |
Posted - 2008-02-01 : 09:57:25
|
| Found it. :) thank you |
|
|
|
CShaw
Yak Posting Veteran
65 Posts |
Posted - 2008-02-02 : 01:01:28
|
| To remove a user just select that user and delete it. You may run into issues if the user owns objects. If that is the case I would disable the account is AD or reset the password in SQL Server if you can not change the object owner.Chris Shawwww.SQLonCall.com |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-02 : 01:12:37
|
| Not the case in sql2k5, just change schema owner to other db user. |
|
|
|
CShaw
Yak Posting Veteran
65 Posts |
Posted - 2008-02-02 : 20:48:04
|
| Correct, I was thinking SQL Server 2k. My fault, looks like I need to pay closer attention to the group the question was posted in. Thanks rmiao.Chris Shawwww.SQLonCall.com |
|
|
|
|
|
|
How to create a new login?