a vb.net form/code that does the following.
interface doesnt have to be great, im just after the code!
1) checks if an sql server (MSDE) is running on a system (via hostname/ip), i can try opening the db witha try block, but it 'hangs for a bit', so i want this done with faster code (possible check if computer exists on network first?)
2) Requests login/password off a person, then connects to the database on the sql server called 'MP' (using the login/password supplied) - default sql authentication. and lists all the users and their permissions on the user created tables.
it should allow the 'changing of permissions', (i.e. no select for user y on table x), addition of users, ability to change passwords.
basically something like enterprise server providers for adding/removing users/changign permissions.
sql server/MSDE will be running on 2k/xp.