How do I determine SQL Server Authentication Mode?

[Hal Heinrich]

Given a server name, and before logging on to the server - how can I tell if
it's using Windows Authentication Mode or SQL Server Authentication?

I'm retreiving a list of servers as follows:
Dim dmoApp As SQLDMO.Application, dmoServerList As SQLDMO.NameList, srvrNm
As String
dmoApp = New SQLDMO.Application
dmoServerList = dmoApp.ListAvailableSQLServers
For i As Integer = 1 To dmoServerList.Count
srvrNm = dmoServerList.Item(i)
Next i

Thanks in advance for your help,
Hal Heinrich
VP Technology
Aralan Solutions Inc.

[Mary Chipman]

I'm not sure if that information is available before you actually
connect to a server -- I don't think it is. However, your best shot at
getting a definitive answer is to post in one of the SQL Server
newsgroups.

--Mary

On Mon, 17 Jan 2005 15:41:04 -0800, Hal Heinrich
<Ha*********@discussions.microsoft.com> wrote:

Given a server name, and before logging on to the server - how can I tell if
it's using Windows Authentication Mode or SQL Server Authentication?

I'm retreiving a list of servers as follows:
Dim dmoApp As SQLDMO.Application, dmoServerList As SQLDMO.NameList, srvrNm
As String
dmoApp = New SQLDMO.Application
dmoServerList = dmoApp.ListAvailableSQLServers
For i As Integer = 1 To dmoServerList.Count
srvrNm = dmoServerList.Item(i)
Next i

Thanks in advance for your help,
Hal Heinrich
VP Technology
Aralan Solutions Inc.

[Hal Heinrich]

Thank you for replying. I've posted it to sqlserver.programming.

Hal

"Mary Chipman" wrote:

I'm not sure if that information is available before you actually
connect to a server -- I don't think it is. However, your best shot at
getting a definitive answer is to post in one of the SQL Server
newsgroups.

--Mary

On Mon, 17 Jan 2005 15:41:04 -0800, Hal Heinrich
<Ha*********@discussions.microsoft.com> wrote:

Given a server name, and before logging on to the server - how can I tell if
it's using Windows Authentication Mode or SQL Server Authentication?

I'm retreiving a list of servers as follows:
Dim dmoApp As SQLDMO.Application, dmoServerList As SQLDMO.NameList, srvrNm
As String
dmoApp = New SQLDMO.Application
dmoServerList = dmoApp.ListAvailableSQLServers
For i As Integer = 1 To dmoServerList.Count
srvrNm = dmoServerList.Item(i)
Next i

Thanks in advance for your help,
Hal Heinrich
VP Technology
Aralan Solutions Inc.