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 |
|
hrishi_des
Yak Posting Veteran
76 Posts |
 Posted - 2007-02-15 : 05:10:32
|
| Hi,How can i find without connceting to the remote server what is the type of authentication i.e. integrated, mixed. DMO offers a method serverloginmode but it doesn't work.any other approch using SMO?Many thanks,HrishikeshWhen solution is simple, God is answering…. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-02-15 : 05:24:00
|
| Use the Crystal Ball?Without connecting to the remote server, there is no way to investigate which authentication mode there is, if it is not written on some paper that you can read.Peter LarssonHelsingborg, Sweden |
 |
|
|
hrishi_des
Yak Posting Veteran
76 Posts |
Posted - 2007-02-15 : 06:26:11
|
| Hi Peso,sorry 4 putting the question that way... i mean is there some other way we can do it, through registry may be?Many Thanks,P.S. we all are having a good laugh for your last answer. we really enjoyed it!!!!When solution is simple, God is answering…. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-02-15 : 07:09:52
|
| Yes you can, but you will still have to connect to the remote server to investigate that too.Check this registry keyHKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServerand the REG_DWORD LoginModePeter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
|
|
how to find type of authentication