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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Type of authentication

Author  Topic 

hrishi_des
Yak Posting Veteran

76 Posts

Posted - 2007-02-14 : 01:23:37
Hi,

How can i find without connceting to the remote server what is the type of authentication i.e. integrated, sql or mixed. DMO offers a method serverloginmode but it doesn't work.

any other approch?

Many thanks,
Hrishikesh

When solution is simple, God is answering….

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-02-14 : 01:28:16
there are 2 mode of authentication
- Windows Authentication
- Mix Authentication (meaning SQL & Windows Authentication)

So Windows Authentication should work


KH

Go to Top of Page

hrishi_des
Yak Posting Veteran

76 Posts

Posted - 2007-02-14 : 01:38:17
Hi KH,

Thanks for the info but is it possible to find what is the type of authetication remote server supports without logging to the server?

Many thanks,
Hrishikesh

When solution is simple, God is answering….
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-02-16 : 08:49:22
Continued here http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=79193


Peter Larsson
Helsingborg, Sweden
Go to Top of Page
   

- Advertisement -