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 |
|
ann
Posting Yak Master
220 Posts |
 Posted - 2008-02-11 : 09:57:20
|
| I am new to sql server 2005. I need to create a user that can execute sp.'s (user name/pass get passed in from application).On 2000 I create a security login, and then add that to the db users - I can't seem to figure out how to do this in 2005 - can someone pls point me in right direction -thanks |
|
|
tprupsis
Yak Posting Veteran
88 Posts |
Posted - 2008-02-11 : 11:53:42
|
| You basically do it the same way. Create a server login in SQL Server Management Studio under Security > Logins. When you create the login, click the User Mapping page and select your database. This will automatically create a user in that database. Then you can add permissions to database roles for the user from that same page. |
 |
|
|
ann
Posting Yak Master
220 Posts |
Posted - 2008-02-11 : 13:56:48
|
| Thanks |
|
|
|
|
|
|
New to 2005