Client server connectivity

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Testing Center » SQL Server Security Skills » Client server connectivity

Client server connectivity

Rate Topic

Display Mode

Topic Options

Author

Message

SQL Kid-1137444

Posted Thursday, September 10, 2009 9:12 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, December 09, 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

Lowell

Posted Thursday, September 10, 2009 9:22 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 11:55 AM
Points: 11,625, Visits: 27,684

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

SQL Kid-1137444

Posted Thursday, September 10, 2009 12:51 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, December 09, 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 »

Permissions