hi, i have two problems:

problem 1:
I have a web application, this application access an sql server. the database will be moved from time to time.
I need to know if it is possible to type in the location of the database server into a text box or something and then start using the system?

problem 2:
how do i view what roles the user that has logged into my system has, i wish to limit what is displayed on a web page if a user with a certain role is logged in, i know how to do it using the domain or the user name, but not the role.

please help if you can
thanks
tom.