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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-10-13 : 08:21:52
|
| Amanda writes "We are converting all of our VB applications to use SQL database roles. I would like to make this as painless as possible. Is there a way to add NT users to a database role through Visual Basic?" |
|
|
JuniorProgrammer
Starting Member
10 Posts |
Posted - 2003-10-13 : 11:21:51
|
| I have figured out how to use the sp_addlogin stored procedure to add login id's with passwords. However, I am needing to add NT users. When I try to do this, I receive an error that an invalid character is being used. How can I add a login using a trusted connection instead of a password? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-13 : 12:31:45
|
| Amanda, take a look at sp_addrolemember. sp_grantlogin might be needed too.JuniorProgrammer, use sp_grantlogin instead.Tara |
|
|
|
JuniorProgrammer
Starting Member
10 Posts |
Posted - 2003-10-13 : 13:38:25
|
That's exactly what I needed. Thanks!  |
|
|
|
|
|
|
Adding SQL Database Roles Through VB