Client server connectivity

  • SQL Kid-1137444

    Valued Member

    Points: 59

    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.

  • Lowell

    SSC Guru

    Points: 323331

    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


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • SQL Kid-1137444

    Valued Member

    Points: 59

    Thanks for the reply sir.

    what happens when i change the server password? doesn't it affect anyway?

    pl let me know.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply