have a client server application. Server password is changed every week. what are the different options to provide the new password to the client to connect to the server. please note that there ar multiple clients. Each client may or may not connect to the server every day.

create an role or an application role,and add the windows users to the role? then they never need to touch the server password, they just have to have access to the network.if they are not in the application role, they could not get to the database anyway thru their regular logins.

Lowell--There is no spoon, and there's no default ORDER BY in sql server either.Actually, Common Sense is so rare, it should be considered a Superpower. --my son