How do I determine SQL Server Authentication Mode?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to implement ComboBox.FindValue 6
How do I assign to an array variable? 3
How do I get sorted key/value pairs from a hastable 1
How do I set a property which is an object? 3
How to pass System.Type 2
How to deserialize a revised object? 2
SQL Server Authentication issues! 6
BMC 2007 install fails during SQL Server 2005 Express install 5

Back
Top