[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 161
  • Last Modified:

setting up integrated security for desktop application

I'm writing a desktop application and need to setup integrated security for communicating with the database. I have googled it to try to learn how to do this. Can someone point me in the right direction? Refer me to a tutorial? Anything? thanks
0
mattphung
Asked:
mattphung
  • 3
  • 2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
http://msdn2.microsoft.com/en-us/library/ms189751.aspx

in sql server 2005, you create a login for windows authentication like this:
CREATE LOGIN [domain_name\domain_username] FROM WINDOWS;

as from that point, that login is like any other login in sql server, but the connection string does not (cannot) refer to it directly.
0
 
mattphungAuthor Commented:
How do I know my domain_name and domain_username? How do I create them? thanks
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you windows domain name, and your windows account name.
you should know those? if not, ask your network administrator
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
mattphungAuthor Commented:
I'm working for myself so i guess I'm the network admin and the janitor too :)
I'm hosting my db thru a hosting company so do they give me the info?
0
 
TyrannusCommented:
According to current information, it seems you will be using Windows for your application and SQL for your database. It is still unclear as to what you are trying to do. Please give the following information...

OS?
Programming Language?
Database application or web page?
SQL?
Objective?
0
 
mattphungAuthor Commented:
Tyrannus-
OS?
 Windows
Programming Language?
VB.net
Database application or web page?
Desktop application
SQL?
SQL 2005
Objective?
I want to create a secure login form. Currently, I have an ecnrypted connection string in the app config file but I learned that a hacker can use a memory sniffer to get the connection string information once it's decrypted and put into memory for use. Please advice the best solution for this. Thanks
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now