Hi frd's plz help me out..I want to get SQL Server username & pwd frm registry is it possible after getting this I will use it to my connection string to do connection with myDB..How is it possible..
Whthere I m suppose to use a file to store in encrypted format and use it or something else but who this will be usefull on my client pc,it may possible that this work on Server but will it work on client pc..
Exactly what I want,when the user run the appn., App. will connect to DB using what username and pwd specified ffrm first now if the username and pwd of server changes then it will not connect to server and in this case it shld show the server detail form to specify new username and pwd...then verify and connect to DB...
But I m not getting how to handle this user name and pwd will the file technique help me on other client machine...
plz reply soon....

You could just connect using the "Integrated Security" (windows login NT info-based security), and just give the user access to the server as well.

But as far as encrypting the username for the registry or file -- you'd have to use an encryption method that can be reversed, otherwise you couldn't see the password.

If you connect to the server, and the password is rejected, you will receive an error message (although I believe it may actually prompt the user itself for the login info, you'd have to test it out).  If it doesn't prompt the user for a new login/password you could just prompt the user in code for it.

____________________________
Everywhere's Local (classifieds, job postings, & more for everycity in the world - user entered)