How to create SQL Server users/permission in VB.NET? 1

[nabiS2K]

I am writing a VB.Net app that I will convert from an MS Access back-end to a MSDE/SQL Server 2000 back-end. user to connect to the data...

Can some explain how to create user profiles for permissions to the server and then to the specified database? I have found a little help with creating database users, but this does not help if the user is not already a user for the server.

Any help is greatly appreciated.

Thanks,
MK

 

[MDXer]

To add domain accounts use

EXEC sp_grantlogin 'Corporate\BobJ'

sp_grantdbaccess will allow you to grant access to a DB. if you look at sp_ in BOL it should provide you with what you need.

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck

 

[nabiS2K]

Actually, this was not what I needed but it did point me in the right direction.

I will use sp_addlogin so I can create SQL Server users.

Thanks,
MK