Printable View
Help!
I'm trying to add new sql server users at run time from a vb app. I am trying to use sp_addlogin which works from query analyser but won't work from vb. The user I'm using is a member of sysadmin and security admin but it won't work. Any ideas or alternatives?
In the SQL Server help - Contents -> Building SQL Server Applications -> SQL-DMO -> Collections -> L -> Logins Collection.
I don't know anything about SQL-DMO. I have been using ADO so far in the application. If possible I'd like to find a solution using ADO. If your solution can be done using ADO then maybe you could tell me a bit more. Thanks.
Nope, SQL-DMO is quite separate to ADO.