Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Client server connectivity Expand / Collapse
Author
Message
Posted Thursday, September 10, 2009 9:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 9, 2009 9:01 PM
Points: 3, Visits: 11
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.
Post #785774
Posted Thursday, September 10, 2009 9:22 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 7:53 PM
Points: 12,896, Visits: 32,095
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
Post #785789
Posted Thursday, September 10, 2009 12:51 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 9, 2009 9:01 PM
Points: 3, Visits: 11
Thanks for the reply sir.
what happens when i change the server password? doesn't it affect anyway?
pl let me know.
Post #785917
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse