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 |
|
X002548
Not Just a Number
15586 Posts |
 Posted - 2005-09-13 : 15:39:52
|
| OK,I just noticed this, and I'm curious.If I use sp_addlogin and sp_adduser, I look in EM and I see the user name and login name the same as domain\user.I expected that to be correct.I then got lazy and added someone in EM at the Login level, selected the database and made the datareader/writer, and then look in EM and all I see is the user name as [name] and the login as domain\user.Am I missing some parameters?Or am I losing my mind?Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-09-13 : 15:51:25
|
| Do you mean sp_grantlogin? sp_grantlogin is for Windows accounts and sp_addlogin is for SQL accounts.Tara |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
madness
Starting Member
13 Posts |
Posted - 2005-09-13 : 17:22:11
|
| When you add a user in EM it defaults to just the user name and drops the domain name by default in each database that you permission it against. It however keeps the domain name for server login. You can type the domain into the databse user name if you wish when adding the login to the database in EM. Id suggest always prefixing the domain name, as it minimises any potenital sql and windows login conflicts. |
|
|
|
|
|
|
sp_addlogin vs EM