Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
reyboy
Starting Member
12 Posts |
 Posted - 2004-10-27 : 04:00:18
|
| How do we change the SQL Server Authentification in Visual basic or batch file?Is it do able in remote computer?Proud To Be Pinoy |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2004-10-27 : 04:48:33
|
| server authentication mode is set at the server side. so don't think it can be done in vb.. u can change it for a remote computer by right clicking the server in EM and changing the authentication mode under the securities tab.He is a fool for five minutes who asks , but who does not ask remains a fool for life!http://www.sqldude.4t.comhttp://www.sqljunkies.com/weblog/sqldude |
 |
|
|
surefooted
Posting Yak Master
188 Posts |
Posted - 2004-10-27 : 11:17:11
|
It can be done in vb, look up the IntegratedSecurity Object in books online.-JonShould still be a "Starting Member"  . |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-27 : 21:59:49
|
quote:
Originally posted by surefooted
It can be done in vb, look up the IntegratedSecurity Object in books online.-JonShould still be a "Starting Member" .
does it change the authentication mode? IMHO, you should not be doing this nor thinking about it, you may get into a lot of trouble especially if you have "windows" users, roles, jobs depending on these users, replication, just to name a few.or is that your intention? --------------------keeping it simple... |
|
|
|
|
|
|
SQL Server Authentication