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
mattphungAsked:
Who is Participating?
 
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
 
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.