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 |
|
asm
Posting Yak Master
140 Posts |
 Posted - 2007-06-07 : 01:17:51
|
| HiI remove the windows authentication from enterprise manager. and Now i want to re-assign the the windows authentication . so can i do it from query analyzer.asm |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-06-07 : 12:05:28
|
| not sure if there is a T-SQL equivalent. But you can do the following and have profiler running in parallen to see how SQL Server does this.To change security authentication modeIn SQL Server Management Studio Object Explorer, right-click the server, and then click Properties.On the Security page, under Server authentication, select the new server authentication mode, and then click OK.In the SQL Server Management Studio dialog box, click OK, to acknowledge the need to restart SQL ServerDinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-08 : 00:27:19
|
| Or modify registry. |
|
|
|
|
|
|
Windows Authentication