Question

Programmatically Setup SQL Permissions From Windows App?

Asked by: kvnsdr

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?

This question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.

Subscribe now for full access to Experts Exchange and get

Instant Access to this Solution

  • Plus...
  • 30 Day FREE access, no risk, no obligation
  • Collaborate with the world's top tech experts
  • Unlimited access to our exclusive solution database
  • Never be left without tech help again

Subscribe Now

Sign Up Now!
Asked On
2007-09-27 at 08:14:41ID: 22856885
Topics

C# Programming Language

,

MS SQL Server

Participating Experts
3
Points
500
Comments
9

Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.

Companies like CVS, Honeywell, Chevron, Toyoto, TriStar Pictures, the U.S. Army, and Accenture

Your Complete Technology Resource

900+ topic areas (and counting)

Related Solutions

  1. SQLExpress
    I logined as Admin and installed SQLExpress on my Station. Can other users use Query Analizer to query records on my station?
Tutorials are great ways to tackle hard problems!

Featured Articles

Read through articles written by top experts!

Get full access to the help you need.

Subscribe Now

30-day free trial. Register in 60 seconds.

The Latest Technology News and Tips

Your answer is only minutes away!

New Solutions Everyday

Because of our active community of experts, on average new questions receive their first comment in under 30 minutes.

Top C# Questions

       

Hear What our Users are Saying

Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Try it out and discover for yourself.

Subscribe Now

30-day free trial. Register in 60 seconds.

20130221-EE-VQP-039

3 Ways to Join

30-Day Free Trial

Why Experts Exchange?

Trusted by 44 of the Top Fortune 50 Companies. Verizon, Bank of America, IBM, Windows, Dell, Target, Boeing, Comcast, AT&T

Why Experts Exchange?

The go-to tech resource for hundreds of thousands.

"With the help of Experts Exchange -- I have been able to meet my deadlines and produce effective products"

Jan Miller

"I just today started my third contract assignment which I attribute to the skills I am learning from other experts."

Robert Antonellis

"It's my sole resource as I'm kind of an MS Access loner at my company. It's like having colleagues available when I run out of my own steam."

Karen Ruskin

Why Experts Exchange?

50K Tech Experts available to help

Leew has been an expert here since 1997 and is a master at Windows 2000 and XP, hard drives/storage and Small Business Server.

lrmoore has been an expert here since 2000 and is a six-time Microsoft MVP with over 18 years experience in the networking industry.

angeliii has been an expert here since 2000 and is a Microsoft MVP for his work with MS SQL Server and Development

Why Experts Exchange?

3 Million+ Questions Solved

"The experts approach solutions with patience and innovative ideas, and ultimately I have my problem solved."

Gary Serkhoshian

"Most every situation is already posted and answered, a quick search usually gives a solution. EE is truly a bargain."

Bob Schatzman

"9 out of 10 times Experts Exchange has the accepted solution or an open discussion of the potential solutions to the problem."

Kenny Red

Why Experts Exchange?

Serving tech professionals since 1996.

At Experts Exchange, we treat each question as unique and deserving of an answer.

As one of the most enduring technology resources, our community knows the importance of helping each individual with their problem, no matter how complex or how simple. We're here to collaborate with you.

Business Account Plans