Programmatically Setup SQL Permissions From Windows App?
Posted on 2007-09-27
I'd link to setup SQL Database users and permissions from a Windows App (VS2005 C#).
I currently have to Install and set SQLExpress 2005 permissions using the (free) Management Studio Express on every computer I install my App.
Would be nice to have a pop-up window (secured) within my Win App that I could simply set new database users and permissions.
I suppose someone else has already done this, but I didn't find anything on the Internet.
I currenly open the Management Studio -> Security -> Logins -> New Login -> <create user then set 'User Mappings'...
I'm using 'Integrated Security' and realize that I need to access the OS (XP-Pro) users and groups, don't know if that's possible.
Q. How can I programmatically (code) setup Users, Groups, Permissions on SQLExpress 2005?