Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
sp_addlogin Password Protection 1
- Thread starter perrymans
- Start date
-
1
- #2
dbalearner
Technical User
Try isql with -X option
isql -U${USERNAME} -P${PASSWORD} -S${SERVER_NAME}
-w1000 -X
exec sp_addlogin <LOGIN_NAME>,<PASSWORD>,<DATABASE>, ...
go
-X specifies that, in the connection to the server, the application initiates the login with client-side password encryption
HTH,
Learner
isql -U${USERNAME} -P${PASSWORD} -S${SERVER_NAME}
-w1000 -X
exec sp_addlogin <LOGIN_NAME>,<PASSWORD>,<DATABASE>, ...
go
-X specifies that, in the connection to the server, the application initiates the login with client-side password encryption
HTH,
Learner
- Status